Generally help with skewed data
column level statistics (include index statistics and histrogram)
Popular Posts
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
--can not change next extent size for locally managed tablespace with uniform size. SYS@FMSP> alter tablespace FMS_CUSTOMER_INDEX default...
-
V$log_history retention is defined by MAXLOGHISOTRY when you create the database (or recreate the controlfile) MAXLOGHISTORY Clause This...
-
I have one PT env using storage sync for database sync. Thought need to re-register DB after DB refresh, so unregister and register again....
-
--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 installation extended to my home hour, since both Postgresql and Zabbix are new to me. Followed few articles without much difficulty.... -
Mark some doc ID here for recent incident. A Happy New Year ahead to all! ORA-600 [6006] ORA-600 [6856] During Startup Instance, Followed...
-
Just happened to read this article "Compressing Data for Space and Speed " http://www.oracle.com/technology/oramag/oracle/04-mar/...
-
prompt *************************************** prompt Dispatcher detail usage prompt *************************************** prompt ( if tim...
