Popular Posts
-
CRS-5019:All OCR locations are on ASM disk groups [DATA], and none of these disk groups are mounted.In my case , from ASM alert.log , actually it is due to ASM failed to start because of ORA-00600 as shown below. ORA-0060...
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
brrestore We had problem with brrestore, have to follow up tomorrow. BR0374E 0 of 1 file restored by backup utility BR0280I BRRESTORE time s...
-
--to use AWR http://www.dbapool.com/articles/061906.html --to check AWR retention select * from DBA_HIST_WR_CONTROL; --to estimate AWR size ...
-
This is useful. find /share/Multimedia/ –name *.m4a | while read foo; do rm “$foo” ;done https://www.ripcaster.co.uk/node/772
-
Database audit records for statement, privilege, and object auditing are stored in the table SYS.AUD$. Depending on how extensive your audit...
-
Security related values in the 12c SYS.USER$ table are CTIME: Date & Time when user was created PTIME: Date & Time when user pas...
-
Quest Toad and Alternatives http://yong321.freeshell.org/oranotes/ToadAndAlternatives.html#ToadAlternatives
-
Other than reduce time needed for recovery, it also affects performance, shorten checkpoint time. Especially when the DB has batch job runn...
