| |
 |
|
Oracle
Tips by Burleson |
Commands not requiring SPID
to be set
There are several commands that do not require a SPID to be set.
These refer to system wide type dumps. An example is the IPC
command, the results from the IPC command are shown in Figure 6.
Result of oradebug IPC on w2k 9.1.0.1.1 goes to trace file:
Dump file C:\oracle\admin\aultdb1\udump\ORA01960.TRC
Thu Mar 21 10:14:36 2002
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Windows 2000 Version 5.0 Service Pack 1, CPU type 586
Instance name: aultdb1
Redo thread mounted by this instance: 1
Oracle process number: 11
Windows thread id: 1960, image: ORACLE.EXE
*** 2002-03-21 10:14:36.000
*** SESSION ID:(8.42) 2002-03-21 10:14:36.000
Dump of Windows skgm context
areaflags 0000007f
realmflags 00000001
maxtotalrealmsize 6f21f000
VMpagesize 00001000
VMallocgranularity 00010000
minappaddress 00010000
maxappaddress 7FFEFFFF
stacklimit 07561000
magic acc01ade
Handle: 02C726B8 `sga_aultdb1'
Dump of Windows realm handle `sga_aultdb1', flags = 00000001
Area #0 `Fixed Size' containing Subareas 0-0
Total size 0000000000044f1c Minimum Subarea size 00000000
Area Subarea Start Addr
0 0 02C90000
Subarea size
00045000
Area #1 `Variable Size' containing Subareas 2-2
Total size 0000000009800000 Minimum Subarea size 00800000
Area Subarea Start Addr
1 2 64800000
Subarea size
09800000
Area #2 `Redo Buffers' containing Subareas 1-1
Total size 0000000000013000 Minimum Subarea size 00000000
Area Subarea Start Addr
2 1 02CE0000
Subarea size
00013000
--------- Process Post/Wait Resource Information ---------
Maximum threads: = 7500
Thread SHAD, tid: 1960, Post/Wait Event: 272 = 0
Thread PMON, tid: 1628, Post/Wait Event: 312 = 0
Thread DBW0, tid: 592, Post/Wait Event: 336 = 0
Thread LGWR, tid: 328, Post/Wait Event: 372 = 0
Thread CKPT, tid: 1648, Post/Wait Event: 392 = 0
Thread SMON, tid: 1688, Post/Wait Event: 412 = 0
Thread RECO, tid: 1696, Post/Wait Event: 432 = 0
Thread CJQ0, tid: 452, Post/Wait Event: 452 = 0
Thread S000, tid: 1268, Post/Wait Event: 472 = 0
Thread D000, tid: 440, Post/Wait Event: 492 = 0
This is a book excerpt from:
Using the
Oracle oradebug Utility
Debugging Oracle Applications
Mike Ault
ISBN: 0-9740716-7-6
http://www.rampant-books.com/ebook_oradebug.htm
|
