| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Trace on Oracle 9.2.0.1.0 on Windows don't works
Is your database using an SPFILE?
-----Original Message-----
From: dbm_at_ekenberg.org [mailto: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=
> 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_at_ekenberg.org=20
>> 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
>>=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_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
>> -----------------------------------------------------------------
>>=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_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
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_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 - 07:03:04 CST
 |
 |