Henry Xie 's blog
Sunday, February 02, 2014
ORA-01031 insufficient privileges
›
2 possible reasons check password file, if possible, recreate them on all nodes to make them consistent double check password file name ,...
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
‹
›
Home
View web version