Generally help with skewed data
column level statistics (include index statistics and histrogram)
Popular Posts
-
This installation extended to my home hour, since both Postgresql and Zabbix are new to me. Followed few articles without much difficulty.... -
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
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...
-
after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
-
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....
-
Ha, just learned. RCATT:/software/orarman/ops/exec> cat t.rman run { list backup summary; } RMAN> @t.rman RMAN> run...
-
notice this in alert.log while running dbua. ORA-12012: error on auto execute of job "APEX_050000"."ORACLE_APEX_MAIL_QUEUE...
-
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...
-
SYS@DGS> startup mount ORACLE instance started. Total System Global Area 680607744 bytes Fixed Size 2229600 bytes Varia...