ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 使用10046 来了解oracle的启动过程

使用10046 来了解oracle的启动过程

原创 Linux操作系统 作者:aaqwsh 时间:2011-05-03 15:01:40 0 删除 编辑
以前一般用10046来跟踪SQL,把一些信息记录在trace文件里以后分析。还可以使用10046 来了解oracle的启动过程,可参考《深入解析oracle》:

SQL> startup nomount
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              62916852 bytes
Database Buffers          100663296 bytes
Redo Buffers                2973696 bytes

SQL> alter session set events='10046 trace name context forever,level 12';

Session altered.

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

PARSING IN CURSOR #2 len=68 dep=0 uid=0 ct=42 lid=0 tim=1273728791786384 hv=540455900 ad='29b59c18'
alter session set events='10046 trace name context forever,level 12'
END OF STMT
EXEC #2:c=0,e=151,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=1273728791786356
WAIT #2: nam='SQL*Net message to client' ela= 13 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1273728791788061
WAIT #2: nam='SQL*Net message from client' ela= 1814 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1273728791790122
WAIT #0: nam='SQL*Net message to client' ela= 12 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1273728791790787
*** 2011-05-02 09:05:12.604
WAIT #0: nam='SQL*Net message from client' ela= 29112168 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1273728820903070
XCTEND rlbk=0, rd_only=1
=====================
PARSING IN CURSOR #1 len=20 dep=0 uid=0 ct=35 lid=0 tim=1273728820906590 hv=1913505115 ad='29b5991c'
alter database mount
END OF STMT
PARSE #1:c=0,e=3152,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=1273728820906563
BINDS #1:
WAIT #1: nam='rdbms ipc reply' ela= 1562 from_process=5 timeout=60 p3=0 obj#=-1 tim=1273728820909834
WAIT #1: nam='reliable message' ela= 14977 channel context=692592880 channel handle=692561664 broadcast message=693200860 obj#=-1 tim=1273728820936078
WAIT #1: nam='rdbms ipc reply' ela= 6014 from_process=7 timeout=900 p3=0 obj#=-1 tim=1273728820942567
WAIT #1: nam='control file sequential read' ela= 326 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728820950143
WAIT #1: nam='control file sequential read' ela= 37 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728820950722
WAIT #1: nam='control file sequential read' ela= 34 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728820950841
kccsga_update_ckpt: num_1 = 32, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
WAIT #1: nam='control file sequential read' ela= 18838 file#=0 block#=3 blocks=32 obj#=-1 tim=1273728820983313
WAIT #1: nam='control file sequential read' ela= 956 file#=1 block#=3 blocks=32 obj#=-1 tim=1273728820984411
WAIT #1: nam='control file sequential read' ela= 746 file#=2 block#=3 blocks=32 obj#=-1 tim=1273728820985263
WAIT #1: nam='control file heartbeat' ela= 3898758 p1=0 p2=0 p3=0 obj#=-1 tim=1273728824884161
WAIT #1: nam='control file sequential read' ela= 471 file#=0 block#=3 blocks=32 obj#=-1 tim=1273728824884981
WAIT #1: nam='control file sequential read' ela= 226 file#=1 block#=3 blocks=32 obj#=-1 tim=1273728824885311
WAIT #1: nam='control file sequential read' ela= 210 file#=2 block#=3 blocks=32 obj#=-1 tim=1273728824885613
WAIT #1: nam='control file sequential read' ela= 224 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728824885930
WAIT #1: nam='control file parallel write' ela= 3201 files=1 block#=1 requests=1 obj#=-1 tim=1273728824889561
WAIT #1: nam='control file sequential read' ela= 40 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728824889811
WAIT #1: nam='control file parallel write' ela= 617 files=1 block#=1 requests=1 obj#=-1 tim=1273728824890515
WAIT #1: nam='control file sequential read' ela= 38 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728824890688
WAIT #1: nam='control file parallel write' ela= 588 files=1 block#=1 requests=1 obj#=-1 tim=1273728824891362
WAIT #1: nam='control file sequential read' ela= 42 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728824891541
WAIT #1: nam='control file sequential read' ela= 37 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728824891663
WAIT #1: nam='control file parallel write' ela= 4195 files=3 block#=42 requests=3 obj#=-1 tim=1273728824896100
WAIT #1: nam='control file parallel write' ela= 2100 files=3 block#=40 requests=3 obj#=-1 tim=1273728824901947
WAIT #1: nam='control file parallel write' ela= 1819 files=3 block#=1 requests=3 obj#=-1 tim=1273728824903904
WAIT #1: nam='control file sequential read' ela= 289 file#=0 block#=3 blocks=32 obj#=-1 tim=1273728824904356
WAIT #1: nam='control file parallel write' ela= 640 files=1 block#=3 requests=1 obj#=-1 tim=1273728824905105
WAIT #1: nam='control file parallel write' ela= 1152 files=1 block#=4 requests=1 obj#=-1 tim=1273728824906386
WAIT #1: nam='control file parallel write' ela= 772 files=1 block#=5 requests=1 obj#=-1 tim=1273728824907289
WAIT #1: nam='control file parallel write' ela= 738 files=1 block#=6 requests=1 obj#=-1 tim=1273728824908156
WAIT #1: nam='control file parallel write' ela= 858 files=1 block#=7 requests=1 obj#=-1 tim=1273728824909142
WAIT #1: nam='control file parallel write' ela= 856 files=1 block#=8 requests=1 obj#=-1 tim=1273728824910127
WAIT #1: nam='control file parallel write' ela= 874 files=1 block#=9 requests=1 obj#=-1 tim=1273728824911129
WAIT #1: nam='control file parallel write' ela= 5829 files=1 block#=10 requests=1 obj#=-1 tim=1273728824917087
WAIT #1: nam='control file parallel write' ela= 939 files=1 block#=11 requests=1 obj#=-1 tim=1273728824918160
WAIT #1: nam='control file parallel write' ela= 851 files=1 block#=12 requests=1 obj#=-1 tim=1273728824919141
WAIT #1: nam='control file parallel write' ela= 926 files=1 block#=13 requests=1 obj#=-1 tim=1273728824920196
WAIT #1: nam='control file parallel write' ela= 877 files=1 block#=14 requests=1 obj#=-1 tim=1273728824921633
WAIT #1: nam='control file parallel write' ela= 873 files=1 block#=15 requests=1 obj#=-1 tim=1273728824922645
WAIT #1: nam='control file parallel write' ela= 846 files=1 block#=16 requests=1 obj#=-1 tim=1273728824923622
WAIT #1: nam='control file parallel write' ela= 699 files=1 block#=17 requests=1 obj#=-1 tim=1273728824924452
WAIT #1: nam='control file parallel write' ela= 935 files=1 block#=18 requests=1 obj#=-1 tim=1273728824925516
WAIT #1: nam='control file parallel write' ela= 826 files=1 block#=19 requests=1 obj#=-1 tim=1273728824926470
WAIT #1: nam='control file parallel write' ela= 896 files=1 block#=20 requests=1 obj#=-1 tim=1273728824927508
WAIT #1: nam='control file parallel write' ela= 813 files=1 block#=21 requests=1 obj#=-1 tim=1273728824928495
WAIT #1: nam='control file parallel write' ela= 1233 files=1 block#=22 requests=1 obj#=-1 tim=1273728824929859
WAIT #1: nam='control file parallel write' ela= 774 files=1 block#=23 requests=1 obj#=-1 tim=1273728824930766
WAIT #1: nam='control file parallel write' ela= 851 files=1 block#=24 requests=1 obj#=-1 tim=1273728824931746
WAIT #1: nam='control file parallel write' ela= 794 files=1 block#=25 requests=1 obj#=-1 tim=1273728824932668
WAIT #1: nam='control file parallel write' ela= 815 files=1 block#=26 requests=1 obj#=-1 tim=1273728824933613
WAIT #1: nam='control file parallel write' ela= 762 files=1 block#=27 requests=1 obj#=-1 tim=1273728824934504
WAIT #1: nam='control file parallel write' ela= 848 files=1 block#=28 requests=1 obj#=-1 tim=1273728824935480
WAIT #1: nam='control file parallel write' ela= 919 files=1 block#=29 requests=1 obj#=-1 tim=1273728824936529
WAIT #1: nam='control file parallel write' ela= 810 files=1 block#=30 requests=1 obj#=-1 tim=1273728824937503
WAIT #1: nam='control file parallel write' ela= 767 files=1 block#=31 requests=1 obj#=-1 tim=1273728824938398
WAIT #1: nam='control file parallel write' ela= 949 files=1 block#=32 requests=1 obj#=-1 tim=1273728824939475
WAIT #1: nam='control file parallel write' ela= 901 files=1 block#=33 requests=1 obj#=-1 tim=1273728824940503
WAIT #1: nam='control file parallel write' ela= 860 files=1 block#=34 requests=1 obj#=-1 tim=1273728824941492
WAIT #1: nam='control file parallel write' ela= 929 files=1 block#=35 requests=1 obj#=-1 tim=1273728824942632
WAIT #1: nam='control file parallel write' ela= 871 files=1 block#=36 requests=1 obj#=-1 tim=1273728824943638
WAIT #1: nam='control file parallel write' ela= 863 files=1 block#=37 requests=1 obj#=-1 tim=1273728824944749
WAIT #1: nam='control file sequential read' ela= 44 file#=0 block#=777 blocks=1 obj#=-1 tim=1273728824945000
WAIT #1: nam='control file sequential read' ela= 41 file#=0 block#=48 blocks=1 obj#=-1 tim=1273728824945332
WAIT #1: nam='control file sequential read' ela= 40 file#=0 block#=412 blocks=1 obj#=-1 tim=1273728824945458
WAIT #1: nam='control file sequential read' ela= 81 file#=0 block#=804 blocks=1 obj#=-1 tim=1273728824948324
WAIT #1: nam='control file sequential read' ela= 46 file#=0 block#=806 blocks=1 obj#=-1 tim=1273728824948526
WAIT #1: nam='control file sequential read' ela= 34 file#=0 block#=777 blocks=1 obj#=-1 tim=1273728824948765
WAIT #1: nam='control file parallel write' ela= 2517 files=3 block#=805 requests=3 obj#=-1 tim=1273728824951433
WAIT #1: nam='control file sequential read' ela= 43 file#=0 block#=779 blocks=1 obj#=-1 tim=1273728824951604
WAIT #1: nam='control file parallel write' ela= 2057 files=3 block#=41 requests=3 obj#=-1 tim=1273728824954080
WAIT #1: nam='control file parallel write' ela= 1864 files=3 block#=39 requests=3 obj#=-1 tim=1273728824956087
WAIT #1: nam='control file parallel write' ela= 1854 files=3 block#=1 requests=3 obj#=-1 tim=1273728824958076
WAIT #1: nam='rdbms ipc reply' ela= 24 from_process=6 timeout=910 p3=0 obj#=-1 tim=1273728824978793
WAIT #1: nam='rdbms ipc reply' ela= 1765 from_process=6 timeout=910 p3=0 obj#=-1 tim=1273728824981193
WAIT #1: nam='control file sequential read' ela= 40 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728824983251
WAIT #1: nam='control file sequential read' ela= 33 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728824983376
WAIT #1: nam='control file sequential read' ela= 32 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728824983491
WAIT #1: nam='control file sequential read' ela= 32 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728824983605
WAIT #1: nam='control file sequential read' ela= 33 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728824983717
WAIT #1: nam='control file sequential read' ela= 34 file#=0 block#=777 blocks=1 obj#=-1 tim=1273728824983876
WAIT #1: nam='control file sequential read' ela= 35 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728824984234
WAIT #1: nam='control file sequential read' ela= 32 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728824984351
WAIT #1: nam='control file sequential read' ela= 32 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728824984463
WAIT #1: nam='control file sequential read' ela= 31 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728824984576
WAIT #1: nam='control file sequential read' ela= 32 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728824984686
WAIT #1: nam='control file sequential read' ela= 34 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728824985018
WAIT #1: nam='control file sequential read' ela= 32 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728824985133
WAIT #1: nam='control file sequential read' ela= 67 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728824985349
WAIT #1: nam='control file sequential read' ela= 33 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728824985463
WAIT #1: nam='control file sequential read' ela= 31 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728824985575
WAIT #1: nam='control file sequential read' ela= 46 file#=0 block#=420 blocks=1 obj#=-1 tim=1273728824985766
XCTEND rlbk=0, rd_only=1
EXEC #1:c=164010,e=4147736,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1273728825054721
WAIT #1: nam='SQL*Net message to client' ela= 8 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1273728825054869
WAIT #1: nam='SQL*Net message from client' ela= 2951 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1273728825057894
WAIT #0: nam='SQL*Net message to client' ela= 6 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1273728825058112
*** 2011-05-02 09:05:28.310
WAIT #0: nam='SQL*Net message from client' ela= 11182531 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1273728836240729
XCTEND rlbk=0, rd_only=1
=====================
PARSING IN CURSOR #2 len=19 dep=0 uid=0 ct=35 lid=0 tim=1273728836242780 hv=1907384048 ad='29b38b80'
alter database open
END OF STMT
PARSE #2:c=0,e=1705,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=1273728836242753
BINDS #2:
WAIT #2: nam='control file sequential read' ela= 53 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728836246039
WAIT #2: nam='control file sequential read' ela= 39 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728836246178
WAIT #2: nam='control file sequential read' ela= 37 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836246297
WAIT #2: nam='control file sequential read' ela= 40 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728836246420
WAIT #2: nam='control file sequential read' ela= 33 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728836246534
WAIT #2: nam='control file sequential read' ela= 37 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728836249562
WAIT #2: nam='control file sequential read' ela= 33 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728836249686
WAIT #2: nam='control file sequential read' ela= 33 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836249800
WAIT #2: nam='control file sequential read' ela= 32 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728836249913
WAIT #2: nam='control file sequential read' ela= 32 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728836250025
WAIT #2: nam='control file sequential read' ela= 31 file#=0 block#=777 blocks=1 obj#=-1 tim=1273728836250139
WAIT #2: nam='control file sequential read' ela= 188 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728836250840
WAIT #2: nam='control file sequential read' ela= 32 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728836250958
WAIT #2: nam='control file sequential read' ela= 31 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836251071
WAIT #2: nam='control file sequential read' ela= 31 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728836251183
WAIT #2: nam='control file sequential read' ela= 33 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728836251294
WAIT #2: nam='control file sequential read' ela= 31 file#=0 block#=777 blocks=1 obj#=-1 tim=1273728836251411
WAIT #2: nam='control file sequential read' ela= 39 file#=0 block#=48 blocks=1 obj#=-1 tim=1273728836254467
WAIT #2: nam='direct path read' ela= 136 file number=1 first dba=1 block cnt=1 obj#=-1 tim=1273728836255104
WAIT #2: nam='direct path read' ela= 13 file number=2 first dba=1 block cnt=1 obj#=-1 tim=1273728836255446
WAIT #2: nam='direct path read' ela= 12 file number=3 first dba=1 block cnt=1 obj#=-1 tim=1273728836255556
WAIT #2: nam='direct path read' ela= 13 file number=5 first dba=1 block cnt=1 obj#=-1 tim=1273728836255659
WAIT #2: nam='direct path read temp' ela= 13 file number=201 first dba=1 block cnt=1 obj#=-1 tim=1273728836255817
WAIT #2: nam='control file sequential read' ela= 1581 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728836283397
WAIT #2: nam='control file sequential read' ela= 653 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728836288360
WAIT #2: nam='control file sequential read' ela= 37 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836288522
WAIT #2: nam='control file sequential read' ela= 36 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728836288644
WAIT #2: nam='control file sequential read' ela= 34 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728836288760
WAIT #2: nam='control file sequential read' ela= 35 file#=0 block#=817 blocks=1 obj#=-1 tim=1273728836288881
WAIT #2: nam='control file parallel write' ela= 4554 files=3 block#=818 requests=3 obj#=-1 tim=1273728836293528
WAIT #2: nam='control file parallel write' ela= 4083 files=3 block#=42 requests=3 obj#=-1 tim=1273728836297878
WAIT #2: nam='control file parallel write' ela= 1747 files=3 block#=40 requests=3 obj#=-1 tim=1273728836299774
WAIT #2: nam='control file parallel write' ela= 1941 files=3 block#=1 requests=3 obj#=-1 tim=1273728836301849
WAIT #2: nam='control file sequential read' ela= 46 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728836302254
WAIT #2: nam='control file sequential read' ela= 34 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728836302375
WAIT #2: nam='control file sequential read' ela= 33 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836302489
WAIT #2: nam='control file sequential read' ela= 33 file#=0 block#=40 blocks=1 obj#=-1 tim=1273728836302604
WAIT #2: nam='control file sequential read' ela= 35 file#=0 block#=42 blocks=1 obj#=-1 tim=1273728836302780
WAIT #2: nam='control file sequential read' ela= 68 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728836303063
WAIT #2: nam='control file sequential read' ela= 81 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728836303230
WAIT #2: nam='control file sequential read' ela= 32 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836303347
WAIT #2: nam='control file sequential read' ela= 31 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836251071
WAIT #2: nam='control file sequential read' ela= 31 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728836251183
WAIT #2: nam='control file sequential read' ela= 33 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728836251294
WAIT #2: nam='control file sequential read' ela= 31 file#=0 block#=777 blocks=1 obj#=-1 tim=1273728836251411
WAIT #2: nam='control file sequential read' ela= 39 file#=0 block#=48 blocks=1 obj#=-1 tim=1273728836254467
WAIT #2: nam='direct path read' ela= 136 file number=1 first dba=1 block cnt=1 obj#=-1 tim=1273728836255104
WAIT #2: nam='direct path read' ela= 13 file number=2 first dba=1 block cnt=1 obj#=-1 tim=1273728836255446
WAIT #2: nam='direct path read' ela= 12 file number=3 first dba=1 block cnt=1 obj#=-1 tim=1273728836255556
WAIT #2: nam='direct path read' ela= 13 file number=5 first dba=1 block cnt=1 obj#=-1 tim=1273728836255659
WAIT #2: nam='direct path read temp' ela= 13 file number=201 first dba=1 block cnt=1 obj#=-1 tim=1273728836255817
WAIT #2: nam='control file sequential read' ela= 1581 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728836283397
WAIT #2: nam='control file sequential read' ela= 653 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728836288360
WAIT #2: nam='control file sequential read' ela= 37 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836288522
WAIT #2: nam='control file sequential read' ela= 36 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728836288644
WAIT #2: nam='control file sequential read' ela= 34 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728836288760
WAIT #2: nam='control file sequential read' ela= 35 file#=0 block#=817 blocks=1 obj#=-1 tim=1273728836288881
WAIT #2: nam='control file parallel write' ela= 4554 files=3 block#=818 requests=3 obj#=-1 tim=1273728836293528
WAIT #2: nam='control file parallel write' ela= 4083 files=3 block#=42 requests=3 obj#=-1 tim=1273728836297878
WAIT #2: nam='control file parallel write' ela= 1747 files=3 block#=40 requests=3 obj#=-1 tim=1273728836299774
WAIT #2: nam='control file parallel write' ela= 1941 files=3 block#=1 requests=3 obj#=-1 tim=1273728836301849
WAIT #2: nam='control file sequential read' ela= 46 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728836302254
WAIT #2: nam='control file sequential read' ela= 34 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728836302375
WAIT #2: nam='control file sequential read' ela= 33 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836302489
WAIT #2: nam='control file sequential read' ela= 33 file#=0 block#=40 blocks=1 obj#=-1 tim=1273728836302604
WAIT #2: nam='control file sequential read' ela= 35 file#=0 block#=42 blocks=1 obj#=-1 tim=1273728836302780
WAIT #2: nam='control file sequential read' ela= 68 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728836303063
WAIT #2: nam='control file sequential read' ela= 81 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728836303230
WAIT #2: nam='control file sequential read' ela= 32 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728836303347
WAIT #2: nam='control file sequential read' ela= 33 file#=0 block#=40 blocks=1 obj#=-1 tim=1273728836303459
WAIT #2: nam='control file sequential read' ela= 32 file#=0 block#=42 blocks=1 obj#=-1 tim=1273728836303572
WAIT #2: nam='control file sequential read' ela= 33 file#=0 block#=44 blocks=1 obj#=-1 tim=1273728836303690
WAIT #2: nam='rdbms ipc reply' ela= 14 from_process=6 timeout=910 p3=0 obj#=-1 tim=1273728836779808
WAIT #2: nam='rdbms ipc reply' ela= 1945248 from_process=6 timeout=910 p3=0 obj#=-1 tim=1273728838725161
WAIT #2: nam='rdbms ipc reply' ela= 1937412 from_process=6 timeout=908 p3=0 obj#=-1 tim=1273728840662839
WAIT #2: nam='control file sequential read' ela= 30 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728840663454
WAIT #2: nam='control file sequential read' ela= 22 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728840663525
WAIT #2: nam='control file sequential read' ela= 20 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728840663588
WAIT #2: nam='control file sequential read' ela= 20 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728840663655
WAIT #2: nam='control file sequential read' ela= 19 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728840663718
WAIT #2: nam='control file sequential read' ela= 20 file#=0 block#=777 blocks=1 obj#=-1 tim=1273728840663785
WAIT #2: nam='control file sequential read' ela= 18 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728840663872
WAIT #2: nam='control file sequential read' ela= 16 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728840663933
WAIT #2: nam='control file sequential read' ela= 17 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728840663994
WAIT #2: nam='control file sequential read' ela= 17 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728840664055
WAIT #2: nam='control file sequential read' ela= 18 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728840664116
WAIT #2: nam='control file sequential read' ela= 16 file#=0 block#=777 blocks=1 obj#=-1 tim=1273728840664177
WAIT #2: nam='control file sequential read' ela= 18 file#=0 block#=1 blocks=1 obj#=-1 tim=1273728840664300
WAIT #2: nam='control file sequential read' ela= 17 file#=1 block#=1 blocks=1 obj#=-1 tim=1273728840664362
WAIT #2: nam='control file sequential read' ela= 17 file#=2 block#=1 blocks=1 obj#=-1 tim=1273728840664422
WAIT #2: nam='control file sequential read' ela= 18 file#=0 block#=39 blocks=1 obj#=-1 tim=1273728840664484
WAIT #2: nam='control file sequential read' ela= 18 file#=0 block#=41 blocks=1 obj#=-1 tim=1273728840664544
WAIT #2: nam='control file sequential read' ela= 18 file#=0 block#=777 blocks=1 obj#=-1 tim=1273728840664607
WAIT #2: nam='log file sync' ela= 72476 buffer#=5718 p2=0 p3=0 obj#=-1 tim=1273728840739948
WAIT #2: nam='instance state change' ela= 51377 layer=2 value=1 waited=1 obj#=-1 tim=1273728840791561
WAIT #2: nam='db file sequential read' ela= 152 file#=1 block#=377 blocks=1 obj#=-1 tim=1273728840799464
=====================
PARSING IN CURSOR #3 len=188 dep=1 uid=0 ct=1 lid=0 tim=1273728840802666 hv=1365064427 ad='29b2f16c'
create table bootstrap$ ( line#         number not null,   obj#           number not null,   sql_text   varchar2(4000) not null)   storage (initial 50K objno 56 extents (file 1 block 377))
END OF STMT
PARSE #3:c=0,e=2660,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1273728840802651
BINDS #3:
EXEC #3:c=0,e=987,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1273728840803812
=====================
PARSING IN CURSOR #3 len=55 dep=1 uid=0 ct=3 lid=0 tim=1273728840804938 hv=2111436465 ad='29b2e9f8'
select line#, sql_text from bootstrap$ where obj# != :1
END OF STMT
PARSE #3:c=0,e=708,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1273728840804924
BINDS #3:
kkscoacd
 Bind#0
  acdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  acflg=08 fl2=0001 frm=00 csi=00 siz=24 ff=0
  kxsbbbfp=b7f87868  bln=22  avl=02  flg=05
  value=56
EXEC #3:c=0,e=14645,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1273728840819844
WAIT #3: nam='db file sequential read' ela= 230 file#=1 block#=377 blocks=1 obj#=-1 tim=1273728840820451
WAIT #3: nam='db file scattered read' ela= 464 file#=1 block#=378 blocks=3 obj#=-1 tim=1273728840822502
FETCH #3:c=4000,e=3136,p=4,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823055
FETCH #3:c=0,e=61,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823191
FETCH #3:c=0,e=18,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823269
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823344
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823418
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823493
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823567
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823640
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823714
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823788
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823892
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840823967
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824041
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824115
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824188
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824262
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824335
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824409
FETCH #3:c=4000,e=47,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824513
FETCH #3:c=0,e=18,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824754
FETCH #3:c=0,e=21,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824894
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840824972
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825046
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825121
FETCH #3:c=0,e=19,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825196
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825269
FETCH #3:c=0,e=15,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825342
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825416
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825490
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825563
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825637
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825711
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825786
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825859
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840825932
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826005
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826079
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826152
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826226
FETCH #3:c=0,e=15,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826298
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826373
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826446
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826519
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826592
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826666
FETCH #3:c=0,e=79,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826803
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826879
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840826953
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840827026
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840827099
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840827195
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840827269
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840827342
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840827416
FETCH #3:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840827488
FETCH #3:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=1273728840827561
FETCH #3:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1273728840827632
STAT #3 id=1 cnt=56 pid=0 pos=1 bj=56 p='TABLE ACCESS FULL BOOTSTRAP$ (cr=58 pr=4 pw=0 time=3073 us)'
=====================
PARSING IN CURSOR #3 len=129 dep=1 uid=0 ct=36 lid=0 tim=1273728840829459 hv=0 ad='b7f64360'
CREATE ROLLBACK SEGMENT SYSTEM STORAGE (  INITIAL 112K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 32765 OBJNO 0 EXTENTS (FILE 1 BLOCK 9))
END OF STMT
PARSE #3:c=0,e=1121,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1273728840829446
BINDS #3:
EXEC #3:c=0,e=339,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1273728840829951
=====================
............................
=====================
PARSING IN CURSOR #5 len=52 dep=1 uid=0 ct=3 lid=0 tim=1273728840928079 hv=429618617 ad='29b0acc8'
select ctime, mtime, stime from obj$ where obj# = :1
END OF STMT


SQL> desc bootstrap$;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 LINE#                                     NOT NULL NUMBER
 OBJ#                                      NOT NULL NUMBER
 SQL_TEXT                                  NOT NULL VARCHAR2(4000)

SQL>
SQL> select * from bootstrap$;

     LINE#       OBJ#
---------- ----------
SQL_TEXT
--------------------------------------------------------------------------------
        -1         -1
8.0.0.0.0

         0          0
CREATE ROLLBACK SEGMENT SYSTEM STORAGE (  INITIAL 112K NEXT 1024K MINEXTENTS 1 M
AXEXTENTS 32765 OBJNO 0 EXTENTS (FILE 1 BLOCK 9))

        20         20
CREATE TABLE ICOL$("OBJ#" NUMBER NOT NULL,"BO#" NUMBER NOT NULL,"COL#" NUMBER NO

..............

57 rows selected.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/758322/viewspace-694331/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-24

  • 博文量
    132
  • 访问量
    265296