193.121.160.69 at 13:13, 6 April 2016

2016-04-06T13:13:28Z

Tom: Created page with "Enable monitoring: select 'alter index ' || owner || '.' || index_name || ' monitoring usage;' from dba_indexes where owner = '?' and index_type not..."

2016-03-31T11:50:00Z

Created page with "Enable monitoring: <source lang="sql"> select 'alter index ' || owner || '.' || index_name || ' monitoring usage;' from dba_indexes where owner = '?' and index_type not..."

New page

Enable monitoring:
<source lang="sql">
select 'alter index ' || owner || '.' || index_name || ' monitoring usage;'
from dba_indexes
where owner = '?'
and index_type not in ('LOB');
</source>

Validate it has been enabled on all indexes (in case some were locked):
<source lang="sql">
select index_name
from user_indexes
where index_type not in ('LOB')
minus
select index_name
from v$object_usage;
</source>

Verify, make sure to connect as the owner of the objects you are monitoring:
<source lang="sql">
select *
from v$object_usage;
</source>

@@ Line 1: / Line 1: @@
 Enable monitoring:
 <source lang="sql">
@@ Line 21: / Line 22: @@
 select *
     from v$object_usage;
 </source>

Index Monitoring - Revision history

193.121.160.69 at 13:13, 6 April 2016

Tom: Created page with "Enable monitoring: select 'alter index ' || owner || '.' || index_name || ' monitoring usage;' from dba_indexes where owner = '?' and index_type not..."