Henry Xie 's blog
Monday, January 13, 2014
How To Transfer SCN to Redo Log Sequence
›
Sometimes we need to know date and redo log sequence from SCN When we debug, we know SCN, then we need to know what archive logs and log se...
Wednesday, November 13, 2013
How To Check User Login Information In The Past
›
Use DBA_HIST_ACTIVE_SESS_HISTORY: To get client machine name: SELECT distinct machine FROM DBA_HIST_ACTIVE_SESS_HISTORY To get timefra...
Tuesday, November 12, 2013
Output v$flash_recovery_area_usage is incorrect
›
sometimes we clean recovery area manually , delete archive logs, old files ourselves the output v$flash_recovery_area_usage can be incorre...
Monday, November 11, 2013
How To Display Full Name via crsctl
›
use crsctl stat res -t
Thursday, October 24, 2013
Email SMTP Host DNS MX Record
›
Sometimes the mail gateway is configured as MX record ie test-mail-router.example.com You can't get any IP from nslookup from test-m...
‹
›
Home
View web version