Generally help with skewed data
column level statistics (include index statistics and histrogram)
Popular Posts
-
Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object...
-
Summary: 1.) In my first test, the recovery time is too close (8 seconds) to the INSERT statement, "hence" after recovery the las... -
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...
-
Backup of the flash recovery area is an important activity because this area contains important backup information that is critical to the r...
-
Tuned a " HASH GROUP BY" after increase the pga_aggregate_target from 190MB to 2GB , since workload increased over the time. Feel...
-
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...
-
When fails half way during installation of 12c Clou d Control, o f course, we'd better to check logs under /u01/app/oraInventory/lo... -
Security related values in the 12c SYS.USER$ table are CTIME: Date & Time when user was created PTIME: Date & Time when user pas...
-
1. Refresh group failed with FAST REFRESH mode . SQL> exec dbms_refresh.refresh('"ARBOR"."ARBOR_DAILY_REF"...