|
-
 Originally Posted by skhanal
Oracle 8 and Windows 2000 in 2013.
Have you ANALYZED all tables?. Is it even using Cost Based Optimizer?
He is probably using the rule based optimizer, which means that he should delete stats, not create stats. I would check to see what the init file settings are and make sure that there is enough there is a large enough SGA. He should also verify that there is a temp file.
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
|
Reply With Quote