I often met SQL phrase in sql scripts as ALTER SESSION SET EVENTS '...'
for example:
ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10';
(Oracle 8.1.7.3 patches install instuctions)
or
alter session set events '10046 trace name context forever, level Level';
where
:
a.ruSubject: ALTER SESSION SET EVENTS '...'
Sent
:
a.ruSubject: ALTER SESSION
SET EVENTS '...'
Sent by:
root@fatcity
: ALTER SESSION
SET EVENTS '...'
Sent by:
root@fatcity
Hagedorn, Linda [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/30/01 03:38 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:alter session set events
'immediate trace name redohdr level 10
Title: alter session set events 'immediate trace name redohdr level 10'
Hello,
I'm looking for documentation to name and label the output from the dump of redo headers and logs. For example,
siz: 0x5000 seq: 0x1087 hws: 0x2 bsz: 512 nab: 0x5001 flg: 0x0 dup: 2
The size parameter
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:alter session set events 'immediate trace name redohdr level 10'
Hello,
I'm looking for documentation to name and label the output from the dump of redo headers and logs. For example,
siz: 0x5000
]
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 3:07
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
alter session set events 'immediate trace name redohdr level
10'Hi Linda
Welcome to
Oracle! I am aware that db2 has wealth of documentation and manuals, but you
would