Monitoring

[preetikate]

Hi,
How to enable monitoring on
1.Usage of Indexes in teh database
2.Full Table Scans taking place in teh database.
Thanks

[julian]

Originally posted by preetikate
Hi,
How to enable monitoring on
1.Usage of Indexes in teh database
2.Full Table Scans taking place in teh database.
Thanks

1. For all indexes run alter index index_name monitoring usage;

Then build some PL/SQL procedure that will check v$object_usage and insert the information in a table.

2. Use STASPACK or what actually you would like to know: how amny FTSs you have per day :-) how many tables have been fully scaned? What?

[pando]

look v$sql_plan if you wanna see what queries are full scanning the tables, if you are working with 9i