-
4 days ago the application which runs against my ora 7.2 db(on Novell , why me) started to crawl. Nothing in the alrt log cpu sometimes hangs at 100% but users even report the prob when its bouncin between 5% and 30%
im checking for missing indexes, but I ran and explain plan on a sql statement that one of the develpoers was using(that i know was making the cpu run at 100%) and it was ez and like 6 lines of explain plan with no full table scans. Any immediate help would be GREATLY appreciated!!!
Thanks in advance,
SM
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
|