Re: How to debug Oracle Queries

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 24 Jun 2001 22:25:35 +0200
Message-ID: <tjcj1sgk7kjed2@beta-news.demon.nl>

"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:25:35 CDT