-
Hi there, I have been away from Oracle for a while and so I have forgotten some things. I remember that there was a command that would show the query execution plan for each query. It was set for a user and after it was set, every query by the user would show the execution plan. Could you kindly tell me what that command is? Thank you.
Thanks,
Afshin.
-
If you have Plan table created in the Schema,
Use This
Set Autot On
This will help
Thanks..
-
-
Thanks you very much guys
Thanks,
Afshin.
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
|