RE: Trace on Oracle 9.2.0.1.0 on Windows don't works

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 19 Feb 2004 07:57:54 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C19CE@xchgbrsm1.corp.espn.pvt>

show parameter sql

What do you see?
Raj

-------------------------------------------------------------------------=

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of dbm_at_ekenberg.org Sent: Thursday, February 19, 2004 7:55 AM To: oracle-l_at_freelists.org
Subject: RE: Trace on Oracle 9.2.0.1.0 on Windows don't works

Hi,

Yes I want to trace all the database. (only for 15min and it is a test database).
The problem is that no trace file are created even pmon trace files.

Best Regards
Henrik E.

> As well as the possible typo, do you really want to trace *all* =
activity
> on=3D
> the db, including pmon etc? A more usual implementation might be a =
log on
> =3D
> trigger or use of one of the built in packages that enable you to =
trace
> som=3D
> e particular session of interest.=3D20
>
> Niall Litchfield
> Oracle DBA
> Audit Commission
> +44 117 975 7805=3D20
>
>> -----Original Message-----
>> From: dbm_at_ekenberg.org=3D20
>> Sent: 19 February 2004 11:47
>> To: dbm_at_ekenberg.org; oracle-l_at_freelists.org
>> Subject: Trace on Oracle 9.2.0.1.0 on Windows don't works
>>=3D20
>>=3D20
>> Hello,
>>=3D20
>> I need to trace one Oracle 9.2.0.1.0 database on WinXP.
>> I insert slq_trace =3D3D TRUE in the init.ora file, then I restart =
the
>> database.
>> I run my query but nothing happends.
>> What do I miss ? Is there any know bug on this version ?
>>=3D20
>> Best Regards
>> Henrik
>> --------------------------------------------------------------
>> -------------
>> Henrik Ekenberg / Sweden
>>=3D20
>> ----------------------------------------------------------------
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> ----------------------------------------------------------------
>> To unsubscribe send email to: oracle-l-request_at_freelists.org
>> put 'unsubscribe' in the subject line.
>> --
>> Archives are at http://www.freelists.org/archives/oracle-l/
>> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>> -----------------------------------------------------------------
>>=3D20
>>=3D20
>
>
>
> **********************************************************************
> This email contains information intended for
> the addressee only. It may be confidential
> and may be the subject of legal and/or
> professional privilege. Any dissemination,
> distribution, copyright or use of this
> communication without prior permission of
> the sender is strictly prohibited.
> **********************************************************************
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Feb 19 2004 - 06:57:54 CST