Hi Arun,
You have requested a BUFFER dump, rather than a BUFFERS dump. The BUFFER dump is
intended to do a level 10 dump of a particular buffer. The level number to
specify in the event syntax is the decimal tablespace relative data block
address. Of course, there is no buffer with an RDBA of 10. That is why your
trace file was empty.
The levels for the BUFFERS dump are as follows.
level 1 dump the buffer headers only
level 2 include the cache and transaction headers from each block
level 3 include a full dump of each block
level 4 dump the working set lists and the buffer headers and the cache header
for each block
level 5 include the transaction header from each block
level 6 include a full dump of each block
Most levels high than 6 are equivalent to 6, except that levels 8 and 9 are the
same as 4 and 5 respectively. For level 1 to 3 the information is dumped in
buffer header order. For levels higher than 3, the buffers and blocks are dumped
in hash chain order.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-----Original Message-----
Sent: Friday, 27 April 2001 8:07
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to take a buffer dump thro the following command
alter session set events 'immediate trace name buffer level 10';
but all i am getting is a dump file which does not have any information on
it
can somebody let me know what i am missing here.
the below said information is what there in the dump file
Dump file g:\806_home\RDBMS80\trace\ORA00241.TRC
Thu Apr 26 16:58:24 2001
ORACLE V8.0.6.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586
Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.6.0.0 - Production
Windows NT V4.0, OS V5.101, CPU type 586
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 11
pid: f1
*** 2001-04-26 16:58:24.879
*** SESSION ID:(10.1) 2001-04-26 16:58:24.879
Dump of buffer cache at level 10
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ARUN K C
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve Adams
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
