Monitoring index usage
I am trying to monitor the index usage.
When I give ALTER INDEX INDEX_NAME MONITORING USAGE,monitoring is getting enabled and I can see the corresponding entry in V$OBJECT_USAGE.
Problem is when I give a wrong syntax. Ofcourse I have not intentionally tried the wrong syntax. By mistake I gave the syntax ALTER INDEX INDEX_NAME SET MONITORING USAGE, Oracle disconnected my connectin itself. Ideally it should have given the syntax error. But in this case due to a syntax mistake connection is getting interrupted. Is it a known bug? Any solutions?
Click Here to Expand Forum to Full Width