HIRE ORACLE DBA IN ABU DHABI
ORACLE DBA JOBS DUBAI
Tuesday, June 3, 2014
index_monitoring_status script in oracle 10g
SET VERIFY OFF
SELECT table_name,
index_name,
monitoring
FROM v$object_usage
WHERE table_name = UPPER('&1')
AND index_name = DECODE(UPPER('&2'), 'ALL', index_name, UPPER('&2'));
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment