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: SQL TRACING FOR A PARTICULAR SESSION.

Re: SQL TRACING FOR A PARTICULAR SESSION.

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 02 Mar 2004 06:24:53 +0100
Message-ID: <uj6840pj74l894irokrkh02elhstnsif98@4ax.com>


On 1 Mar 2004 21:14:43 -0800, maulana1_at_hotmail.com (Jaffery) wrote:

>But how should we read these text files dynamically(run time) and then
>stores the text of these sql trace files into an Oracle
>table(id,username, text) using logon/logof triggers etc.

Why on earth do you think you need that? If you want to capture performance data, use statspack.

--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Mar 01 2004 - 23:24:53 CST

Original text of this message

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