Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2005
    Posts
    39

    Unanswered: could see pending command in v$sqlarea

    Hello,

    Please see the command and output below :

    SQL> select FIRST_LOAD_TIME,SQL_TEXT from v$sqlarea where users_executing > 0;

    FIRST_LOAD_TIME SQL_TEXT
    ------------------------- -----------------------------------
    2005-11-11/16:45:50 SELECT * FROM ratl_oplog
    2005-11-18/14:44:01 select FIRST_LOAD_TIME,SQL_TEXT from v$sqlarea where users_executing > 0

    The first entry in the output is pending since 11th Nov...and I think this is reulting in performance problems in my database.

    Can somebody suggest some way to solve this issue..??

    Thanks, Rajeev

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    .Can somebody suggest some way to solve this issue..??
    What issue?
    What performance problem measured but which metric having what value?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2005
    Posts
    39
    As you can see the line "2005-11-11/16:45:50 SELECT * FROM ratl_oplog" in the output...!!!

    It started on 11th Nov......so I am asking , if this is a problem and can it lead to performance problems, as this is running from so long...???

    I hope this makes sense.

    Please let me know.

    Regards,
    Rajeev

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > as this is running from so long.
    What evidence do you have that it is actually "running" as opposed to simply being resident in the SGA?
    Do you think that Oracle actively eliminates SQL from the SGA after the last user has completed running the statement?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    active sql lookup:
    PHP Code:
    select s.sql_addresst.sql_text
    from v$sqltext t
    v$session s
    where s
    .status 'ACTIVE'
      
    and s.username is NOT NULL
      
    and s.sql_address t.address
    group by s
    .sql_addresst.sql_textt.piece
    order by s
    .sql_addresst.piece

    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Oct 2005
    Posts
    39
    Thanks for your reply.

    Performance problem was due to indexing.

    Regards,
    Rajeev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •