Re: Monitor SQL queries
From: Frank <fbortel_at_nescape.net>
Date: Wed, 26 Nov 2003 21:36:55 +0100
Message-ID: <bq32dd$2n0$1_at_news4.tilbu1.nb.home.nl>
Date: Wed, 26 Nov 2003 21:36:55 +0100
Message-ID: <bq32dd$2n0$1_at_news4.tilbu1.nb.home.nl>
Majkl Najt wrote:
> Hi!
>
> Is it possible to see what statements has been executed to database?
> Is there any tool or log to look into?
>
> I am new to Oracle and have been mainly doing things with MySQL where
> you can enable logging and then just watch logs.
>
> Any hints?
>
> Thanks.
Yes - seems a bit deep for a beginner, though.
v$sqlarea, column sqltext, gives the statement
Do a describe on v$sqlarea.
Tools: TOAD (there's a free download, still), TORA (works on Linux, too), SQL*Plus, Oracle Enterprise Manager, ...
-- Regards, Frank van BortelReceived on Wed Nov 26 2003 - 21:36:55 CET