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

  • From: "Steve Adams" <steve.adams@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 3 Sep 2004 14:56:06 +1000

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@xxxxxxxxxx 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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Sinardy Xing
Sent: Friday, 3 September 2004 1:53 PM
To: oracle-l@xxxxxxxxxxxxx
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?

a. Jared

b. Steve Adams

c. all of above

d. 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@xxxxxxxxxxxxx&subject=3Dunsubscribe=20
To read recent messages - //freelists.org/archives/oracle-l/09-2004

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

Other related posts: