Sign in or 
Share this
Dumping data
1 Dumping data
You can dump the content the memory, tables, indexes, etc. This helps you to understand how is his internal structure in some situations. The example of dumping is in the specific object analysis.1.A Systemstate dump
This dump is very interesting because dumps a lot of interesting information ot the trace fileSQL> alter session set events 'immediate trace name SYSTEMSTATE level 10';
You get a complete set of information
SYSTEM STATE
------------
System global information:
processes: base 3BDBD5C8, size 100, cleanup 3BDC8248
allocation: free sessions 3BDF32A4, free calls 00000000
control alloc errors: 0 (process), 0 (session), 0 (call)
PMON latch cleanup depth: 0
seconds since PMON's last scan for dead processes: 17
system statistics:
3142 logons cumulative
22 logons current
500106 opened cursors cumulative
167 opened cursors current
. . . . . .
PROCESS 1:
----------------------------------------
SO: 3BDC7668, type: 2, owner: 00000000, flag: INIT/-/-/0x00
(process) Oracle pid=1, calls cur/top: 00000000/00000000, flag: (20) PSEUDO
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 0
last post sent-location: No post
last process posted by me: none
(latch info) wait_event=0 bits=0
O/S info: user: , term: , ospid:
OSD pid info: Windows thread id: 0, image: PSEUDO
Dump of memory from 0x3BDBDA6C to 0x3BDBDBF0
3BDBDA60 00000000 [....]
3BDBDA70 00000000 00000000 00000000 00000000 [................]
Repeat 23 times
PROCESS 2:
----------------------------------------
SO: 3BDC7C58, type: 2, owner: 00000000, flag: INIT/-/-/0x00
(process) Oracle pid=2, calls cur/top: 3BE84E2C/3BE84E2C, flag: (6) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 33
last post received-location: ksrpublish
last process to post me: 3bdccf78 14 0
last post sent: 0 0 48
last post sent-location: ksoreq_reply
last process posted by me: 3bdebc48 1 0
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 3BDECE04
O/S info: user: SYSTEM, term: SRVDAZSC, ospid: 3284
OSD pid info: Windows thread id: 3284, image: ORACLE.EXE (RECO)
Dump of memory from 0x3BDBDBF0 to 0x3BDBDD74
3BDBDBF0 00000006 3BB8C314 00000010 0003139D [.......;........]
3BDBDC00 3BE84E2C 00000003 0003139D 3BF6A744 [,N.;........D..;]
3BDBDC10 0000000B 0003139D 3BE70E0C 00000004 [...........;....]
3BDBDC20 00031291 3BF6A7E8 0000000B 0003139D [.......;........]
3BDBDC30 3B728984 00000007 0003139D 00000000 [..r;............]
3BDBDC40 00000000 00000000 00000000 00000000 [................]
Repeat 18 times
3BDBDD70 00000000 [....]
(FOB) flags=2 fib=3B7306B4 incno=3 pending i/o cnt=0
fname=E:\ORASERPG\DATAFILES\DFL_SYS_SERPG
fno=1 lblksz=4 fsiz=52172380
. . . . .
----------------------------------------
SO: 37C40F80, type: 53, owner: 3BE5F454, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=37c40f80 handle=36fac6b8 mode=N
call pin=00000000 session pin=37C366E8 hpc=0000 hlc=0000
htl=37C40FD0[37C512C0,38437440] htb=39455EE4 ssga=394558B0
user=3be5f454 session=3be5cec4 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=36fac6b8 mutex=36FAC76C(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0064 hlc=0064
lwt=36FAC714[36FAC714,36FAC714] ltm=36FAC71C[36FAC71C,36FAC71C]
pwt=36FAC6F8[36FAC6F8,36FAC6F8] ptm=36FAC700[36FAC700,36FAC700]
ref=36FAC734[36F36C60,36F36C60] lnd=36FAC740[36FAC740,36FAC740]
LIBRARY OBJECT: object=36f37394
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 371bc6d0 36f374e4 I/P/A/-/- 0 NONE 00
6 36f37b28 37304fc8 I/-/A/-/- 0 NONE 00
------------
System global information:
processes: base 3BDBD5C8, size 100, cleanup 3BDC8248
allocation: free sessions 3BDF32A4, free calls 00000000
control alloc errors: 0 (process), 0 (session), 0 (call)
PMON latch cleanup depth: 0
seconds since PMON's last scan for dead processes: 17
system statistics:
3142 logons cumulative
22 logons current
500106 opened cursors cumulative
167 opened cursors current
. . . . . .
PROCESS 1:
----------------------------------------
SO: 3BDC7668, type: 2, owner: 00000000, flag: INIT/-/-/0x00
(process) Oracle pid=1, calls cur/top: 00000000/00000000, flag: (20) PSEUDO
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 0
last post sent-location: No post
last process posted by me: none
(latch info) wait_event=0 bits=0
O/S info: user: , term: , ospid:
OSD pid info: Windows thread id: 0, image: PSEUDO
Dump of memory from 0x3BDBDA6C to 0x3BDBDBF0
3BDBDA60 00000000 [....]
3BDBDA70 00000000 00000000 00000000 00000000 [................]
Repeat 23 times
PROCESS 2:
----------------------------------------
SO: 3BDC7C58, type: 2, owner: 00000000, flag: INIT/-/-/0x00
(process) Oracle pid=2, calls cur/top: 3BE84E2C/3BE84E2C, flag: (6) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 33
last post received-location: ksrpublish
last process to post me: 3bdccf78 14 0
last post sent: 0 0 48
last post sent-location: ksoreq_reply
last process posted by me: 3bdebc48 1 0
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 3BDECE04
O/S info: user: SYSTEM, term: SRVDAZSC, ospid: 3284
OSD pid info: Windows thread id: 3284, image: ORACLE.EXE (RECO)
Dump of memory from 0x3BDBDBF0 to 0x3BDBDD74
3BDBDBF0 00000006 3BB8C314 00000010 0003139D [.......;........]
3BDBDC00 3BE84E2C 00000003 0003139D 3BF6A744 [,N.;........D..;]
3BDBDC10 0000000B 0003139D 3BE70E0C 00000004 [...........;....]
3BDBDC20 00031291 3BF6A7E8 0000000B 0003139D [.......;........]
3BDBDC30 3B728984 00000007 0003139D 00000000 [..r;............]
3BDBDC40 00000000 00000000 00000000 00000000 [................]
Repeat 18 times
3BDBDD70 00000000 [....]
(FOB) flags=2 fib=3B7306B4 incno=3 pending i/o cnt=0
fname=E:\ORASERPG\DATAFILES\DFL_SYS_SERPG
fno=1 lblksz=4 fsiz=52172380
. . . . .
----------------------------------------
SO: 37C40F80, type: 53, owner: 3BE5F454, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=37c40f80 handle=36fac6b8 mode=N
call pin=00000000 session pin=37C366E8 hpc=0000 hlc=0000
htl=37C40FD0[37C512C0,38437440] htb=39455EE4 ssga=394558B0
user=3be5f454 session=3be5cec4 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=36fac6b8 mutex=36FAC76C(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0064 hlc=0064
lwt=36FAC714[36FAC714,36FAC714] ltm=36FAC71C[36FAC71C,36FAC71C]
pwt=36FAC6F8[36FAC6F8,36FAC6F8] ptm=36FAC700[36FAC700,36FAC700]
ref=36FAC734[36F36C60,36F36C60] lnd=36FAC740[36FAC740,36FAC740]
LIBRARY OBJECT: object=36f37394
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=1 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 371bc6d0 36f374e4 I/P/A/-/- 0 NONE 00
6 36f37b28 37304fc8 I/-/A/-/- 0 NONE 00
|
juancarlosreyesp |
Latest page update: made by juancarlosreyesp
, Sep 30 2008, 9:54 PM EDT
(about this update
About This Update
Edited by juancarlosreyesp
513 words added view changes - complete history) |
|
Keyword tags:
None
More Info: links to this page
|
There are no threads for this page.
Be the first to start a new thread.
