DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Query for last sql statement executed..

  1. #1
    Join Date
    Feb 2001
    Posts
    39

    Query for last sql statement executed..

    Hi All,
    I would like to take a look at the last sql statement run on a database instance. I do not remember how to do it anymore. Can someone please help me out with the query?

    Thanks,
    Dee.
    God Bless

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    select * from v$sql
    order by first_load_time desc
    Able was I ere I saw Elba

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by robertbalmer
    select * from v$sql
    order by first_load_time desc
    Err.. I think he needs last executed and ur query will give that last qyr loaded but not necessary to be last executed.
    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"

  5. #5
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    Err...Ooops
    Able was I ere I saw Elba

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