Generally help with skewed data
column level statistics (include index statistics and histrogram)
Popular Posts
-
Database audit records for statement, privilege, and object auditing are stored in the table SYS.AUD$. Depending on how extensive your audit...
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
--to use AWR http://www.dbapool.com/articles/061906.html --to check AWR retention select * from DBA_HIST_WR_CONTROL; --to estimate AWR size ...
-
我们可以使用logminer分析其它instance（版本可不一致）的重做日志文件，但是必须遵循以下要求： 1. LogMiner日志分析工具仅能够分析Oracle 8以后的产品 2. LogMiner必须使用被分析数据库实例产生的字典文件，且安装LogMin...
-
Being a DBA or system administrator, simple ENTER may bring us into a nightmare. It is unavoidable, however what we can do is to prevent ...
-
This is useful. find /share/Multimedia/ –name *.m4a | while read foo; do rm “$foo” ;done https://www.ripcaster.co.uk/node/772
-
got two useful articles about compression. Marked here 11g Release 2 RMAN Backup Compression Oracle 11g Release 2 – RMAN compressi...
-
Quest Toad and Alternatives http://yong321.freeshell.org/oranotes/ToadAndAlternatives.html#ToadAlternatives
-
--For Solaris, AIX , HP-UX platform shift + v # for copy to clipboard dd # delete the line p # paste --...
