# cat gettrcname.sql
select
a.value || b.symbol || c.instance_name || '_ora_' || d.spid || '.trc' trace_file_name
from (select value from v$parameter where name = 'user_dump_dest')a,
(select substr(value,-6,1) symbol from v$parameter where name = 'user_dump_dest') b,
(select instance_name from v$instance) c,
(select spid from v$session s,v$process p,v$mystat m where s.paddr = p.addr and s.sid = m.sid and m.statistic#=0) d
/
# sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 11 09:45:40 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> alter system dump datafile 3 block min 1 block max 3;
System altered.
SQL> @gettrcname.sql
TRACE_FILE_NAME
--------------------------------------------------------------------------------
/app/Oracle10g/admin/eygle/udump/eygle_ora_29947.trc
SQL> !cat /app/Oracle10g/admin/eygle/udump/eygle_ora_29947.trc
/app/Oracle10g/admin/eygle/udump/eygle_ora_29947.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /app/Oracle10g/product/10.2.0/Db_1
System name: SunOS
Node name: cds4
Release: 5.9
Version: Generic_118558-06
Machine: sun4u
Instance name: eygle
Redo thread mounted by this instance: 1
Oracle process number: 30
Unix process pid: 29947, image: oracle@cds4 (TNS V1-V3)
*** 2012-11-11 09:46:09.927
*** SERVICE NAME:(SYS$USERS) 2012-11-11 09:46:09.927
*** SESSION ID:(116.11400) 2012-11-11 09:46:09.926
Start dump data blocks tsn: 2 file#: 3 minblk 1 maxblk 3
Block 1 (file header) not dumped: use dump file header command
buffer tsn: 2 rdba: 0x00c00002 (3/2)
scn: 0x0000.000d969d seq: 0x02 flg: 0x04 tail: 0x969d1d02
frmt: 0x02 chkval: 0x42b1 type: 0x1d=KTFB Bitmapped File Space Header
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x000000010645BC00 to 0x000000010645DC00
10645BC00 1DA20000 00C00002 000D969D 00000204 [................]
10645BC10 42B10000 00000003 00000008 00008700 [B...............]
10645BC20 00000009 00000500 003FFFFE 00000007 [.........?......]
10645BC30 00008700 0000105F 00000080 00082838 [......._......(8]
10645BC40 00000000 00000000 00000000 00000000 [................]
10645BC50 000082F9 00000008 00000000 00000000 [................]
10645BC60 00000000 00000000 00000000 00000000 [................]
Repeat 504 times
10645DBF0 00000000 00000000 00000000 969D1D02 [................]
File Space Header Block:
Header Control:
RelFno: 3, Unit: 8, Size: 34560, Flag: 9
AutoExtend: YES, Increment: 1280, MaxSize: 4194302
Initial Area: 7, Tail: 34560, First: 4191, Free: 128
Deallocation scn: 534584.0
Header Opcode:
Save: No Pending Op
buffer tsn: 2 rdba: 0x00c00003 (3/3)
scn: 0x0000.000d969d seq: 0x01 flg: 0x04 tail: 0x969d1e01
frmt: 0x02 chkval: 0xf61d type: 0x1e=KTFB Bitmapped File Space Bitmap
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x000000010645BC00 to 0x000000010645DC00
10645BC00 1EA20000 00C00003 000D969D 00000104 [................]
..........
0000000000000000 0000000000000000 0000000000000000 0000000000000000
End dump data blocks tsn: 2 file#: 3 minblk 2 maxblk 3
阅读(1933) | 评论(0) | 转发(1) |
