Re: Oracle9i: Monitoring transactions Question

1. Fuentes wrote:

>
> Fellow Oracle Netters:
>
> I need to know what sort of queries and transactions are
> being done in an Oracle9i database server which I am the DBA.
>
> I would like to see the actual sql commands performed by
> the connected users in order to optimize the performance
> of this database.
>
> Now, I have two partial ways of doing it and seeing part of the
> commands:
>
> 1) run the query: SELECT SQL_TEXT FROM V$SQLTEXT and
> 2) run some of the tools in the OEM console like "top sessions"
>
> Now the question is:
>
> Is there a better way of doing this?
>
> Thanks in advance,
>
> A. Fuentes
> 512-297-9937

Also look at the DBMS_PROFILER built-in package. It won't get you all of the SQL. Just the SQL being most executed or taking the most time. Which is likely what you really want.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)