Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle9i: Monitoring transactions Question
"A. Fuentes" <alvarof2_at_hotmail.com> a écrit dans le message de news:
btf3m3$fgm$1_at_ausnews.austin.ibm.com...
>
> 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
>
>
>
A better way ???? what do u excpet exactlly ? thoses solutions are really fine... Received on Tue Jan 06 2004 - 14:19:55 CST