-
Why so slow?
When I run this scripts why is slow?
It seems when I reboot it runs fine. But after few days later it gradually slows down.
Any input would greatly appreciate.
Many thanks.
SELECT OSUSER,
SQL_TEXT
FROM V$SESSION, V$SQL
WHERE V$SESSION.SQL_ADDRESS = V$SQL.ADDRESS
AND V$SESSION.STATUS = 'ACTIVE';
Last edited by Puja; 01-24-2005 at 11:17 AM.
-
May be the SP is filled with "literal" SQL statements.
How many active sessions do you see at any time?
Tamil
-
Thank you Tamil,
Right now I see only 8 and that is the avarage.
-
Try this:
...
and v$session.sql_hash_value!=0
and v$session.sql_address!='00'
...
Ales The whole difference between a little boy and an adult man is the price of toys
-
I tried that, same result .... still too slow....
-
If u feel its tooo slow to execute, just check in v$session_wait what is it waiting for.. then u may infer something.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
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
|