oracle index monitoring

alter index DB_USER_INDEX monitoring usage

SELECT index_name,
table_name,
monitoring,
used,
start_monitoring,
end_monitoring
FROM v$object_usage
WHERE index_name = 'DB_USER_INDEX'
ORDER BY index_name;

alter index DB_USER_INDEX nomonitoring usage

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9907339/viewspace-1045307/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9907339/viewspace-1045307/