RE: not able to dump buffers

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: arun_k_c_at_hotmail.com

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: ListGuru_at_fatcity.com (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: steve.adams_at_ixora.com.au

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: ListGuru_at_fatcity.com (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).