Generally help with skewed data
column level statistics (include index statistics and histrogram)
Popular Posts
-
when running "backup filesperset 10 archivelog all not backed up 2 times;", encountered below error : channel ORA_DISK_1: starti...
-
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 ...
-
Security related values in the 12c SYS.USER$ table are CTIME: Date & Time when user was created PTIME: Date & Time when user pas...
-
:: 极限 Linux ::成就DBA职业生涯
-
五年前，在英国之外没人听说过ITIL。现如今，拿起任何一本贸易杂志，就会发现有人提到这个名词。但尽管人们大肆宣传ITIL，许多IT专业人士并不完全了解ITIL到底指的是什么。下面是对它的一些主要介绍。 1：ITIL代表信息技术基础构架库 ITIL包括一组用来开发并执行IT服务管理...
-
Quest Toad and Alternatives http://yong321.freeshell.org/oranotes/ToadAndAlternatives.html#ToadAlternatives
