Why so slow?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Why so slow?

  1. #1
    Join Date
    Aug 2000
    Posts
    25

    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 10:17 AM.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    May be the SP is filled with "literal" SQL statements.

    How many active sessions do you see at any time?

    Tamil

  3. #3
    Join Date
    Aug 2000
    Posts
    25
    Thank you Tamil,

    Right now I see only 8 and that is the avarage.

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    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

  5. #5
    Join Date
    Aug 2000
    Posts
    25

    Angry

    I tried that, same result .... still too slow....

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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
  •  



Click Here to Expand Forum to Full Width