Generally help with skewed data
column level statistics (include index statistics and histrogram)
Popular Posts
-
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....
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
RMAN> show all; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # de...
-
Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second f...
-
SYS@DGS> startup mount ORACLE instance started. Total System Global Area 680607744 bytes Fixed Size 2229600 bytes Varia...
-
I am puzzled with previous (Failed to ) Play with RMAN RECOVER BLOCK command , so continue to play it. Did I corrupted wrong block? Why n...
-
This installation extended to my home hour, since both Postgresql and Zabbix are new to me. Followed few articles without much difficulty.... -
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
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...
-
1. Refresh group failed with FAST REFRESH mode . SQL> exec dbms_refresh.refresh('"ARBOR"."ARBOR_DAILY_REF"...