RE: Trace on Oracle 9.2.0.1.0 on Windows don't works
- From: "Davey, Alan" <Alan.Davey@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Feb 2004 06:03:04 -0700
Is your database using an SPFILE?
-----------------------------------------
Alan Davey
Senior Analyst/Project Leader
Oracle 9i OCA; 3/4 OCP
w) 973.267.5990 x458
w) 212.295.3458
-----Original Message-----
From: dbm@xxxxxxxxxxxx [mailto:dbm@xxxxxxxxxxxx]
Sent: Thursday, February 19, 2004 7:55 AM
To: oracle-l@xxxxxxxxxxxxx
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=
> the db, including pmon etc? A more usual implementation might be a log on
> =
> trigger or use of one of the built in packages that enable you to trace
> som=
> e particular session of interest.=20
>
> Niall Litchfield
> Oracle DBA
> Audit Commission
> +44 117 975 7805=20
>
>> -----Original Message-----
>> From: dbm@xxxxxxxxxxxx=20
>> Sent: 19 February 2004 11:47
>> To: dbm@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>> Subject: Trace on Oracle 9.2.0.1.0 on Windows don't works
>>=20
>>=20
>> Hello,
>>=20
>> I need to trace one Oracle 9.2.0.1.0 database on WinXP.
>> I insert slq_trace =3D 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 ?
>>=20
>> Best Regards
>> Henrik
>> --------------------------------------------------------------
>> -------------
>> Henrik Ekenberg / Sweden
>>=20
>> ----------------------------------------------------------------
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> ----------------------------------------------------------------
>> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
>> put 'unsubscribe' in the subject line.
>> --
>> Archives are at //www.freelists.org/archives/oracle-l/
>> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>> -----------------------------------------------------------------
>>=20
>>=20
>
>
>
> **********************************************************************
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
"This information in this e-mail is intended solely for the addressee and
may contain information which is confidential or privileged. Access to this
e-mail by anyone else is unauthorized. If you are not the intended
recipient, or believe that you have received this communication in error,
please do not print, copy, retransmit, disseminate, or otherwise use the
information. Also, please notify the sender that you have received this
e-mail in error, and delete the copy you received."
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
