validate index OWNER.TABLE_INDEX; SELECT opt_cmpr_count, opt_cmpr_pctsave FROM index_stats WHERE name = ‘TABLE_INDEX’; OPT_CMPR_COUNT OPT_CMPR_PCTSAVE ————– —————- 1 10 select min(LOG_DATE), …
I appreciate the post about the undo tunning, here is the link… http://www.akadia.com/services/ora_optimize_undo.html
Simple but subtle compress implementation for indexes.. Check it out.. validate index OWNER.INDEX_NAME; SELECT opt_cmpr_count, opt_cmpr_pctsave FROM index_stats WHERE name …
Oracle® Enterprise Manager Grid Control Advanced Installation and Configuration Guide 11g Release 1 (11.1.0.1.0) E16847-09 Complete Steps to Install 11.1.0.1 …
Create Zone Paths and assign permissions bash#mkdir /zones/ bash#cd /zones bash#mkdir /zones/bb2 bash#chmod 700 /zones/bb2/ bash#chown root:root /zones/bb2/ Use …
user@dbserver[/Setups/htmldb]#sqlplus “sys/password as sysdba” SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 23 14:33:56 2011 Copyright (c) 1982, 2009, Oracle. All …
cold copy or begin backup & end backup ->> All .log .dbf Create standby control file ALTER DATABASE CREATE STANDBY …
The Time Synchronization Hierarchy The NTP daemon can not only adjust its own computer’s system time. Additionally, each daemon …
Installation Process: 9.2.0.1 software + 9.2.0.8 PSU patch those you can acquire from MOS. Indeed, for manuel installation process you …
