oracle index monitoring

maojinyu發表於2011-01-28
OracleIndex

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章