Re: How to debug Oracle Queries

or:

select * from v$sql where address in (select sql_address from v$session where status='ACTIVE')

Sybrand Bakker wrote:

> "Zoom Zoom Zoom" <satnic_at_home.com> wrote in message
> news:hErZ6.122572$%i7.85553063_at_news1.rdc1.sfba.home.com...
> > Hi -
> >
> > - How can I tell what queries Oracle is running at a particular point in
> > time?
> > - How can I tell what queries are open?
> > - How can I trace the queries as they happen?
> >
> > Thanks for any help!
> >
> >
> >
>
> - By looking in v$sqlarea
> - AFAIK only open queries are listed
> - By issuing dbms_utility.set_sql_trace_in_session(<sid>,<serial#>,true)
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
Received on Sun Jun 24 2001 - 15:45:41 CDT