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.
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 10:17 AM.
May be the SP is filled with "literal" SQL statements.
How many active sessions do you see at any time?
Thank you Tamil,
Right now I see only 8 and that is the avarage.
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.
"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"
Click Here to Expand Forum to Full Width