| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: not able to dump buffers
Thanks Steve,
It was dumb of me not to see that.
Thanks very much
>From: "Steve Adams" Reply-To: ORACLE-L_at_fatcity.com To: Multiple recipients
>of list ORACLE-L Subject: RE: not able to dump buffers Date: Sat, 28 Apr
>2001 21:55:30 -0800
>
>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).
-- 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).Received on Tue May 01 2001 - 09:07:58 CDT
 |
 |