RE: EVENT="123" Event="456" or Event="123: 456"

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 3 Sep 2004 14:56:06 +1000
Message-ID: <00f201c49172$524fb070$ae8735cb@ixora.com.au>

Hi Sinardy,

Disclaimer: Don't set any events on a production database unless it is suggested by Oracle support.

For setting multiple events, I prefer (A).

See http://www.fors.com/velpuri2/DEBUG/Events_syntax for a full = explanation
of the syntax.

"ERRORSTACK" is just one of the dumps you can ask for.

---

Bonus answer: Jared started this list when oracle-l_at_sunysb.edu had been = down
for about 2 weeks. It was the 3rd major outage in about 6 months, and = no-one
was able to get a response from Sanjay Kapur, the owner of that list.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/         - For DBAs
@   http://www.christianity.net.au/  - For all=20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Sinardy Xing
Sent: Friday, 3 September 2004 1:53 PM
To: oracle-l_at_freelists.org
Subject: EVENT=3D"123" Event=3D"456" or Event=3D"123: 456"

Hi all,

I have few questions please help, metalink's SR not answer my questions, they ask for my phone no so can close the TAR asap.

Ok now my questions

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

1. To set multiple events in init.ora which method to use? (choose at = least one, A, B, C)

(A) adjecent format

          EVENT=3D"12345 trace name context forever, level 10"
          EVENT=3D"67890 trace name context forever, level 10"

SQL> show parameter event

12345 trace name context forever, level 10, 67890 trace name context forever, level 10

(B) EVENT=3D"12345 trace name context forever, level 10: 67890 trace = name
context forever, level 10"

SQL> show parameter event

12345 trace name context forever, level 10: 67890 trace name context forever, level 10

(C) other, please give me an example

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

2. What are diferrences between using keyword "context forever" and "errorstack"

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

3. How many types of tracing (how Oracle group these tracing, I mean = when to
use errorstack and when to use context forever)?

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

4. Can you recommend soft link or metalink note regarding this or = perhaps I
am over look the Oracle Doc?

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

bonus quiz....

btw, who start this mailing list?

1. Jared
2. Steve Adams
3. all of above
4. others

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

thanks very much,

Sinardy

---
To unsubscribe - =
mailto:oracle-l-request_at_freelists.org&subject=3Dunsubscribe=20
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

---
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Received on Thu Sep 02 2004 - 23:52:08 CDT