-
Monitoring index usage
Hi,
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?
Regards,
Ajith
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|