Results 1 to 3 of 3

Thread: monitor queries in Shared_Pool

  1. 04-24-2006, 05:37 AM #1
    HotelYorba
    HotelYorba is offline Registered User
    Join Date
    Feb 2005
    Location
    Netherlands
    Posts
    5

    monitor queries in Shared_Pool

    hello all!

    I want to be able to see the queries that my application fires in my Oracle 10g-database. These queries are generated from within the application, so there's no exact way to see them beforehand.

    I'm told I should be able to do this by looking in the Shared_Pool, but I don't know exactly how.
    Can Anyone help me with this?

    thanx in advance...
    R@mon
    Reply With Quote Reply With Quote
  2. 04-24-2006, 11:56 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can look at V$SQL or V$SQLAREA views. In 10g it will be easier to use ADDM.

    You can also start database trace.
    Reply With Quote Reply With Quote
  3. 04-28-2006, 08:42 PM #3
    jkoopmann's Avatar
    jkoopmann
    jkoopmann is offline Registered User
    Join Date
    Mar 2003
    Posts
    468
    These articles might help:
    Watching SQL Execute on Oracle - Part I
    Watching SQL Execute on Oracle - Part II
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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