and Real Application Testing options
SQL> set linesize 200
SQL> col name for a30
SQL> col value for a700
SQL> col value for a70
SQL> alter system dump datafile 5 block 10;
System altered.
SQL> select * from v$diag_info;
INST_ID NAME VALUE
---------- ------------------------------ ----------------------------------------------------------------------
1 Diag Enabled TRUE
1 ADR Base /opt/app/oracle
1 ADR Home /opt/app/oracle/diag/rdbms/rhys/RHYS
1 Diag Trace /opt/app/oracle/diag/rdbms/rhys/RHYS/trace
1 Diag Alert /opt/app/oracle/diag/rdbms/rhys/RHYS/alert
1 Diag Incident /opt/app/oracle/diag/rdbms/rhys/RHYS/incident
1 Diag Cdump /opt/app/oracle/diag/rdbms/rhys/RHYS/cdump
1 Health Monitor /opt/app/oracle/diag/rdbms/rhys/RHYS/hm
1 Default Trace File /opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_ora_3560.trc
1 Active Problem Count 0
1 Active Incident Count 0
11 rows selected.
Start dump data blocks tsn: 6 file#:5 minblk 10 maxblk 10
Block dump from cache:
Dump of buffer cache at level 4 for tsn=6 rdba=20971530
BH (0x7bbf6610) file#: 5 rdba: 0x0140000a (5/10) class: 9 ba: 0x7bb54000
set: 3 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
dbwrid: 0 obj: 87521 objn: 87521 tsn: 6 afn: 5 hint: f
hash: [0x83d3a660,0x83d3a660] lru: [0x7bbf6838,0x7bbf6490]
lru-flags: hot_buffer
obj-flags: object_ckpt_list
ckptq: [0x73bf43f0,0x73bf4660] fileq: [0x73bf4058,0x73fde770] objq: [0x73fde740,0x7bbf6860] objaq: [0x7bbf6870,0x7bbf64c8]
st: XCURRENT md: NULL fpin: 'ktspswh4: ktspfsbmb' tch: 20
flags: buffer_dirty block_written_once redo_since_read
LRBA: [0x7.16957.0] LSCN: [0x0.15daf9] HSCN: [0x0.160e8c] HSUB: [1]
Block dump from disk:
buffer tsn: 6 rdba: 0x0140000a (5/10)
scn: 0x0000.0015a824 seq: 0x02 flg: 0x04 tail: 0xa8242102
frmt: 0x02 chkval: 0xd354 type: 0x21=SECOND LEVEL BITMAP BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00007F8C57405A00 to 0x00007F8C57407A00
7F8C57405A00 0000A221 0140000A 0015A824 04020000 [!.....@.$.......]
7F8C57405A10 0000D354 00000000 00000000 00000000 [T...............]
7F8C57405A20 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F8C57405A40 00000000 00000000 00000000 0140000B [..............@.]
7F8C57405A50 0000000F 00000001 0000000E 00000000 [................]
7F8C57405A60 00000000 00000000 000155E1 00000001 [.........U......]
7F8C57405A70 00000000 01400008 00010001 01400009 [......@.......@.]
7F8C57405A80 00010001 0140001C 00010001 0140001D [......@.......@.]
7F8C57405A90 00010001 01400030 00010001 01400031 [....0.@.....1.@.]
7F8C57405AA0 00010001 01400044 00010001 01400045 [....D.@.....E.@.]
7F8C57405AB0 00010001 01400058 00010001 01400059 [....X.@.....Y.@.]
7F8C57405AC0 00010001 0140006C 00010001 0140006D [....l.@.....m.@.]
7F8C57405AD0 00010001 01400080 00010001 014000BC [......@.......@.]
7F8C57405AE0 00010001 014000F8 00010005 00000000 [......@.........]
7F8C57405AF0 00000000 00000000 00000000 00000000 [................]
Repeat 495 times
7F8C574079F0 00000000 00000000 00000000 A8242102 [.............!$.]
Dump of Second Level Bitmap Block
number: 15 nfree: 1 ffree: 14 pdba: 0x0140000b
Inc #: 0 Objd: 87521
opcode:0
xid:
L1 Ranges :
--------------------------------------------------------
0x01400008 Free: 1 Inst: 1
0x01400009 Free: 1 Inst: 1
0x0140001c Free: 1 Inst: 1
0x0140001d Free: 1 Inst: 1
0x01400030 Free: 1 Inst: 1
0x01400031 Free: 1 Inst: 1
0x01400044 Fre