Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Find all SQLs run from one session

Re: Find all SQLs run from one session

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 23 Aug 2005 11:35:36 GMT
Message-Id: <pan.2005.08.23.11.35.36.333184@sbcglobal.net>


On Mon, 22 Aug 2005 09:43:58 +0200, Randi W wrote:

> Is it possible by querying system tables to find all sql-statements that
> have been run from one session?
> What tables/views should I look into to find this?
>
> Thanks for your help,
> Randi W

You turn on auditing.

-- 
http://www.mgogala.com
Received on Tue Aug 23 2005 - 06:35:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US