Monthly Archives: febbraio 2015

Index Monitoring
  • 18
    Feb

Index Monitoring

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....

Read More
How to change default retention of a database backup
  • 9
    Feb

How to change default retention of a database backup

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...

Read More