| A few days back, I found a huge index on my main | | | | finished. This table was then replicated to three other |
| transaction table in primary production database(9i | | | | databases using updateable materialized view |
| RAC Database), which I suspected was not being | | | | setup.So this production database became the |
| used by any query. So I decided to monitor its usage | | | | master site for replication. |
| using oracle 9i Monitoring usage command. And after | | | | To my surprise, I found out that even though 45 |
| monitoring it for a week, I found out that it was not | | | | minutes of production time had elapsed, no new |
| beingused by any query. I dropped it just before | | | | records were appended to the main transaction table |
| production hour began on Monday after weekly | | | | whose unused function based index was dropped. |
| backup and other maintenance activities were | | | | |