Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Posts
    83

    Unanswered: monitoring queries

    How can I monitor/view all the queries executed in Oracle in a particular oracle instance.

  2. #2
    Join Date
    Nov 2006
    Location
    Indianapolis
    Posts
    90
    look at gv$sql

  3. #3
    Join Date
    Aug 2007
    Location
    France
    Posts
    14

    Cool

    You have several ways to do that :

    1) Use
    Code:
    set sql_trace = TRUE;
    at instance level or session level, to track in user dump files all the user queries (can be consumming in disk space so must not be permanent)

    2) Use the log miner tool, to be able to see all the last queries submitted to the database and logged in the redo logs files

    3) Use
    Code:
     select * from V$SQLAREA;

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >2) Use the log miner tool, to be able to see all the last queries submitted to the database and logged in the redo logs files

    IMO, [depending upon definition] a query (SELECT) is NOT logged anywhere.

    DDL (Data Definition Language) & DML (Data Manipulation Language) [INSERT, UPDATE, DELETE] operations are logged & can be mined.
    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.

Posting Permissions

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