how to monitor sql queries onto the oracle 9i

[lovekang]

I'm a java programmer.

The system, I have to handle, is not well-documented so I have hard time to working with it.

I'm wonering is there a way to monitor all sql queries(or imaginarily filter them) onto the oracle database.

then I navigate the user's UI and which UI interact with which tables or something.

oracle is 9i and I have toad 9.0

thanks in advance.

 

[SantaMufasa]

LoveKang,

Depending upon what information you wish to track, the data dictionary view, V$SQL, may give you what you want. Do a describe on V$SQL to see what information it contains. The first column, SQL_TEXT, contains the text of every SQL statement that runs against the database.

Another method to track SQL activity is Oracle's AUDIT functionality. Rather than my showing you all the syntax here, just grab Oracle documentation that contains an explanation of the AUDIT statement and how to use it.

Although you can track, using triggers, any INSERT, UPDATE, DELETE activity for any user tables, triggers cannot track SELECT statements.

Let us know if any of this information is useful for your need.