-
analyze SYS or SYSTEM
I am on 10.2.0.2
1. could you please tell me if there is a benefit to ANALYZE SYS schema?
2. I have an performance issue, I have DEV and PRD, all of the parameter are the same, alsmost everything is the same between the two beside HARDWARE. my question why do I have to different execution plan when I trace the SQL?
thanks
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
|