Monitor SQL queries

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Majkl Najt
    #1

    Monitor SQL queries

    Hi!

    Is it possible to see what statements has been executed to database?
    Is there any tool or log to look into?

    I am new to Oracle and have been mainly doing things with MySQL where
    you can enable logging and then just watch logs.

    Any hints?

    Thanks.
    Tags: None
    • Frank
      #2
      Re: Monitor SQL queries

      Majkl Najt wrote:
      Hi!
      >
      Is it possible to see what statements has been executed to database?
      Is there any tool or log to look into?
      >
      I am new to Oracle and have been mainly doing things with MySQL where
      you can enable logging and then just watch logs.
      >
      Any hints?
      >
      Thanks.
      Yes - seems a bit deep for a beginner, though.
      v$sqlarea, column sqltext, gives the statement
      Do a describe on v$sqlarea.

      Tools: TOAD (there's a free download, still), TORA (works
      on Linux, too), SQL*Plus, Oracle Enterprise Manager, ...
      --
      Regards, Frank van Bortel

        Comment

        Previous template Next
        Working...