CODEWITHSUNDEEP
sqlsessionplsqlmonitoringoracle11g
scope_creep
scope_creep

Reputation: 4251

Another Oracle sql monitoring tool

Probably has been asked before, but i'm looking for a utility, which can

  1. Identify a particular session and record all activity.
  2. Able to identify the sql that was executed under that session.
  3. Identify any stored procedures/functions/packages that were executed.
  4. And able to show what was passed as parameters into the procs/funcs.

I'm looking for a IDE thats lightweight, fast, available and won't take 2 day's to install, i.e something I can get down, install and use in the next 1 hour.

Bob.

Upvotes: 1

Views: 412

Answers (2)

michael
michael

Reputation: 17

if you have license for Oracle Diagnostic/Tuning Packs, you may use Oracle Active Session History feature ASH

Upvotes: 1

Adam Musch
Adam Musch

Reputation: 13638

The easiest way I can think of to do this is probably already installed in your database - it's the DBMS_MONITOR package, which writes trace files to the location identified by user_dump_dest. As such, you'd need help from someone with access to the database server to access the trace files.

But once, you've identified the SID and SERIAL# of the session you want to trace, you can just call:

EXEC dbms_monitor.session_trace_enable (:sid, :serial#, FALSE, TRUE);

To capture all the SQL statements being run, including the values passed in as binds.

Upvotes: 0

Related Questions