Monthly Archives: febbraio 2015

Too many indexes may not be a good thing … Oracle engine keeps all indexes defined on a table independently of their use. Their maintenance can cause considerable use of CPU and I/O which can be heavy to system performance in a high-intensity writing . Periodically can be useful to identify and remove indexes that are not used....

In order to keep backupset over the default rman keep windows. In this case rman retention policy is 1 day RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name TESTDB are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default Making a database backup with no keep option specified...