SQL> alter session set events '10046 trace name context forever,level 12';
Session altered.
SQL> create tablespace t1 datafile '/u01/app/oracle/oradata/ORCL/t01.dbf' size 50m autoextend off;
Tablespace created.
SQL> alter session set events '10046 trace name context off';
Session altered.
WAIT #140018920250712: nam='Disk file operations I/O' ela= 27 FileOperation=8 fileno=0 filetype=8 obj#=-1 tim=7873934570
WAIT #140018920250712: nam='SQL*Net message to client' ela= 2 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7873934916
第一个等待事件，p1=8 p2=0 p3=8,也就是说在读取文件，但是不知道什么文件。这个操作我猜测应该是开启会话追踪或者建立会话的操作，处理trace文件的操作。
因为后文才出现了‘SQL*Net message from client’等待事件。等待会话发送创建表空间的命令。
SQL> select NAME,PARAMETER1,PARAMETER2,PARAMETER3,WAIT_CLASS from v$event_name where name='Disk file operations I/O';
NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------
Disk file operations I/O FileOperation fileno filetype User I/O
FileOperation=8,filetype=8 没有精确的定义——它基本上表示任何不是“特定已知”形式的 I/O。fileno=0表示控制文件
FileOperation：
1 创建文件
2 打开文件
3 调整文件大小
4 删除文件
5 文件关闭
6 等待所有 aio 请求完成
7 写入验证
8 等待杂项 io（ftp、块转储、passwd 文件）
9 从快照文件读取
filetype：
1、控制文件
2、数据文件
3、日志文件
4、归档日志
6、临时文件
9、数据文件备份
10、数据文件增量备份
11、归档日志备份
12、数据文件拷贝
13、参数文件
14、DR Config文件
15、OSM文件
16、变更跟踪文件
17、闪回日志
18、数据泵转储文件
19、跨平台数据文件
20、自动备份文件
21、OS文件
22、块转储文件
23、CSS投票文件
24、OCR文件
25、 ASM Staleness File
26,ASM Vol Device File
27,ASM Vol Dirty Region File
28,Password File
29,ADS AMS Relation File
30,OCR Backup File
31、ASM参数文件
32、Flash文件
33、ASM spfile备份
34、外部表文件
35、数据文件XTT备份
36、OS审计文件
37、数据文件增量备份
38、AKM KeyStore
39、AKM AutoLogin KeyStore
40、ORS Block Pool File
41,SQL Loader File
42,AM Container File
SQL> select distinct filetype_id, filetype_name from dba_hist_iostat_filetype order by 1;
FILETYPE_ID FILETYPE_NAME
----------- ------------------------------------------------------------
0 Other
1 Control File
2 Data File
3 Log File
4 Archive Log
6 Temp File
9 Data File Backup
10 Data File Incremental Backup
11 Archive Log Backup
12 Data File Copy
17 Flashback Log
18 Data Pump Dump File
34 External Table
13 rows selected.
SQL> select FILE_NO,FILETYPE_ID,FILETYPE_NAME from v$iostat_file;
FILE_NO FILETYPE_ID FILETYPE_NAME
---------- ----------- --------------------------------------------------------
0 0 Other
0 1 Control File
0 3 Log File
0 4 Archive Log
0 9 Data File Backup
0 10 Data File Incremental Backup
0 11 Archive Log Backup
0 12 Data File Copy
0 17 Flashback Log
0 18 Data Pump Dump File
0 34 External Table
1 2 Data File
1 6 Temp File
3 2 Data File
4 2 Data File
5 2 Data File
7 2 Data File
第二步
PARSING IN CURSOR #140018920245008 len=92 dep=0 uid=0 oct=39 lid=0 tim=7911368253 hv=572187068 ad='7f58b7aff920' sqlid='9mz59v8j1psdw'
create tablespace t1 datafile '/u01/app/oracle/oradata/ORCL/t01.dbf' size 50m autoextend off
END OF STMT
PARSE #140018920245008:c=496,e=5251,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=7911368253
WAIT #140018920245008: nam='PGA memory operation' ela= 16 p1=65536 p2=1 p3=0 obj#=-1 tim=7911368413
WAIT #140018912268784: nam='PGA memory operation' ela= 16 p1=65536 p2=1 p3=0 obj#=-1 tim=7911370082
解析这条命令，后文出现的都是后台操作需要调用
PARSING IN CURSOR #140018912268784 len=70 dep=1 uid=0 oct=3 lid=0 tim=7911370205 hv=1853064805 ad='6ac63360' sqlid='5hrvvu1r771m5'
SELECT VALUE$ FROM SYS.PROPS$ WHERE NAME = 'OGG_TRIGGER_OPTIMIZATION'
END OF STMT
PARSE #140018912268784:c=993,e=993,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=415205717,tim=7911370204
EXEC #140018912268784:c=0,e=44,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=415205717,tim=7911370296
FETCH #140018912268784:c=612,e=81,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,plh=415205717,tim=7911370392
STAT #140018912268784 id=1 cnt=0 pid=0 pos=1 obj=127 op='TABLE ACCESS FULL PROPS$ (cr=2 pr=0 pw=0 str=1 time=83 us cost=2 size=27 card=1)'
SQL> select * from PROPS$;
NAME VALUE$ COMMENT$
------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
DICT.BASE 2 dictionary base tables version #
DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace
DEFAULT_EDITION ORA$BASE Name of the database default edition
LOCAL_UNDO_ENABLED TRUE true if local undo is enabled
Flashback Timestamp TimeZone GMT Flashback timestamp created in GMT
TDE_MASTER_KEY_ID
CON_VSN 2 version number for the CDB or the Application Container
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
DICTIONARY_ENDIAN_TYPE LITTLE Endian type of the data dictionary
GLOBAL_DB_NAME ORCL Global database name
NLS_RDBMS_VERSION 19.0.0.0.0 RDBMS version for NLS parameters
NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set
NLS_NCHAR_CONV_EXCP FALSE NLS conversion exception
NLS_LENGTH_SEMANTICS BYTE NLS length semantics
NLS_COMP BINARY NLS comparison
NLS_DUAL_CURRENCY $ Dual currency symbol
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR Timestamp with timezone format
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR Time with timezone format
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format
NLS_TIME_FORMAT HH.MI.SSXFF AM Time format
NLS_SORT BINARY Linguistic definition
NLS_DATE_LANGUAGE AMERICAN Date language
NLS_DATE_FORMAT DD-MON-RR Date format
NLS_CALENDAR GREGORIAN Calendar system
NLS_CHARACTERSET AL32UTF8 Character set
NLS_NUMERIC_CHARACTERS ., Numeric characters
NLS_ISO_CURRENCY AMERICA ISO currency
NLS_CURRENCY $ Local currency
NLS_TERRITORY AMERICA Territory
NLS_LANGUAGE AMERICAN Language
DST_SECONDARY_TT_VERSION 0 Version of secondary timezone data file
DST_PRIMARY_TT_VERSION 32 Version of primary timezone data file
DST_UPGRADE_STATE NONE State of Day Light Saving Time Upgrade
MAX_STRING_SIZE STANDARD MAX_STRING_SIZE parameter used for dictionary metadata
MAX_PDB_SNAPSHOTS 8 maximum number of snapshots for a given PDB
EXPORT_VIEWS_VERSION 8 Export views revision #
WORKLOAD_CAPTURE_MODE CAPTURE implies workload capture is in progress
WORKLOAD_REPLAY_MODE PREPARE implies external replay clients can connect; REPLAY
implies workload replay is in progress
NO_USERID_VERIFIER_SALT AC198494D2611286E6E4DF94A6FCE0F3
OLS_OID_STATUS 0 OLS OID Status used for Label Security
DBTIMEZONE 00:00 DB time zone
42 rows selected.
先查询数据库的基础属性表，确认是否由ogg配置。对应的基表是x$props
SQL> lock table x$props in exclusive mode;
lock table x$props in exclusive mode
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
看来不会由行锁争用。因为创建的时候引导创建的，此处不能加排他锁。这个表由$ORACLE_HOME/rdbms/admin/dcore.bsq创建，语句为
create table props$
( name varchar2("M_IDEN") not null, /* property name */
value$ varchar2("M_VCSZ"), /* property value */
comment$ varchar2("M_VCSZ")) /* description of property */
/
insert into props$
values('DICT.BASE', '2', 'dictionary base tables version #')
/
insert into props$
values('DEFAULT_TEMP_TABLESPACE', 'SYSTEM',
'Name of default temporary tablespace')
/
insert into props$
values('DEFAULT_PERMANENT_TABLESPACE', 'SYSTEM',
'Name of default permanent tablespace')
/
第三句
PARSING IN CURSOR #140018912264800 len=332 dep=1 uid=0 oct=3 lid=0 tim=7911371913 hv=2698389488 ad='74fb7c98' sqlid='acmvv4fhdc9zh'
select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9, nvl(dflcollid, 16382), creappid, creverid, modappid, modverid, crepatchid, modpatchid
from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
END OF STMT
PARSE #140018912264800:c=443,e=443,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911371913
WAIT #140018912264800: nam='PGA memory operation' ela= 16 p1=65536 p2=1 p3=0 obj#=-1 tim=7911372957
WAIT #140018912264800: nam='PGA memory operation' ela= 4 p1=65536 p2=1 p3=0 obj#=-1 tim=7911373065
WAIT #140018912264800: nam='PGA memory operation' ela= 6 p1=65536 p2=1 p3=0 obj#=-1 tim=7911373394
WAIT #140018912264800: nam='PGA memory operation' ela= 9 p1=65536 p2=2 p3=0 obj#=-1 tim=7911373650
BINDS #140018912264800:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=80 off=0
kxsbbbfp=7f58b186d890 bln=22 avl=02 flg=05
value=93
Bind#1
oacdty=01 mxl=32(17) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=873 siz=0 off=24
kxsbbbfp=7f58b186d8a8 bln=32 avl=17 flg=01
value="SDO_ST_SYN_CREATE"
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=56
kxsbbbfp=7f58b186d8c8 bln=22 avl=02 flg=01
value=3
EXEC #140018912264800:c=1452,e=1888,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=813480514,tim=7911373856
FETCH #140018912264800:c=483,e=79,p=0,cr=4,cu=0,mis=0,r=1,dep=1,og=4,plh=813480514,tim=7911373944
STAT #140018912264800 id=1 cnt=1 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=4 pr=0 pw=0 str=1 time=80 us cost=4 size=110 card=1)'
STAT #140018912264800 id=2 cnt=1 pid=1 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 str=1 time=39 us cost=3 size=0 card=1)'
CLOSE #140018912264800:c=38,e=38,dep=1,type=3,tim=7911374010
SQL> select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9, nvl(dflcollid, 16382), creappid, creverid, modappid, modverid, crepatchid, modpatchid
2 from obj$ where owner#=93 and name='SDO_ST_SYN_CREATE' and namespace=3 and remoteowner is null and linkname is null and subname is null
3 /
OBJ# TYPE# CTIME MTIME STIME STATUS DATAOBJ# FLAGS OID$ SPARE1 SPARE2 SPARE3 SIGNATURE SPARE7 SPARE8 SPARE9 NVL(DFLCOLLID,16382) CREAPPID CREVERID MODAPPID MODVERID CREPATCHID MODPATCHID
---------- ---------- ------------ ------------ ------------ ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- -------------------- ---------- ---------- ---------- ---------- ---------- ----------
64511 12 09-SEP-22 09-SEP-22 09-SEP-22 1 5242880 6 65535 93 6383A374DC69CA6FB57CF782D30C8BA5 0 0 0 16382
检查这个触发器，这个触发器出问题其会导致很多操作无法完成。这个对象后面会有很多验证查询
第四步
PARSING IN CURSOR #140018912252904 len=51 dep=1 uid=0 oct=3 lid=0 tim=7911374129 hv=1523794037 ad='6af2eda0' sqlid='b1wc53ddd6h3p'
select audit$,options from procedure$ where obj#=:1
END OF STMT
PARSE #140018912252904:c=39,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1637390370,tim=7911374129
BINDS #140018912252904:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b186c498 bln=22 avl=04 flg=05
value=64511
EXEC #140018912252904:c=33,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1637390370,tim=7911374188
WAIT #140018912252904: nam='Disk file operations I/O' ela= 23 FileOperation=2 fileno=1 filetype=2 obj#=377 tim=7911374310
WAIT #140018912252904: nam='db file sequential read' ela= 45 file#=1 block#=2934 blocks=1 obj#=377 tim=7911374368
WAIT #140018912252904: nam='db file sequential read' ela= 800 file#=1 block#=93630 blocks=1 obj#=367 tim=7911375244
FETCH #140018912252904:c=297,e=1078,p=2,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=1637390370,tim=7911375272
STAT #140018912252904 id=1 cnt=1 pid=0 pos=1 obj=367 op='TABLE ACCESS BY INDEX ROWID PROCEDURE$ (cr=3 pr=2 pw=0 str=1 time=1080 us cost=2 size=47 card=1)'
STAT #140018912252904 id=2 cnt=1 pid=1 pos=1 obj=377 op='INDEX UNIQUE SCAN I_PROCEDURE1 (cr=2 pr=1 pw=0 str=1 time=234 us cost=1 size=0 card=1)'
CLOSE #140018912252904:c=3,e=3,dep=1,type=1,tim=7911375322
select audit$,options from procedure$ where obj#=64511;
AUDIT$ OPTIONS
-------------------------------------- ----------
-------------------------------------- 1
create table PROCEDURE$
(
obj# NUMBER not null,
audit$ VARCHAR2(38) not null,
storagesize NUMBER,
options NUMBER
)
第五步
PARSING IN CURSOR #140018912251264 len=191 dep=1 uid=0 oct=3 lid=0 tim=7911375403 hv=1070240621 ad='76ddd3d0' sqlid='3un99a0zwp4vd'
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,flags,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
END OF STMT
PARSE #140018912251264:c=63,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1475428744,tim=7911375403
BINDS #140018912251264:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b186c498 bln=22 avl=04 flg=05
value=64511
EXEC #140018912251264:c=60,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1475428744,tim=7911375504
WAIT #140018912251264: nam='db file sequential read' ela= 377 file#=1 block#=91003 blocks=1 obj#=85 tim=7911375959
WAIT #140018912251264: nam='db file sequential read' ela= 413 file#=1 block#=99025 blocks=1 obj#=83 tim=7911376432
FETCH #140018912251264:c=305,e=1002,p=2,cr=9,cu=0,mis=0,r=1,dep=1,og=4,plh=1475428744,tim=7911376515
FETCH #140018912251264:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=1475428744,tim=7911376547
FETCH #140018912251264:c=6,e=6,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1475428744,tim=7911376566
STAT #140018912251264 id=1 cnt=2 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=9 pr=2 pw=0 str=1 time=1012 us cost=15 size=685 card=5)'
STAT #140018912251264 id=2 cnt=2 pid=1 pos=1 obj=0 op='HASH JOIN OUTER (cr=9 pr=2 pw=0 str=1 time=979 us cost=14 size=685 card=5)'
STAT #140018912251264 id=3 cnt=2 pid=2 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=9 pr=2 pw=0 str=1 time=972 us cost=14 size=685 card=5)'
STAT #140018912251264 id=4 cnt=2 pid=3 pos=1 obj=0 op='STATISTICS COLLECTOR (cr=4 pr=2 pw=0 str=1 time=925 us)'
STAT #140018912251264 id=5 cnt=2 pid=4 pos=1 obj=83 op='TABLE ACCESS BY INDEX ROWID BATCHED DEPENDENCY$ (cr=4 pr=2 pw=0 str=1 time=920 us cost=4 size=135 card=5)'
STAT #140018912251264 id=6 cnt=2 pid=5 pos=1 obj=85 op='INDEX RANGE SCAN I_DEPENDENCY1 (cr=3 pr=1 pw=0 str=1 time=453 us cost=3 size=0 card=5)'
STAT #140018912251264 id=7 cnt=2 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=5 pr=0 pw=0 str=2 time=46 us cost=2 size=110 card=1)'
STAT #140018912251264 id=8 cnt=2 pid=7 pos=1 obj=36 op='INDEX RANGE SCAN I_OBJ1 (cr=4 pr=0 pw=0 str=2 time=38 us cost=1 size=0 card=1)'
STAT #140018912251264 id=9 cnt=0 pid=2 pos=2 obj=18 op='TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 str=0 time=0 us cost=2 size=110 card=1)'
CLOSE #140018912251264:c=4,e=3,dep=1,type=1,tim=7911376695
SQL> select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,
2 flags,d_attrs from dependency$ d, obj$ o where d_obj#=64511 and p_obj#=obj#(+) order by order#
3 /
OWNER# NAME NAMESPACE REMOTEOWNER LINKNAME P_TIMESTAMP P_OBJ# NVL(PROPERTY,0) SUBNAME TYPE# FLAGS D_ATTRS
---------- -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------- ---------- --------------- -------------------------------------------------------------------------------- ---------- ---------- --------------------------------------------------------------------------------
0 STANDARD 1 2018/7/16 1767 1 9 5308416
0 DBMS_STANDARD 1 2019/4/17 0 1769 5 9 5308416 000100000100E0
create table DEPENDENCY$
(
d_obj# NUMBER not null,
d_timestamp DATE not null,
order# NUMBER not null,
p_obj# NUMBER not null,
p_timestamp DATE not null,
d_owner# NUMBER,
property NUMBER not null,
d_attrs RAW(2000),
d_reason RAW(2000)
)
第六步：
PARSING IN CURSOR #140018912218400 len=56 dep=1 uid=0 oct=3 lid=0 tim=7911376773 hv=3993603298 ad='71f3a108' sqlid='8swypbbr0m372'
select order#,columns,types from access$ where d_obj#=:1
END OF STMT
PARSE #140018912218400:c=69,e=69,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=570326988,tim=7911376772
BINDS #140018912218400:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b186c080 bln=22 avl=04 flg=05
value=64511
EXEC #140018912218400:c=31,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=570326988,tim=7911376837
WAIT #140018912218400: nam='db file sequential read' ela= 368 file#=1 block#=90846 blocks=1 obj#=87 tim=7911377228
WAIT #140018912218400: nam='db file sequential read' ela= 285 file#=1 block#=53610 blocks=1 obj#=84 tim=7911377544
FETCH #140018912218400:c=102,e=724,p=2,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=570326988,tim=7911377568
FETCH #140018912218400:c=2,e=2,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=570326988,tim=7911377583
STAT #140018912218400 id=1 cnt=1 pid=0 pos=1 obj=84 op='TABLE ACCESS BY INDEX ROWID BATCHED ACCESS$ (cr=4 pr=2 pw=0 str=1 time=725 us cost=3 size=150 card=6)'
STAT #140018912218400 id=2 cnt=1 pid=1 pos=1 obj=87 op='INDEX RANGE SCAN I_ACCESS1 (cr=3 pr=1 pw=0 str=1 time=408 us cost=2 size=0 card=6)'
CLOSE #140018912218400:c=3,e=3,dep=1,type=1,tim=7911377628
SQL> select order#,columns,types from access$ where d_obj#=64511;
ORDER# COLUMNS TYPES
---------- -------------------------------------------------------------------------------- ----------
1 12
create table ACCESS$
(
d_obj# NUMBER not null,
order# NUMBER not null,
columns RAW(126),
types NUMBER not null
)
第七步
PARSING IN CURSOR #140018912247736 len=47 dep=1 uid=0 oct=3 lid=0 tim=7911377800 hv=61740290 ad='7291b0e0' sqlid='3k0c6241uw582'
select actionsize from trigger$ where obj# = :1
END OF STMT
PARSE #140018912247736:c=142,e=142,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911377800
BINDS #140018912247736:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b186b758 bln=22 avl=04 flg=05
value=64511
EXEC #140018912247736:c=555,e=555,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=1964643588,tim=7911378380
FETCH #140018912247736:c=16,e=16,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=1964643588,tim=7911378403
STAT #140018912247736 id=1 cnt=1 pid=0 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=16 us cost=1 size=9 card=1)'
STAT #140018912247736 id=2 cnt=1 pid=1 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=9 us cost=0 size=0 card=1)'
CLOSE #140018912247736:c=2,e=2,dep=1,type=0,tim=7911378515
SQL> select actionsize from trigger$ where obj# = 64511;
ACTIONSIZE
----------
1694
create table TRIGGER$
(
obj# NUMBER not null,
type# NUMBER not null,
update$ NUMBER not null,
insert$ NUMBER not null,
delete$ NUMBER not null,
baseobject NUMBER not null,
refoldname VARCHAR2(128),
refnewname VARCHAR2(128),
definition VARCHAR2(4000),
whenclause VARCHAR2(4000),
action# LONG,
actionsize NUMBER,
enabled NUMBER,
property NUMBER not null,
sys_evts NUMBER,
nttrigcol NUMBER,
nttrigatt NUMBER,
refprtname VARCHAR2(128),
actionlineno NUMBER,
trignameline NUMBER,
trignamecol NUMBER,
trignamecolofs NUMBER,
actioncolno NUMBER
)
第八步
PARSING IN CURSOR #140018912247736 len=249 dep=1 uid=0 oct=3 lid=0 tim=7911379316 hv=1913856419 ad='6ac5f2b8' sqlid='7akvnu9t168d3'
select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,
rowid,actionlineno,trignameline,trignamecol, trignamecolofs,actioncolno from trigger$ where obj# =:1
END OF STMT
PARSE #140018912247736:c=0,e=146,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911379316
BINDS #140018912247736:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1852fd8 bln=22 avl=04 flg=05
value=64511
EXEC #140018912247736:c=1063,e=742,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=1964643588,tim=7911380090
FETCH #140018912247736:c=11,e=11,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=1964643588,tim=7911380109
STAT #140018912247736 id=1 cnt=1 pid=0 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=6 us cost=1 size=156 card=1)'
STAT #140018912247736 id=2 cnt=1 pid=1 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=3 us cost=0 size=0 card=1)'
CLOSE #140018912247736:c=2,e=2,dep=1,type=0,tim=7911380166
SQL> select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,
2 rowid,actionlineno,trignameline,trignamecol, trignamecolofs,actioncolno from trigger$ where obj# =64511;
BASEOBJECT TYPE# UPDATE$ INSERT$ DELETE$ REFNEWNAME REFOLDNAME WHENCLAUSE DEFINITION ENABLED PROPERTY SYS_EVTS NTTRIGCOL NTTRIGATT REFPRTNAME ROWID ACTIONLINENO TRIGNAMELINE TRIGNAMECOL TRIGNAMECOLOFS ACTIONCOLNO
---------- ---------- ---------- ---------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- ---------- ---------- ---------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------ ------------ ----------- -------------- -----------
0 0 0 0 0 NEW OLD mdsys.sdo_st_syn_create 1 136 32 0 0 AAAAEZAABAAAXmxAAA 3 1 15 6 1
第九步
PARSING IN CURSOR #140018912247736 len=800 dep=1 uid=0 oct=3 lid=0 tim=7911380824 hv=733123428 ad='71bbf158' sqlid='5wxyshspv54v4'
select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale,c.precision#,c.charsetid,c.charsetform, decode(bitand(c.property,8388608),8388608, c.spare3, 0)
from triggercol$ tc,col$ c, trigger$ tr where tc.obj#=:1 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property,32) != 32 or
bitand(tc.type#,20) = 20) and ( c.obj#=:2 and (bitand(tc.type#, 1024) = :3 or tc.type# = 0) or c.obj#=:4 and bitand(tc.type#, 1024) = :5
or c.obj#=:6 and tc.type# = 0 and tc.position# = 0) union select type#,intcol#,position#,69,0,0,0,0,0,0 from triggercol$ where obj#=:7 and
intcol#=1001 union select tc.type#,tc.intcol#,tc.position#,121,0,0,0,0,0,0 from triggercol$ tc,trigger$ tr where tr.obj# = tc.obj# and
bitand(tr.property,32) = 32 and tc.obj# = :8 and bitand(tc.type#,20) != 20
END OF STMT
PARSE #140018912247736:c=651,e=651,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911380824
WAIT #140018912247736: nam='PGA memory operation' ela= 12 p1=65536 p2=1 p3=0 obj#=84 tim=7911382203
WAIT #140018912247736: nam='PGA memory operation' ela= 8 p1=65536 p2=1 p3=0 obj#=84 tim=7911382463
WAIT #140018912247736: nam='PGA memory operation' ela= 4 p1=65536 p2=1 p3=0 obj#=84 tim=7911382674
WAIT #140018912247736: nam='PGA memory operation' ela= 8 p1=65536 p2=1 p3=0 obj#=84 tim=7911383877
WAIT #140018912247736: nam='PGA memory operation' ela= 6 p1=65536 p2=1 p3=0 obj#=84 tim=7911384599
WAIT #140018912247736: nam='PGA memory operation' ela= 4 p1=65536 p2=1 p3=0 obj#=84 tim=7911384801
WAIT #140018912247736: nam='PGA memory operation' ela= 5 p1=65536 p2=1 p3=0 obj#=84 tim=7911385114
WAIT #140018912247736: nam='PGA memory operation' ela= 5 p1=65536 p2=1 p3=0 obj#=84 tim=7911385262
WAIT #140018912247736: nam='PGA memory operation' ela= 7 p1=65536 p2=1 p3=0 obj#=84 tim=7911385553
WAIT #140018912247736: nam='PGA memory operation' ela= 5 p1=65536 p2=1 p3=0 obj#=84 tim=7911385766
WAIT #140018912247736: nam='PGA memory operation' ela= 6 p1=65536 p2=1 p3=0 obj#=84 tim=7911386032
WAIT #140018912247736: nam='PGA memory operation' ela= 4 p1=65536 p2=1 p3=0 obj#=84 tim=7911386202
WAIT #140018912247736: nam='PGA memory operation' ela= 7 p1=65536 p2=1 p3=0 obj#=84 tim=7911386497
WAIT #140018912247736: nam='PGA memory operation' ela= 6 p1=65536 p2=1 p3=0 obj#=84 tim=7911386720
WAIT #140018912247736: nam='PGA memory operation' ela= 5 p1=65536 p2=1 p3=0 obj#=84 tim=7911386893
WAIT #140018912247736: nam='PGA memory operation' ela= 7 p1=65536 p2=2 p3=0 obj#=84 tim=7911387148
WAIT #140018912247736: nam='PGA memory operation' ela= 6 p1=65536 p2=1 p3=0 obj#=84 tim=7911387409
WAIT #140018912247736: nam='PGA memory operation' ela= 5 p1=65536 p2=1 p3=0 obj#=84 tim=7911387627
WAIT #140018912247736: nam='PGA memory operation' ela= 5 p1=65536 p2=1 p3=0 obj#=84 tim=7911387880
WAIT #140018912247736: nam='PGA memory operation' ela= 5 p1=65536 p2=1 p3=0 obj#=84 tim=7911388072
BINDS #140018912247736:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=192 off=0
kxsbbbfp=7f58b1860eb8 bln=22 avl=04 flg=05
value=64511
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7f58b1860ed0 bln=22 avl=01 flg=01
value=0
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7f58b1860ee8 bln=22 avl=01 flg=01
value=0
Bind#3
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=72
kxsbbbfp=7f58b1860f00 bln=22 avl=01 flg=01
value=0
Bind#4
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=96
kxsbbbfp=7f58b1860f18 bln=22 avl=01 flg=01
value=0
Bind#5
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=120
kxsbbbfp=7f58b1860f30 bln=22 avl=01 flg=01
value=0
Bind#6
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=144
kxsbbbfp=7f58b1860f48 bln=22 avl=04 flg=01
value=64511
Bind#7
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=168
kxsbbbfp=7f58b1860f60 bln=22 avl=04 flg=01
value=64511
EXEC #140018912247736:c=8282,e=9007,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=3009292138,tim=7911389874
FETCH #140018912247736:c=119,e=119,p=0,cr=16,cu=0,mis=0,r=0,dep=1,og=4,plh=3009292138,tim=7911390005
STAT #140018912247736 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT UNIQUE (cr=16 pr=0 pw=0 str=1 time=125 us cost=15 size=297 card=9)'
STAT #140018912247736 id=2 cnt=0 pid=1 pos=1 obj=0 op='UNION-ALL (cr=16 pr=0 pw=0 str=1 time=118 us)'
STAT #140018912247736 id=3 cnt=0 pid=2 pos=1 obj=0 op='CONCATENATION (cr=12 pr=0 pw=0 str=1 time=108 us)'
STAT #140018912247736 id=4 cnt=0 pid=3 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=92 us cost=3 size=56 card=1)'
STAT #140018912247736 id=5 cnt=0 pid=4 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=91 us cost=3 size=56 card=1)'
STAT #140018912247736 id=6 cnt=0 pid=5 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=91 us cost=2 size=23 card=1)'
STAT #140018912247736 id=7 cnt=1 pid=6 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=13 us cost=1 size=9 card=1)'
STAT #140018912247736 id=8 cnt=1 pid=7 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=9 us cost=0 size=0 card=1)'
STAT #140018912247736 id=9 cnt=0 pid=6 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 str=1 time=77 us cost=1 size=14 card=1)'
STAT #140018912247736 id=10 cnt=0 pid=5 pos=2 obj=50 op='INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 str=0 time=0 us cost=0 size=0 card=1)'
STAT #140018912247736 id=11 cnt=0 pid=4 pos=2 obj=21 op='TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=33 card=1)'
STAT #140018912247736 id=12 cnt=0 pid=3 pos=2 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=7 us cost=3 size=56 card=1)'
STAT #140018912247736 id=13 cnt=0 pid=12 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=7 us cost=3 size=56 card=1)'
STAT #140018912247736 id=14 cnt=0 pid=13 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=7 us cost=2 size=23 card=1)'
STAT #140018912247736 id=15 cnt=1 pid=14 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=3 us cost=1 size=9 card=1)'
STAT #140018912247736 id=16 cnt=1 pid=15 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=2 us cost=0 size=0 card=1)'
STAT #140018912247736 id=17 cnt=0 pid=14 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 str=1 time=3 us cost=1 size=14 card=1)'
STAT #140018912247736 id=18 cnt=0 pid=13 pos=2 obj=50 op='INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 str=0 time=0 us cost=0 size=0 card=1)'
STAT #140018912247736 id=19 cnt=0 pid=12 pos=2 obj=21 op='TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=33 card=1)'
STAT #140018912247736 id=20 cnt=0 pid=3 pos=3 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=3 us cost=3 size=56 card=1)'
STAT #140018912247736 id=21 cnt=0 pid=20 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=3 us cost=3 size=56 card=1)'
STAT #140018912247736 id=22 cnt=0 pid=21 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=3 us cost=2 size=23 card=1)'
STAT #140018912247736 id=23 cnt=1 pid=22 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=2 us cost=1 size=9 card=1)'
STAT #140018912247736 id=24 cnt=1 pid=23 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=1 us cost=0 size=0 card=1)'
STAT #140018912247736 id=25 cnt=0 pid=22 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 str=1 time=1 us cost=1 size=14 card=1)'
STAT #140018912247736 id=26 cnt=0 pid=21 pos=2 obj=50 op='INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 str=0 time=0 us cost=0 size=0 card=1)'
STAT #140018912247736 id=27 cnt=0 pid=20 pos=2 obj=21 op='TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=33 card=1)'
STAT #140018912247736 id=28 cnt=0 pid=2 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 str=1 time=2 us cost=2 size=14 card=1)'
STAT #140018912247736 id=29 cnt=0 pid=2 pos=3 obj=0 op='NESTED LOOPS (cr=2 pr=0 pw=0 str=1 time=7 us cost=2 size=115 card=5)'
STAT #140018912247736 id=30 cnt=0 pid=29 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=5 us cost=1 size=9 card=1)'
STAT #140018912247736 id=31 cnt=1 pid=30 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=0 us cost=0 size=0 card=1)'
STAT #140018912247736 id=32 cnt=0 pid=29 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=70 card=5)'
CLOSE #140018912247736:c=3,e=3,dep=1,type=0,tim=7911390475
第十步
PARSING IN CURSOR #140018912085992 len=203 dep=1 uid=0 oct=3 lid=0 tim=7911390684 hv=4144798879 ad='69c4e600' sqlid='4zzxr8rvht74z'
select case when (bitand(u.spare1, 16) = 0) then 0 when (u.type# = 2) then (u.spare2) else 1 end from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
END OF STMT
PARSE #140018912085992:c=200,e=200,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911390683
BINDS #140018912085992:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b186c080 bln=22 avl=04 flg=05
value=64511
EXEC #140018912085992:c=1372,e=1348,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=3368685730,tim=7911392057
FETCH #140018912085992:c=69,e=69,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=3368685730,tim=7911392135
STAT #140018912085992 id=1 cnt=1 pid=0 pos=1 obj=0 op='HASH JOIN (cr=3 pr=0 pw=0 str=1 time=43 us cost=3 size=33 card=1)'
STAT #140018912085992 id=2 cnt=1 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=3 pr=0 pw=0 str=1 time=36 us cost=3 size=33 card=1)'
STAT #140018912085992 id=3 cnt=1 pid=2 pos=1 obj=0 op='STATISTICS COLLECTOR (cr=2 pr=0 pw=0 str=1 time=23 us)'
STAT #140018912085992 id=4 cnt=1 pid=3 pos=1 obj=36 op='INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 str=1 time=16 us cost=2 size=8 card=1)'
STAT #140018912085992 id=5 cnt=1 pid=2 pos=2 obj=47 op='INDEX RANGE SCAN I_USER2 (cr=1 pr=0 pw=0 str=1 time=12 us cost=1 size=25 card=1)'
STAT #140018912085992 id=6 cnt=0 pid=1 pos=2 obj=47 op='INDEX FULL SCAN I_USER2 (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=25 card=1)'
CLOSE #140018912085992:c=77,e=77,dep=1,type=0,tim=7911392240
BINDS #140018912264800:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=80 off=0
kxsbbbfp=7f58b186c460 bln=22 avl=02 flg=05
value=93
Bind#1
oacdty=01 mxl=32(03) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=873 siz=0 off=24
kxsbbbfp=7f58b186c478 bln=32 avl=03 flg=01
value="SYS"
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=56
kxsbbbfp=7f58b186c498 bln=22 avl=02 flg=01
value=1
EXEC #140018912264800:c=73,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=813480514,tim=7911393334
WAIT #140018912264800: nam='db file sequential read' ela= 573 file#=1 block#=92695 blocks=1 obj#=37 tim=7911393936
FETCH #140018912264800:c=630,e=630,p=1,cr=3,cu=0,mis=0,r=0,dep=2,og=4,plh=813480514,tim=7911393971
CLOSE #140018912264800:c=0,e=0,dep=2,type=3,tim=7911393991
第十一步：
ARSING IN CURSOR #140018912247576 len=279 dep=2 uid=0 oct=3 lid=0 tim=7911394127 hv=3695076508 ad='71e7c4f8' sqlid='8nwsztmf3wt4w'
select privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)),max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16),
max(bitand(nvl(option$,0), 64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 and grantee#=:2 group by privilege#,nvl(col#,0)
END OF STMT
PARSE #140018912247576:c=47,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3290949889,tim=7911394127
BINDS #140018912247576:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0
kxsbbbfp=7f58b18a5f10 bln=22 avl=03 flg=05
value=1769
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7f58b18a5f28 bln=22 avl=02 flg=01
value=93
EXEC #140018912247576:c=0,e=108,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3290949889,tim=7911394269
WAIT #140018912247576: nam='db file sequential read' ela= 506 file#=1 block#=67173 blocks=1 obj#=63 tim=7911394837
FETCH #140018912247576:c=0,e=586,p=1,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=3290949889,tim=7911394868
STAT #140018912247576 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=1 pw=0 str=1 time=635 us cost=4 size=16 card=1)'
STAT #140018912247576 id=2 cnt=0 pid=1 pos=1 obj=61 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=2 pr=1 pw=0 str=1 time=584 us cost=3 size=16 card=1)'
STAT #140018912247576 id=3 cnt=0 pid=2 pos=1 obj=63 op='INDEX RANGE SCAN I_OBJAUTH2 (cr=2 pr=1 pw=0 str=1 time=583 us cost=2 size=0 card=1)'
CLOSE #140018912247576:c=0,e=1,dep=2,type=3,tim=7911394929
BINDS #140018912247576:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0
kxsbbbfp=7f58b18a5f10 bln=22 avl=03 flg=05
value=1769
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7f58b18a5f28 bln=22 avl=02 flg=01
value=1
EXEC #140018912247576:c=0,e=49,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3290949889,tim=7911394992
WAIT #140018912247576: nam='db file sequential read' ela= 463 file#=1 block#=594 blocks=1 obj#=63 tim=7911395480
FETCH #140018912247576:c=0,e=537,p=1,cr=3,cu=0,mis=0,r=1,dep=2,og=4,plh=3290949889,tim=7911395537
FETCH #140018912247576:c=0,e=3,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3290949889,tim=7911395558
CLOSE #140018912247576:c=0,e=1,dep=2,type=3,tim=7911395573
第十二步
PARSING IN CURSOR #140018912085992 len=1694 dep=1 uid=93 oct=47 lid=93 tim=7911400772 hv=3297032771 ad='68a5b710' sqlid='b8an9b7289fk3'
declare
error boolean;
st_syn_detected EXCEPTION;
PRAGMA EXCEPTION_INIT(st_syn_detected, -995);
BEGIN
if((sys.dbms_standard.dictionary_obj_type!='SYNONYM')or(sys.dbms_standard.dictionary_obj_owner!='PUBLIC'))
then
return;
end if;
error :=
CASE sys.dbms_standard.dictionary_obj_name
WHEN 'ST_GEOMETRY' THEN TRUE
WHEN 'ST_SURFACE' THEN TRUE
WHEN 'ST_POLYGON' THEN TRUE
WHEN 'ST_POINT' THEN TRUE
WHEN 'ST_MULTISURFACE' THEN TRUE
WHEN 'ST_MULTIPOINT' THEN TRUE
WHEN 'ST_MULTILINESTRING' THEN TRUE
WHEN 'ST_MULTICURVE' THEN TRUE
WHEN 'ST_LINESTRING' THEN TRUE
WHEN 'ST_GEOMCOLLECTION' THEN TRUE
WHEN 'ST_CURVE' THEN TRUE
WHEN 'ST_CURVEPOLYGON' THEN TRUE
WHEN 'ST_COMPOUNDCURVE' THEN TRUE
WHEN 'ST_CIRCULARSTRING' THEN TRUE
WHEN 'ST_INTERSECTS' THEN TRUE
WHEN 'ST_RELATE' THEN TRUE
WHEN 'ST_TOUCH' THEN TRUE
WHEN 'ST_CONTAINS' THEN TRUE
WHEN 'ST_COVERS' THEN TRUE
WHEN 'ST_COVEREDBY' THEN TRUE
WHEN 'ST_INSIDE' THEN TRUE
WHEN 'ST_OVERLAP' THEN TRUE
WHEN 'ST_OVERLAPS' THEN TRUE
WHEN 'ST_EQUAL' THEN TRUE
WHEN 'ST_OVERLAPBDYDISJOINT' THEN TRUE
WHEN 'ST_OVERLAPBDYINTERSECT' THEN TRUE
WHEN 'ST_GEOMETRY_ARRAY' THEN TRUE
WHEN 'ST_POINT_ARRAY' THEN TRUE
WHEN 'ST_CURVE_ARRAY' THEN TRUE
WHEN 'ST_SURFACE_ARRAY' THEN TRUE
WHEN 'ST_LINESTRING_ARRAY' THEN TRUE
WHEN 'ST_POLYGON_ARRAY' THEN TRUE
ELSE FALSE
END;
if(error) then
raise st_syn_detected;
end if;
END;
END OF STMT
PARSE #140018912085992:c=5748,e=8506,p=3,cr=8,cu=0,mis=1,r=0,dep=1,og=1,plh=0,tim=7911400772
EXEC #140018912085992:c=55,e=55,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=0,tim=7911400870
CLOSE #140018912085992:c=8,e=8,dep=1,type=0,tim=7911400918
create or replace noneditionable function dictionary_obj_type return varchar2 is
begin
return dbms_standard.dictionary_obj_type;
end;
这个函数只反馈true或者false
第十三步
PARSING IN CURSOR #140018912085992 len=41 dep=1 uid=0 oct=3 lid=0 tim=7911402387 hv=1572239410 ad='73f121b0' sqlid='7jpt4cpfvcy1k'
select ts#,online$ from ts$ where name=:1
END OF STMT
PARSE #140018912085992:c=67,e=67,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=284504113,tim=7911402387
BINDS #140018912085992:
Bind#0
oacdty=01 mxl=32(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=20 fl2=0000 frm=01 csi=873 siz=32 off=0
kxsbbbfp=7f58b1835f48 bln=32 avl=02 flg=05
value="T1"
EXEC #140018912085992:c=43,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=284504113,tim=7911402465
FETCH #140018912085992:c=11,e=11,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=284504113,tim=7911402483
STAT #140018912085992 id=1 cnt=0 pid=0 pos=1 obj=16 op='TABLE ACCESS BY INDEX ROWID TS$ (cr=1 pr=0 pw=0 str=1 time=13 us cost=1 size=14 card=1)'
STAT #140018912085992 id=2 cnt=0 pid=1 pos=1 obj=45 op='INDEX UNIQUE SCAN I_TS1 (cr=1 pr=0 pw=0 str=1 time=13 us cost=0 size=0 card=1)'
CLOSE #140018912085992:c=1,e=1,dep=1,type=0,tim=7911402544
到这步已经添加上了吗！
第十四步
PARSING IN CURSOR #140018912085992 len=24 dep=1 uid=0 oct=3 lid=0 tim=7911403250 hv=4237898550 ad='71fc56a0' sqlid='cfct2mgy9kctq'
select max(ts#) from ts$
END OF STMT
PARSE #140018912085992:c=696,e=696,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=2394986070,tim=7911403250
EXEC #140018912085992:c=14,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2394986070,tim=7911403298
FETCH #140018912085992:c=0,e=26,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=2394986070,tim=7911403330
STAT #140018912085992 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=2 pr=0 pw=0 str=1 time=29 us)'
STAT #140018912085992 id=2 cnt=1 pid=1 pos=1 obj=0 op='FIRST ROW (cr=2 pr=0 pw=0 str=1 time=24 us cost=2 size=3 card=1)'
STAT #140018912085992 id=3 cnt=1 pid=2 pos=1 obj=16 op='TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 str=1 time=24 us cost=2 size=3 card=1)'
STAT #140018912085992 id=4 cnt=1 pid=3 pos=1 obj=7 op='INDEX FULL SCAN I_TS# (cr=1 pr=0 pw=0 str=1 time=14 us cost=1 size=0 card=1)'
第十五步
PARSING IN CURSOR #140018911953376 len=394 dep=1 uid=0 oct=2 lid=0 tim=7911403834 hv=1747153666 ad='71713080' sqlid='0ts2hktn26ws2'
insert into ts$ (ts#,name,online$,contents$,undofile#,undoblock#,blocksize, dflmaxext,dflinit,dflincr,dflextpct,dflminext,dflminlen,inc#,
owner#,scnwrp,scnbas,pitrscnwrp,pitrscnbas,dflogging, bitmapped,plugged,directallowed,flags,spare1,spare2, affstrength) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,1,:14,:15,:16,:17,:18,:19,:20,:21,1,:22 + :26 * (4294967296 * 4294967296),:23,:24,:25)
END OF STMT
PARSE #140018911953376:c=480,e=355,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911403834
BINDS #140018911953376:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835f50 bln=22 avl=02 flg=05
value=6
Bind#1
oacdty=01 mxl=32(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=18 fl2=0001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=76d3520e bln=32 avl=02 flg=09
value="T1"
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835f20 bln=24 avl=02 flg=05
value=3
Bind#3
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835ef0 bln=24 avl=01 flg=05
value=0
Bind#4
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835ec0 bln=24 avl=01 flg=05
value=0
Bind#5
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835e90 bln=24 avl=01 flg=05
value=0
Bind#6
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835e60 bln=24 avl=03 flg=05
value=8192
Bind#7
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835e18 bln=24 avl=06 flg=05
value=2147483645
Bind#8
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835de8 bln=24 avl=02 flg=05
value=8
Bind#9
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835db8 bln=24 avl=03 flg=05
value=128
Bind#10
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835d88 bln=24 avl=01 flg=05
value=0
Bind#11
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835d58 bln=24 avl=02 flg=05
value=1
Bind#12
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835d28 bln=24 avl=02 flg=05
value=8
Bind#13
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835cf8 bln=24 avl=01 flg=05
value=0
Bind#14
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835cb0 bln=24 avl=01 flg=05
value=0
Bind#15
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4438 bln=24 avl=01 flg=05
value=0
Bind#16
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4408 bln=24 avl=01 flg=05
value=0
Bind#17
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b43d8 bln=24 avl=05 flg=05
value=7119982
Bind#18
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b43a8 bln=24 avl=02 flg=05
value=1
Bind#19
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4378 bln=24 avl=02 flg=05
value=8
Bind#20
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4348 bln=24 avl=01 flg=05
value=0
Bind#21
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4318 bln=24 avl=03 flg=05
value=4129
Bind#22
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4258 bln=24 avl=01 flg=05
value=0
Bind#23
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b42e8 bln=24 avl=01 flg=05
value=0
Bind#24
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b42b8 bln=24 avl=01 flg=05
value=0
Bind#25
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4288 bln=24 avl=06 flg=05
value=2147483645
EXEC #140018911953376:c=1274,e=1285,p=0,cr=3,cu=11,mis=1,r=1,dep=1,og=4,plh=0,tim=7911405176
STAT #140018911953376 id=1 cnt=0 pid=0 pos=1 obj=0 op='LOAD TABLE CONVENTIONAL TS$ (cr=3 pr=0 pw=0 str=1 time=515 us)'
CLOSE #140018911953376:c=3,e=3,dep=1,type=0,tim=7911405219
WAIT #140018920245008: nam='control file sequential read' ela= 13 file#=0 block#=1 blocks=1 obj#=-1 tim=7911405360
WAIT #140018920245008: nam='control file sequential read' ela= 5 file#=1 block#=1 blocks=1 obj#=-1 tim=7911405379
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=16 blocks=1 obj#=-1 tim=7911405388
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=18 blocks=1 obj#=-1 tim=7911405396
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=31 blocks=1 obj#=-1 tim=7911405410
WAIT #140018920245008: nam='Disk file operations I/O' ela= 890 FileOperation=1 fileno=0 filetype=2 obj#=-1 tim=7911408019
WAIT #140018920245008: nam='PGA memory operation' ela= 10 p1=1114112 p2=1 p3=0 obj#=-1 tim=7911408052
WAIT #140018920245008: nam='PGA memory operation' ela= 5 p1=1114112 p2=2 p3=0 obj#=-1 tim=7911408067
WAIT #140018920245008: nam='PGA memory operation' ela= 3 p1=1114112 p2=2 p3=0 obj#=-1 tim=7911408082
WAIT #140018920245008: nam='PGA memory operation' ela= 2 p1=1114112 p2=1 p3=0 obj#=-1 tim=7911408094
WAIT #140018920245008: nam='Data file init write' ela= 270 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911408632
WAIT #140018920245008: nam='Data file init write' ela= 289 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911409237
WAIT #140018920245008: nam='Data file init write' ela= 305 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911409862
WAIT #140018920245008: nam='Data file init write' ela= 231 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911410402
WAIT #140018920245008: nam='Data file init write' ela= 463 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911410968
WAIT #140018920245008: nam='Data file init write' ela= 284 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911411331
WAIT #140018920245008: nam='Data file init write' ela= 288 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911411695
WAIT #140018920245008: nam='Data file init write' ela= 261 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911412033
WAIT #140018920245008: nam='Data file init write' ela= 287 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911412395
WAIT #140018920245008: nam='Data file init write' ela= 286 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911412752
WAIT #140018920245008: nam='Data file init write' ela= 255 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911413077
WAIT #140018920245008: nam='Data file init write' ela= 242 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911413385
WAIT #140018920245008: nam='Data file init write' ela= 326 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911413776
WAIT #140018920245008: nam='Data file init write' ela= 279 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911414123
WAIT #140018920245008: nam='Data file init write' ela= 396 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911414588
WAIT #140018920245008: nam='Data file init write' ela= 512 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911415169
WAIT #140018920245008: nam='Data file init write' ela= 585 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911415822
WAIT #140018920245008: nam='Data file init write' ela= 557 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911416444
WAIT #140018920245008: nam='Data file init write' ela= 574 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911417098
WAIT #140018920245008: nam='Data file init write' ela= 631 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911417790
WAIT #140018920245008: nam='Data file init write' ela= 482 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911418342
WAIT #140018920245008: nam='Data file init write' ela= 476 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911418882
WAIT #140018920245008: nam='Data file init write' ela= 619 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911419567
WAIT #140018920245008: nam='Data file init write' ela= 544 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911420179
WAIT #140018920245008: nam='Data file init write' ela= 538 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911420786
WAIT #140018920245008: nam='Data file init write' ela= 975 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911421825
WAIT #140018920245008: nam='Data file init write' ela= 4392 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911426288
WAIT #140018920245008: nam='Data file init write' ela= 4352 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911430782
WAIT #140018920245008: nam='Data file init write' ela= 4324 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911435194
WAIT #140018920245008: nam='Data file init write' ela= 4338 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911439612
WAIT #140018920245008: nam='Data file init write' ela= 4443 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911444140
WAIT #140018920245008: nam='Data file init write' ela= 4458 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911448685
WAIT #140018920245008: nam='Data file init write' ela= 4483 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911453275
WAIT #140018920245008: nam='Data file init write' ela= 4509 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911457884
WAIT #140018920245008: nam='Data file init write' ela= 4483 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911462464
WAIT #140018920245008: nam='Data file init write' ela= 4326 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911466879
WAIT #140018920245008: nam='Data file init write' ela= 4571 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911471547
WAIT #140018920245008: nam='Data file init write' ela= 5297 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911476936
WAIT #140018920245008: nam='Data file init write' ela= 5323 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911482368
WAIT #140018920245008: nam='Data file init write' ela= 4441 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911486897
WAIT #140018920245008: nam='Data file init write' ela= 5246 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911492237
WAIT #140018920245008: nam='Data file init write' ela= 4524 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911496918
WAIT #140018920245008: nam='Data file init write' ela= 4847 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911501852
WAIT #140018920245008: nam='Data file init write' ela= 4922 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911506915
WAIT #140018920245008: nam='Data file init write' ela= 4380 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911511387
WAIT #140018920245008: nam='Data file init write' ela= 4419 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911515891
WAIT #140018920245008: nam='Data file init write' ela= 4326 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911520305
WAIT #140018920245008: nam='Data file init write' ela= 4330 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911524723
WAIT #140018920245008: nam='Data file init write' ela= 4340 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911529154
WAIT #140018920245008: nam='Data file init write' ela= 4458 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911533701
WAIT #140018920245008: nam='Data file init write' ela= 43 count=1 intr=256 timeout=4294967295 obj#=-1 tim=7911533763
WAIT #140018920245008: nam='Data file init write' ela= 1 count=4294967295 intr=256 timeout=2147483647 obj#=-1 tim=7911533775
更新基表
第十六步
PARSING IN CURSOR #140018911953376 len=372 dep=1 uid=0 oct=6 lid=0 tim=7911534231 hv=634533085 ad='69ef4498' sqlid='8pfdb7hkx4d6x'
update ts$ set name=:2,online$=:3,contents$=:4,undofile#=:5,undoblock#=:6, blocksize=:7,dflmaxext=:8,dflinit=:9,dflincr=:10,dflextpct=:11,dflminext=:12,dflminlen=:13,owner#=:14,scnwrp=:15,scnbas=:16,pitrscnwrp=:17,pitrscnbas=:18,dflogging=:19,bitmapped=:20,inc#=:21,flags=:22 + :27 * (4294967296 * 4294967296),plugged=:23,spare1=:24,spare2=:25,affstrength=:26 where ts#=:1
END OF STMT
PARSE #140018911953376:c=413,e=413,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911534231
BINDS #140018911953376:
Bind#0
oacdty=01 mxl=32(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=18 fl2=0001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=76d3520e bln=32 avl=02 flg=09
value="T1"
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835f20 bln=24 avl=02 flg=05
value=1
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835ef0 bln=24 avl=01 flg=05
value=0
Bind#3
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835ec0 bln=24 avl=01 flg=05
value=0
Bind#4
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835e90 bln=24 avl=01 flg=05
value=0
Bind#5
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835e50 bln=24 avl=03 flg=05
value=8192
Bind#6
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835e20 bln=24 avl=06 flg=05
value=2147483645
Bind#7
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835df0 bln=24 avl=02 flg=05
value=8
Bind#8
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835dc0 bln=24 avl=03 flg=05
value=128
Bind#9
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835d90 bln=24 avl=01 flg=05
value=0
Bind#10
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835d60 bln=24 avl=02 flg=05
value=1
Bind#11
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835d28 bln=24 avl=02 flg=05
value=8
Bind#12
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4400 bln=24 avl=01 flg=05
value=0
Bind#13
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b43d0 bln=24 avl=01 flg=05
value=0
Bind#14
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b43a0 bln=24 avl=01 flg=05
value=0
Bind#15
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4370 bln=24 avl=01 flg=05
value=0
Bind#16
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4340 bln=24 avl=05 flg=05
value=7119982
Bind#17
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4310 bln=24 avl=02 flg=05
value=1
Bind#18
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b42e0 bln=24 avl=02 flg=05
value=8
Bind#19
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b42b0 bln=24 avl=02 flg=05
value=1
Bind#20
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4280 bln=24 avl=03 flg=05
value=4129
Bind#21
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4190 bln=24 avl=01 flg=05
value=0
Bind#22
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4250 bln=24 avl=01 flg=05
value=0
Bind#23
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b4220 bln=24 avl=01 flg=05
value=0
Bind#24
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b41f0 bln=24 avl=01 flg=05
value=0
Bind#25
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18b41c0 bln=24 avl=06 flg=05
value=2147483645
Bind#26
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835f50 bln=22 avl=02 flg=05
value=6
EXEC #140018911953376:c=1474,e=1488,p=0,cr=2,cu=2,mis=1,r=1,dep=1,og=4,plh=2512490195,tim=7911535824
STAT #140018911953376 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE TS$ (cr=2 pr=0 pw=0 str=1 time=135 us)'
STAT #140018911953376 id=2 cnt=1 pid=1 pos=1 obj=16 op='TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 str=1 time=16 us cost=1 size=89 card=1)'
STAT #140018911953376 id=3 cnt=1 pid=2 pos=1 obj=7 op='INDEX UNIQUE SCAN I_TS# (cr=1 pr=0 pw=0 str=1 time=7 us cost=0 size=0 card=1)'
CLOSE #140018911953376:c=3,e=3,dep=1,type=0,tim=7911535895
WAIT #140018920245008: nam='log file sync' ela= 320 buffer#=1756 sync scn=7119988 p3=0 obj#=-1 tim=7911536264
WAIT #140018920245008: nam='control file sequential read' ela= 8 file#=0 block#=1 blocks=1 obj#=-1 tim=7911538434
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=1 block#=1 blocks=1 obj#=-1 tim=7911538456
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=16 blocks=1 obj#=-1 tim=7911538466
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=18 blocks=1 obj#=-1 tim=7911538473
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=180 blocks=1 obj#=-1 tim=7911538485
WAIT #140018920245008: nam='control file parallel write' ela= 607 files=2 block#=179 requests=2 obj#=-1 tim=7911539106
WAIT #140018920245008: nam='control file parallel write' ela= 379 files=2 block#=17 requests=2 obj#=-1 tim=7911539504
WAIT #140018920245008: nam='control file parallel write' ela= 352 files=2 block#=15 requests=2 obj#=-1 tim=7911539873
WAIT #140018920245008: nam='control file parallel write' ela= 341 files=2 block#=1 requests=2 obj#=-1 tim=7911540233
跟新基表
第十七步
PARSING IN CURSOR #140018911953376 len=67 dep=1 uid=0 oct=3 lid=0 tim=7911540703 hv=2352938862 ad='727999a8' sqlid='fd2rkjf63xzvf'
select file# from file$ where file$.status$=1 and file$.file# >= :1
END OF STMT
PARSE #140018911953376:c=374,e=374,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911540703
BINDS #140018911953376:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835f50 bln=22 avl=02 flg=05
value=1
EXEC #140018911953376:c=218,e=602,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=1512486435,tim=7911541349
FETCH #140018911953376:c=33,e=33,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=1512486435,tim=7911541397
第十八步
PARSING IN CURSOR #140018912020032 len=129 dep=1 uid=0 oct=3 lid=0 tim=7911541633 hv=1475149129 ad='6ad57378' sqlid='fvpmjbpbytza9'
select blocks,NVL(ts#,-1),status$,NVL(relfile#,0),maxextend,inc, crscnwrp,crscnbas,NVL(spare1,0),spare2 from file$ where file#=:1
END OF STMT
PARSE #140018912020032:c=217,e=217,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911541633
BINDS #140018912020032:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1885620 bln=22 avl=02 flg=05
value=5
EXEC #140018912020032:c=592,e=592,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=2970037075,tim=7911542266
FETCH #140018912020032:c=18,e=18,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=2970037075,tim=7911542297
STAT #140018912020032 id=1 cnt=1 pid=0 pos=1 obj=17 op='TABLE ACCESS BY INDEX ROWID FILE$ (cr=2 pr=0 pw=0 str=1 time=17 us cost=1 size=40 card=1)'
STAT #140018912020032 id=2 cnt=1 pid=1 pos=1 obj=43 op='INDEX UNIQUE SCAN I_FILE1 (cr=1 pr=0 pw=0 str=1 time=13 us cost=0 size=0 card=1)'
CLOSE #140018912020032:c=3,e=3,dep=1,type=0,tim=7911542343
STAT #140018911953376 id=1 cnt=1 pid=0 pos=1 obj=17 op='TABLE ACCESS FULL FILE$ (cr=2 pr=0 pw=0 str=1 time=32 us cost=2 size=6 card=1)'
CLOSE #140018911953376:c=75,e=75,dep=1,type=0,tim=7911542428
第十九步
PARSING IN CURSOR #140018911953376 len=102 dep=1 uid=0 oct=3 lid=0 tim=7911542641 hv=650734560 ad='724a6b70' sqlid='dgwrsxsmckuz0'
select /*+ INDEX_ASC(file$ i_file2) */ relfile# from file$ where ts#=:1 and relfile# between :2 and :3
END OF STMT
PARSE #140018911953376:c=197,e=197,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911542640
BINDS #140018911953376:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835f50 bln=22 avl=02 flg=05
value=6
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835f20 bln=24 avl=02 flg=05
value=5
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835ef0 bln=24 avl=03 flg=05
value=1023
EXEC #140018911953376:c=459,e=459,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=903563561,tim=7911543133
FETCH #140018911953376:c=12,e=12,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=903563561,tim=7911543157
STAT #140018911953376 id=1 cnt=0 pid=0 pos=1 obj=0 op='FILTER (cr=1 pr=0 pw=0 str=1 time=15 us)'
STAT #140018911953376 id=2 cnt=0 pid=1 pos=1 obj=44 op='INDEX RANGE SCAN I_FILE2 (cr=1 pr=0 pw=0 str=1 time=13 us cost=1 size=6 card=1)'
CLOSE #140018911953376:c=1,e=1,dep=1,type=0,tim=7911543194
第二十步
PARSING IN CURSOR #140018912545016 len=316 dep=2 uid=0 oct=3 lid=0 tim=7911543537 hv=2851274006 ad='73f16d18' sqlid='6h3cwmunz5z8q'
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)), max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$,0),64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
END OF STMT
PARSE #140018912545016:c=38,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=2968095032,tim=7911543537
BINDS #140018912545016:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1835b38 bln=22 avl=02 flg=05
value=17
EXEC #140018912545016:c=128,e=128,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=2968095032,tim=7911543701
FETCH #140018912545016:c=42,e=42,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=2968095032,tim=7911543750
STAT #140018912545016 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=0 pw=0 str=1 time=51 us cost=50 size=16 card=1)'
STAT #140018912545016 id=2 cnt=0 pid=1 pos=1 obj=61 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=2 pr=0 pw=0 str=1 time=40 us cost=3 size=16 card=1)'
STAT #140018912545016 id=3 cnt=0 pid=2 pos=1 obj=62 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 str=1 time=39 us cost=2 size=0 card=1)'
CLOSE #140018912545016:c=1,e=1,dep=2,type=3,tim=7911543811
第二十一步
PARSING IN CURSOR #140018912023560 len=298 dep=2 uid=0 oct=3 lid=0 tim=7911544200 hv=3498487326 ad='74f63738' sqlid='a4n4ayr88dbhy'
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)),max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$,0),64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
END OF STMT
PARSE #140018912023560:c=378,e=378,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,plh=0,tim=7911544199
BINDS #140018912023560:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1887b88 bln=22 avl=02 flg=05
value=17
EXEC #140018912023560:c=501,e=831,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,plh=2968095032,tim=7911545065
FETCH #140018912023560:c=30,e=30,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,plh=2968095032,tim=7911545104
FETCH #140018912023560:c=3,e=3,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=2968095032,tim=7911545122
STAT #140018912023560 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=3 pr=0 pw=0 str=1 time=34 us cost=4 size=16 card=1)'
STAT #140018912023560 id=2 cnt=1 pid=1 pos=1 obj=61 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=3 pr=0 pw=0 str=1 time=18 us cost=3 size=16 card=1)'
STAT #140018912023560 id=3 cnt=1 pid=2 pos=1 obj=62 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 str=1 time=7 us cost=2 size=0 card=1)'
CLOSE #140018912023560:c=0,e=0,dep=2,type=3,tim=7911545215
第二十二步
PARSING IN CURSOR #140018911953376 len=194 dep=1 uid=0 oct=6 lid=0 tim=7911545256 hv=824271381 ad='697f3728' sqlid='bth82q0sk2shp'
update file$ set blocks=:2,ts#=DECODE(:3,-1,NULL,:3),status$=:4, relfile#=DECODE(:5,0,NULL,:5),maxextend=:6,inc=:7,crscnwrp=:8,crscnbas=:9,spare1=DECODE(:10,0,NULL,:10),spare2=:11 where file#=:1
END OF STMT
PARSE #140018911953376:c=1885,e=2044,p=0,cr=5,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911545256
BINDS #140018911953376:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886728 bln=24 avl=01 flg=05
value=0
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18866f8 bln=24 avl=02 flg=05
value=6
Bind#2
No oacdef for this bind.
Bind#3
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18866c8 bln=24 avl=02 flg=05
value=2
Bind#4
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886698 bln=24 avl=02 flg=05
value=5
Bind#5
No oacdef for this bind.
Bind#6
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886668 bln=24 avl=01 flg=05
value=0
Bind#7
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886638 bln=24 avl=01 flg=05
value=0
Bind#8
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886608 bln=24 avl=06 flg=05
value=4294967295
Bind#9
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18865d8 bln=24 avl=06 flg=05
value=4294967295
Bind#10
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18865a8 bln=24 avl=05 flg=05
value=20971522
Bind#11
No oacdef for this bind.
Bind#12
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886578 bln=24 avl=01 flg=05
value=0
Bind#13
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886758 bln=22 avl=02 flg=05
value=5
EXEC #140018911953376:c=894,e=889,p=0,cr=1,cu=3,mis=1,r=1,dep=1,og=4,plh=2821832985,tim=7911546183
STAT #140018911953376 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE FILE$ (cr=1 pr=0 pw=0 str=1 time=87 us)'
STAT #140018911953376 id=2 cnt=1 pid=1 pos=1 obj=43 op='INDEX UNIQUE SCAN I_FILE1 (cr=1 pr=0 pw=0 str=1 time=3 us cost=0 size=40 card=1)'
CLOSE #140018911953376:c=3,e=3,dep=1,type=0,tim=7911546232
WAIT #140018920245008: nam='log file sync' ela= 551 buffer#=1758 sync scn=7119990 p3=0 obj#=-1 tim=7911546807
WAIT #140018920245008: nam='control file sequential read' ela= 8 file#=0 block#=1 blocks=1 obj#=-1 tim=7911546857
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=1 block#=1 blocks=1 obj#=-1 tim=7911546870
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=15 blocks=1 obj#=-1 tim=7911546878
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=17 blocks=1 obj#=-1 tim=7911546886
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=31 blocks=1 obj#=-1 tim=7911546902
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=0 block#=23 blocks=1 obj#=-1 tim=7911546916
WAIT #140018920245008: nam='control file sequential read' ela= 5 file#=0 block#=179 blocks=1 obj#=-1 tim=7911547001
WAIT #140018920245008: nam='db file single write' ela= 10 file#=5 block#=1 blocks=1 obj#=-1 tim=7911547673
WAIT #140018920245008: nam='control file parallel write' ela= 244 files=2 block#=32 requests=2 obj#=-1 tim=7911547932
WAIT #140018920245008: nam='control file parallel write' ela= 155 files=2 block#=24 requests=2 obj#=-1 tim=7911548102
WAIT #140018920245008: nam='control file parallel write' ela= 247 files=2 block#=180 requests=2 obj#=-1 tim=7911548363
WAIT #140018920245008: nam='control file parallel write' ela= 167 files=2 block#=18 requests=2 obj#=-1 tim=7911548550
WAIT #140018920245008: nam='control file parallel write' ela= 145 files=2 block#=16 requests=2 obj#=-1 tim=7911548712
WAIT #140018920245008: nam='control file parallel write' ela= 136 files=2 block#=1 requests=2 obj#=-1 tim=7911548865
WAIT #140018920245008: nam='Disk file operations I/O' ela= 31483 FileOperation=5 fileno=0 filetype=2 obj#=-1 tim=7911580367
WAIT #140018920245008: nam='DLM cross inst call completion' ela= 380 caller instance number=1 cluster incarnation number=4294967295 request identifier=2 obj#=-1 tim=7911580895
WAIT #140018920245008: nam='rdbms ipc reply' ela= 236 from_process=19 p2=0 p3=0 obj#=-1 tim=7911581698
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=0 block#=1 blocks=1 obj#=-1 tim=7911581740
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=1 block#=1 blocks=1 obj#=-1 tim=7911581752
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=16 blocks=1 obj#=-1 tim=7911581760
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=18 blocks=1 obj#=-1 tim=7911581767
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=0 block#=24 blocks=1 obj#=-1 tim=7911581809
WAIT #140018920245008: nam='Disk file operations I/O' ela= 15 FileOperation=2 fileno=5 filetype=2 obj#=-1 tim=7911581838
WAIT #140018920245008: nam='db file sequential read' ela= 5 file#=5 block#=1 blocks=1 obj#=-1 tim=7911581926
WAIT #140018920245008: nam='db file sequential read' ela= 4 file#=5 block#=1 blocks=1 obj#=-1 tim=7911582033
WAIT #140018920245008: nam='db file single write' ela= 126 file#=5 block#=1 blocks=1 obj#=-1 tim=7911582239
WAIT #140018920245008: nam='control file parallel write' ela= 244 files=2 block#=23 requests=2 obj#=-1 tim=7911582500
WAIT #140018920245008: nam='control file parallel write' ela= 219 files=2 block#=17 requests=2 obj#=-1 tim=7911582736
WAIT #140018920245008: nam='control file parallel write' ela= 212 files=2 block#=15 requests=2 obj#=-1 tim=7911582961
WAIT #140018920245008: nam='control file parallel write' ela= 172 files=2 block#=1 requests=2 obj#=-1 tim=7911583150
WAIT #140018920245008: nam='control file sequential read' ela= 7 file#=0 block#=1 blocks=1 obj#=-1 tim=7911583211
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=15 blocks=1 obj#=-1 tim=7911583224
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=17 blocks=1 obj#=-1 tim=7911583231
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=285 blocks=1 obj#=-1 tim=7911583239
WAIT #140018920245008: nam='DLM cross inst call completion' ela= 347 caller instance number=1 cluster incarnation number=4294967295 request identifier=3 obj#=-1 tim=7911583616
WAIT #140018920245008: nam='control file sequential read' ela= 6 file#=0 block#=1 blocks=1 obj#=-1 tim=7911583674
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=1 block#=1 blocks=1 obj#=-1 tim=7911583688
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=15 blocks=1 obj#=-1 tim=7911583695
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=17 blocks=1 obj#=-1 tim=7911583702
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=23 blocks=1 obj#=-1 tim=7911583711
WAIT #140018920245008: nam='control file parallel write' ela= 147 files=2 block#=24 requests=2 obj#=-1 tim=7911583865
WAIT #140018920245008: nam='control file parallel write' ela= 129 files=2 block#=18 requests=2 obj#=-1 tim=7911584034
WAIT #140018920245008: nam='control file parallel write' ela= 126 files=2 block#=16 requests=2 obj#=-1 tim=7911584175
WAIT #140018920245008: nam='control file parallel write' ela= 122 files=2 block#=1 requests=2 obj#=-1 tim=7911584311
WAIT #140018920245008: nam='DLM cross inst call completion' ela= 98 caller instance number=1 cluster incarnation number=4294967295 request identifier=4 obj#=-1 tim=7911584446
跟新基表
第二十三步
PARSING IN CURSOR #140018911953376 len=194 dep=1 uid=0 oct=6 lid=0 tim=7911584518 hv=824271381 ad='697f3728' sqlid='bth82q0sk2shp'
update file$ set blocks=:2,ts#=DECODE(:3,-1,NULL,:3),status$=:4, relfile#=DECODE(:5,0,NULL,:5),maxextend=:6,inc=:7,crscnwrp=:8,crscnbas=:9,spare1=DECODE(:10,0,NULL,:10),spare2=:11 where file#=:1
END OF STMT
PARSE #140018911953376:c=31,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2821832985,tim=7911584517
BINDS #140018911953376:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886728 bln=24 avl=02 flg=05
value=6400
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18866f8 bln=24 avl=02 flg=05
value=6
Bind#2
No oacdef for this bind.
Bind#3
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18866c8 bln=24 avl=02 flg=05
value=2
Bind#4
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886698 bln=24 avl=02 flg=05
value=5
Bind#5
No oacdef for this bind.
Bind#6
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886668 bln=24 avl=01 flg=05
value=0
Bind#7
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886638 bln=24 avl=01 flg=05
value=0
Bind#8
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886608 bln=24 avl=01 flg=05
value=0
Bind#9
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18865d8 bln=24 avl=05 flg=05
value=7119993
Bind#10
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18865a8 bln=24 avl=05 flg=05
value=20971522
Bind#11
No oacdef for this bind.
Bind#12
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886578 bln=24 avl=01 flg=05
value=0
Bind#13
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886758 bln=22 avl=02 flg=05
value=5
EXEC #140018911953376:c=207,e=207,p=0,cr=1,cu=1,mis=0,r=1,dep=1,og=4,plh=2821832985,tim=7911584769
STAT #140018911953376 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE FILE$ (cr=1 pr=0 pw=0 str=1 time=50 us)'
STAT #140018911953376 id=2 cnt=1 pid=1 pos=1 obj=43 op='INDEX UNIQUE SCAN I_FILE1 (cr=1 pr=0 pw=0 str=1 time=9 us cost=0 size=40 card=1)'
CLOSE #140018911953376:c=3,e=3,dep=1,type=0,tim=7911584818
CLOSE #140018912085992:c=3,e=3,dep=1,type=0,tim=7911585009
再次更新
第二十四步
PARSING IN CURSOR #140018912085992 len=123 dep=1 uid=0 oct=2 lid=0 tim=7911585244 hv=1793427089 ad='76c88ca8' sqlid='gk2jpj9pfb1nj'
insert into WRI$_ALERT_THRESHOLD_LOG (sequence_id, object_type, object_name, object_id, opcode) values (:1, :2, :3, :4, :5)
END OF STMT
PARSE #140018912085992:c=214,e=214,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911585244
BINDS #140018912085992:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=0000 frm=00 csi=00 siz=128 off=0
kxsbbbfp=7f58b1887b20 bln=22 avl=03 flg=05
value=599
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=0000 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7f58b1887b38 bln=22 avl=02 flg=01
value=5
Bind#2
oacdty=01 mxl=32(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=21 fl2=0000 frm=01 csi=873 siz=0 off=48
kxsbbbfp=7f58b1887b50 bln=32 avl=02 flg=01
value="T1"
Bind#3
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=0000 frm=00 csi=00 siz=0 off=80
kxsbbbfp=7f58b1887b70 bln=22 avl=02 flg=01
value=6
Bind#4
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=01 fl2=0000 frm=00 csi=00 siz=0 off=104
kxsbbbfp=7f58b1887b88 bln=22 avl=02 flg=01
value=1
EXEC #140018912085992:c=676,e=1390,p=0,cr=1,cu=4,mis=1,r=1,dep=1,og=4,plh=0,tim=7911586664
STAT #140018912085992 id=1 cnt=0 pid=0 pos=1 obj=0 op='LOAD TABLE CONVENTIONAL WRI$_ALERT_THRESHOLD_LOG (cr=1 pr=0 pw=0 str=1 time=179 us)'
WAIT #140018920245008: nam='rdbms ipc reply' ela= 588 from_process=21 p2=0 p3=0 obj#=-1 tim=7911587341
WAIT #140018920245008: nam='Disk file operations I/O' ela= 14 FileOperation=2 fileno=5 filetype=2 obj#=-1 tim=7911587386
WAIT #140018920245008: nam='Disk file operations I/O' ela= 5 FileOperation=5 fileno=5 filetype=2 obj#=-1 tim=7911587399
第二十五步 更新控制文件
*** 2023-03-14T20:14:37.710508+08:00
WAIT #140018920245008: nam='control file sequential read' ela= 11 file#=0 block#=1 blocks=1 obj#=-1 tim=7911589848
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=1 block#=1 blocks=1 obj#=-1 tim=7911589880
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=16 blocks=1 obj#=-1 tim=7911589890
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=18 blocks=1 obj#=-1 tim=7911589899
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=24 blocks=1 obj#=-1 tim=7911589910
WAIT #140018920245008: nam='db file sequential read' ela= 2 file#=5 block#=1 blocks=1 obj#=-1 tim=7911589920
WAIT #140018920245008: nam='log file sync' ela= 190 buffer#=1765 sync scn=7120001 p3=0 obj#=-1 tim=7911590701
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=0 block#=1 blocks=1 obj#=-1 tim=7911590734
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=1 block#=1 blocks=1 obj#=-1 tim=7911590745
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=16 blocks=1 obj#=-1 tim=7911590753
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=18 blocks=1 obj#=-1 tim=7911590760
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=24 blocks=1 obj#=-1 tim=7911590770
WAIT #140018920245008: nam='db file sequential read' ela= 2 file#=5 block#=1 blocks=1 obj#=-1 tim=7911590779
WAIT #140018920245008: nam='db file single write' ela= 69 file#=5 block#=1 blocks=1 obj#=-1 tim=7911590863
WAIT #140018920245008: nam='control file parallel write' ela= 131 files=2 block#=17 requests=2 obj#=-1 tim=7911591009
WAIT #140018920245008: nam='control file parallel write' ela= 123 files=2 block#=15 requests=2 obj#=-1 tim=7911591145
WAIT #140018920245008: nam='control file parallel write' ela= 142 files=2 block#=1 requests=2 obj#=-1 tim=7911591303
WAIT #140018920245008: nam='control file sequential read' ela= 7 file#=0 block#=1 blocks=1 obj#=-1 tim=7911591360
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=15 blocks=1 obj#=-1 tim=7911591372
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=17 blocks=1 obj#=-1 tim=7911591381
第二十六步
PARSING IN CURSOR #140018912360104 len=56 dep=1 uid=0 oct=3 lid=0 tim=7911591562 hv=1883580036 ad='74cda730' sqlid='6xvp6nxs4a9n4'
select nvl(sum(space),0) from recyclebin$ where ts# = :1
END OF STMT
PARSE #140018912360104:c=1,e=158,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911591561
BINDS #140018912360104:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886758 bln=22 avl=02 flg=05
value=6
EXEC #140018912360104:c=0,e=685,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=571474032,tim=7911592273
FETCH #140018912360104:c=0,e=37,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=571474032,tim=7911592364
STAT #140018912360104 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=2 pr=0 pw=0 str=1 time=40 us)'
STAT #140018912360104 id=2 cnt=0 pid=1 pos=1 obj=263 op='TABLE ACCESS FULL RECYCLEBIN$ (cr=2 pr=0 pw=0 str=1 time=36 us cost=2 size=133 card=19)'
CLOSE #140018912360104:c=3,e=3,dep=1,type=0,tim=7911592420
第二十七步
PARSING IN CURSOR #140018912360104 len=101 dep=1 uid=0 oct=3 lid=0 tim=7911592569 hv=2116789016 ad='72a2d5d8' sqlid='csnp95dz2r8ss'
select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
END OF STMT
PARSE #140018912360104:c=139,e=139,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=7911592569
BINDS #140018912360104:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886758 bln=22 avl=02 flg=05
value=6
EXEC #140018912360104:c=416,e=416,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=1329207485,tim=7911593011
FETCH #140018912360104:c=13,e=13,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,plh=1329207485,tim=7911593031
STAT #140018912360104 id=1 cnt=0 pid=0 pos=1 obj=263 op='TABLE ACCESS FULL RECYCLEBIN$ (cr=2 pr=0 pw=0 str=1 time=13 us cost=2 size=14 card=1)'
CLOSE #140018912360104:c=2,e=2,dep=1,type=0,tim=7911593064
BINDS #140018912264800:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=80 off=0
kxsbbbfp=7f58b1886720 bln=22 avl=03 flg=05
value=101
Bind#1
oacdty=01 mxl=32(17) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=873 siz=0 off=24
kxsbbbfp=7f58b1886738 bln=32 avl=17 flg=01
value="LBAC$AFTER_CREATE"
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=56
kxsbbbfp=7f58b1886758 bln=22 avl=02 flg=01
value=3
EXEC #140018912264800:c=66,e=66,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=813480514,tim=7911593391
FETCH #140018912264800:c=0,e=27,p=0,cr=4,cu=0,mis=0,r=1,dep=1,og=4,plh=813480514,tim=7911593425
CLOSE #140018912264800:c=0,e=4,dep=1,type=3,tim=7911593442
PARSE #140018912252904:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1637390370,tim=7911593489
BINDS #140018912252904:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886758 bln=22 avl=04 flg=05
value=72118
EXEC #140018912252904:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1637390370,tim=7911593525
FETCH #140018912252904:c=251,e=130,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=1637390370,tim=7911593661
CLOSE #140018912252904:c=3,e=3,dep=1,type=3,tim=7911593682
PARSE #140018912251264:c=7,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1475428744,tim=7911593706
BINDS #140018912251264:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886758 bln=22 avl=04 flg=05
value=72118
EXEC #140018912251264:c=44,e=44,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1475428744,tim=7911593769
FETCH #140018912251264:c=50,e=50,p=0,cr=11,cu=0,mis=0,r=1,dep=1,og=4,plh=1475428744,tim=7911593826
FETCH #140018912251264:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=1475428744,tim=7911593843
FETCH #140018912251264:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=1475428744,tim=7911593853
FETCH #140018912251264:c=3,e=3,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1475428744,tim=7911593870
CLOSE #140018912251264:c=3,e=3,dep=1,type=3,tim=7911593885
PARSE #140018912218400:c=30,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=570326988,tim=7911593922
BINDS #140018912218400:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886758 bln=22 avl=04 flg=05
value=72118
EXEC #140018912218400:c=27,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=570326988,tim=7911593967
FETCH #140018912218400:c=15,e=15,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=570326988,tim=7911593988
FETCH #140018912218400:c=2,e=2,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=570326988,tim=7911594031
CLOSE #140018912218400:c=2,e=2,dep=1,type=3,tim=7911594046
第二十八步
PARSING IN CURSOR #140018912358056 len=47 dep=1 uid=0 oct=3 lid=0 tim=7911594076 hv=61740290 ad='7291b0e0' sqlid='3k0c6241uw582'
select actionsize from trigger$ where obj# = :1
END OF STMT
PARSE #140018912358056:c=20,e=20,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1964643588,tim=7911594076
BINDS #140018912358056:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886340 bln=22 avl=04 flg=05
value=72118
EXEC #140018912358056:c=26,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1964643588,tim=7911594122
FETCH #140018912358056:c=7,e=7,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=1964643588,tim=7911594134
STAT #140018912358056 id=1 cnt=1 pid=0 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=7 us cost=1 size=9 card=1)'
STAT #140018912358056 id=2 cnt=1 pid=1 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=2 us cost=0 size=0 card=1)'
CLOSE #140018912358056:c=2,e=2,dep=1,type=0,tim=7911594206
第二十九步
PARSING IN CURSOR #140018912358056 len=44 dep=1 uid=0 oct=3 lid=0 tim=7911594227 hv=4065623913 ad='68ef0660' sqlid='07pcqtmt58zv9'
select action# from trigger$ where obj# = :1
END OF STMT
PARSE #140018912358056:c=14,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1964643588,tim=7911594227
BINDS #140018912358056:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886340 bln=22 avl=04 flg=05
value=72118
EXEC #140018912358056:c=25,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1964643588,tim=7911594271
FETCH #140018912358056:c=7,e=7,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=1964643588,tim=7911594283
STAT #140018912358056 id=1 cnt=1 pid=0 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=5 us cost=1 size=8 card=1)'
STAT #140018912358056 id=2 cnt=1 pid=1 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=3 us cost=0 size=0 card=1)'
CLOSE #140018912358056:c=29,e=29,dep=1,type=0,tim=7911594320
第三十步
PARSING IN CURSOR #140018912358056 len=249 dep=1 uid=0 oct=3 lid=0 tim=7911594343 hv=1913856419 ad='6ac5f2b8' sqlid='7akvnu9t168d3'
select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,rowid,actionlineno,trignameline,trignamecol, trignamecolofs,actioncolno from trigger$ where obj# =:1
END OF STMT
PARSE #140018912358056:c=13,e=13,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1964643588,tim=7911594343
BINDS #140018912358056:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b18855d0 bln=22 avl=04 flg=05
value=72118
EXEC #140018912358056:c=31,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1964643588,tim=7911594394
FETCH #140018912358056:c=4,e=4,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=1964643588,tim=7911594403
STAT #140018912358056 id=1 cnt=1 pid=0 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=3 us cost=1 size=156 card=1)'
STAT #140018912358056 id=2 cnt=1 pid=1 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=2 us cost=0 size=0 card=1)'
CLOSE #140018912358056:c=2,e=2,dep=1,type=0,tim=7911594446
第三十一步
PARSING IN CURSOR #140018912358056 len=800 dep=1 uid=0 oct=3 lid=0 tim=7911594462 hv=733123428 ad='71bbf158' sqlid='5wxyshspv54v4'
select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale,c.precision#,c.charsetid,c.charsetform, decode(bitand(c.property,8388608),8388608, c.spare3, 0) from
triggercol$ tc,col$ c, trigger$ tr where tc.obj#=:1 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property,32) != 32 or bitand(tc.type#,20) = 20)
and ( c.obj#=:2 and (bitand(tc.type#, 1024) = :3 or tc.type# = 0) or c.obj#=:4 and bitand(tc.type#, 1024) = :5 or c.obj#=:6 and tc.type# = 0
and tc.position# = 0) union select type#,intcol#,position#,69,0,0,0,0,0,0 from triggercol$ where obj#=:7 and intcol#=1001 union select tc.type#,tc.intcol#,
tc.position#,121,0,0,0,0,0,0 from triggercol$ tc,trigger$ tr where tr.obj# = tc.obj# and bitand(tr.property,32) = 32 and tc.obj# = :8 and bitand(tc.type#,20) != 20
END OF STMT
PARSE #140018912358056:c=10,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3009292138,tim=7911594462
BINDS #140018912358056:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=192 off=0
kxsbbbfp=7f58b1885db8 bln=22 avl=04 flg=05
value=72118
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7f58b1885dd0 bln=22 avl=01 flg=01
value=0
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7f58b1885de8 bln=22 avl=01 flg=01
value=0
Bind#3
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=72
kxsbbbfp=7f58b1885e00 bln=22 avl=01 flg=01
value=0
Bind#4
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=96
kxsbbbfp=7f58b1885e18 bln=22 avl=01 flg=01
value=0
Bind#5
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=120
kxsbbbfp=7f58b1885e30 bln=22 avl=01 flg=01
value=0
Bind#6
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=144
kxsbbbfp=7f58b1885e48 bln=22 avl=04 flg=01
value=72118
Bind#7
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=168
kxsbbbfp=7f58b1885e60 bln=22 avl=04 flg=01
value=72118
EXEC #140018912358056:c=112,e=112,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3009292138,tim=7911594658
FETCH #140018912358056:c=0,e=37,p=0,cr=16,cu=0,mis=0,r=0,dep=1,og=4,plh=3009292138,tim=7911594701
STAT #140018912358056 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT UNIQUE (cr=16 pr=0 pw=0 str=1 time=42 us cost=15 size=297 card=9)'
STAT #140018912358056 id=2 cnt=0 pid=1 pos=1 obj=0 op='UNION-ALL (cr=16 pr=0 pw=0 str=1 time=37 us)'
STAT #140018912358056 id=3 cnt=0 pid=2 pos=1 obj=0 op='CONCATENATION (cr=12 pr=0 pw=0 str=1 time=29 us)'
STAT #140018912358056 id=4 cnt=0 pid=3 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=17 us cost=3 size=56 card=1)'
STAT #140018912358056 id=5 cnt=0 pid=4 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=16 us cost=3 size=56 card=1)'
STAT #140018912358056 id=6 cnt=0 pid=5 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=14 us cost=2 size=23 card=1)'
STAT #140018912358056 id=7 cnt=1 pid=6 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=4 us cost=1 size=9 card=1)'
STAT #140018912358056 id=8 cnt=1 pid=7 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=2 us cost=0 size=0 card=1)'
STAT #140018912358056 id=9 cnt=0 pid=6 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 str=1 time=9 us cost=1 size=14 card=1)'
STAT #140018912358056 id=10 cnt=0 pid=5 pos=2 obj=50 op='INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 str=0 time=0 us cost=0 size=0 card=1)'
STAT #140018912358056 id=11 cnt=0 pid=4 pos=2 obj=21 op='TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=33 card=1)'
STAT #140018912358056 id=12 cnt=0 pid=3 pos=2 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=4 us cost=3 size=56 card=1)'
STAT #140018912358056 id=13 cnt=0 pid=12 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=4 us cost=3 size=56 card=1)'
STAT #140018912358056 id=14 cnt=0 pid=13 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=4 us cost=2 size=23 card=1)'
STAT #140018912358056 id=15 cnt=1 pid=14 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=2 us cost=1 size=9 card=1)'
STAT #140018912358056 id=16 cnt=1 pid=15 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=1 us cost=0 size=0 card=1)'
STAT #140018912358056 id=17 cnt=0 pid=14 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 str=1 time=2 us cost=1 size=14 card=1)'
STAT #140018912358056 id=18 cnt=0 pid=13 pos=2 obj=50 op='INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 str=0 time=0 us cost=0 size=0 card=1)'
STAT #140018912358056 id=19 cnt=0 pid=12 pos=2 obj=21 op='TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=33 card=1)'
STAT #140018912358056 id=20 cnt=0 pid=3 pos=3 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=6 us cost=3 size=56 card=1)'
STAT #140018912358056 id=21 cnt=0 pid=20 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=4 us cost=3 size=56 card=1)'
STAT #140018912358056 id=22 cnt=0 pid=21 pos=1 obj=0 op='NESTED LOOPS (cr=4 pr=0 pw=0 str=1 time=4 us cost=2 size=23 card=1)'
STAT #140018912358056 id=23 cnt=1 pid=22 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=0 us cost=1 size=9 card=1)'
STAT #140018912358056 id=24 cnt=1 pid=23 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=0 us cost=0 size=0 card=1)'
STAT #140018912358056 id=25 cnt=0 pid=22 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 str=1 time=3 us cost=1 size=14 card=1)'
STAT #140018912358056 id=26 cnt=0 pid=21 pos=2 obj=50 op='INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 str=0 time=0 us cost=0 size=0 card=1)'
STAT #140018912358056 id=27 cnt=0 pid=20 pos=2 obj=21 op='TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=33 card=1)'
STAT #140018912358056 id=28 cnt=0 pid=2 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 str=1 time=2 us cost=2 size=14 card=1)'
STAT #140018912358056 id=29 cnt=0 pid=2 pos=3 obj=0 op='NESTED LOOPS (cr=2 pr=0 pw=0 str=1 time=4 us cost=2 size=115 card=5)'
STAT #140018912358056 id=30 cnt=0 pid=29 pos=1 obj=281 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 str=1 time=3 us cost=1 size=9 card=1)'
STAT #140018912358056 id=31 cnt=1 pid=30 pos=1 obj=284 op='INDEX UNIQUE SCAN I_TRIGGER2 (cr=1 pr=0 pw=0 str=1 time=0 us cost=0 size=0 card=1)'
STAT #140018912358056 id=32 cnt=0 pid=29 pos=2 obj=286 op='INDEX RANGE SCAN I_TRIGGERCOL2 (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=70 card=5)'
CLOSE #140018912358056:c=2,e=2,dep=1,type=0,tim=7911595239
第三十二步
PARSING IN CURSOR #140018912358056 len=203 dep=1 uid=0 oct=3 lid=0 tim=7911595265 hv=4144798879 ad='69c4e600' sqlid='4zzxr8rvht74z'
select case when (bitand(u.spare1, 16) = 0) then 0 when (u.type# = 2) then (u.spare2) else 1 end from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
END OF STMT
PARSE #140018912358056:c=19,e=19,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3368685730,tim=7911595265
BINDS #140018912358056:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f58b1886340 bln=22 avl=04 flg=05
value=72118
EXEC #140018912358056:c=36,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3368685730,tim=7911595321
FETCH #140018912358056:c=12,e=12,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=3368685730,tim=7911595339
STAT #140018912358056 id=1 cnt=1 pid=0 pos=1 obj=0 op='HASH JOIN (cr=3 pr=0 pw=0 str=1 time=14 us cost=3 size=33 card=1)'
STAT #140018912358056 id=2 cnt=1 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=3 pr=0 pw=0 str=1 time=11 us cost=3 size=33 card=1)'
STAT #140018912358056 id=3 cnt=1 pid=2 pos=1 obj=0 op='STATISTICS COLLECTOR (cr=2 pr=0 pw=0 str=1 time=8 us)'
STAT #140018912358056 id=4 cnt=1 pid=3 pos=1 obj=36 op='INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 str=1 time=6 us cost=2 size=8 card=1)'
STAT #140018912358056 id=5 cnt=1 pid=2 pos=2 obj=47 op='INDEX RANGE SCAN I_USER2 (cr=1 pr=0 pw=0 str=1 time=3 us cost=1 size=25 card=1)'
STAT #140018912358056 id=6 cnt=0 pid=1 pos=2 obj=47 op='INDEX FULL SCAN I_USER2 (cr=0 pr=0 pw=0 str=0 time=0 us cost=1 size=25 card=1)'
CLOSE #140018912358056:c=71,e=71,dep=1,type=0,tim=7911595419
XCTEND rlbk=0, rd_only=1, tim=7911595470
EXEC #140018920245008:c=175536,e=227219,p=9,cr=129,cu=154,mis=0,r=0,dep=0,og=1,plh=0,tim=7911595508
WAIT #140018920245008: nam='Disk file operations I/O' ela= 18 FileOperation=8 fileno=0 filetype=8 obj#=-1 tim=7911595540
WAIT #140018920245008: nam='log file sync' ela= 152 buffer#=1793 sync scn=7120008 p3=0 obj#=-1 tim=7911595717
WAIT #140018920245008: nam='PGA memory operation' ela= 155 p1=0 p2=0 p3=0 obj#=-1 tim=7911595922
WAIT #140018920245008: nam='SQL*Net message to client' ela= 1 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7911595937
*** 2023-03-14T20:15:04.935624+08:00
WAIT #140018920245008: nam='SQL*Net message from client' ela= 27219010 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7938814955
CLOSE #140018920245008:c=6,e=6,dep=0,type=0,tim=7938815034
总结
目前来看整个流程主要的dml操作是
第十二步
调用sys.dbms_standard.dictionary_obj_name函数
第十五步
insert into ts$ (ts#,name,online$,contents$,undofile#,undoblock#,blocksize, dflmaxext,dflinit,dflincr,dflextpct,dflminext,dflminlen,inc#,
owner#,scnwrp,scnbas,pitrscnwrp,pitrscnbas,dflogging, bitmapped,plugged,directallowed,flags,spare1,spare2, affstrength) values
(6,'T1',3,0,0,0,8192,2147483645,8,128,0,1,8,1,0,0,0,0,7119982,1,0,0,1,4129 + 2147483645 * (4294967296 * 4294967296),0,0,0);
检查下当前值
SQL> select ts#,name,online$,contents$,undofile#,undoblock#,blocksize, dflmaxext,dflinit,dflincr,dflextpct,dflminext,dflminlen,inc#,
2 owner#,scnwrp,scnbas,pitrscnwrp,pitrscnbas,dflogging, bitmapped,plugged,directallowed,flags,spare1,spare2, affstrength from ts$;
TS# NAME ONLINE$ CONTENTS$ UNDOFILE# UNDOBLOCK# BLOCKSIZE DFLMAXEXT DFLINIT DFLINCR DFLEXTPCT DFLMINEXT DFLMINLEN INC# OWNER# SCNWRP SCNBAS PITRSCNWRP PITRSCNBAS DFLOGGING BITMAPPED PLUGGED DIRECTALLOWED FLAGS SPARE1 SPARE2 AFFSTRENGTH
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------------- ---------- ---------- ---------- -----------
0 SYSTEM 1 0 0 0 8192 2147483645 8 128 0 1 8 1 0 0 0 0 7 3 8 1 12289 0 0 2147483645
1 SYSAUX 1 0 0 0 8192 2147483645 8 128 0 1 8 1 0 0 0 0 5469 3 8 1 12321 0 0 2147483645
2 UNDOTBS1 1 0 0 0 8192 2147483645 8 128 0 1 8 2 0 0 0 0 1920437 1 8 1 12305 0 0 2147483645
3 TEMP 1 1 0 0 8192 2147483645 128 128 0 1 128 1 0 0 0 0 7237 0 128 1 12290 0 0 2147483645
4 USERS 1 0 0 0 8192 2147483645 8 128 0 1 8 1 0 0 0 0 32861 1 8 1 4129 0 0 2147483645
5 UNDOTBS2 3 0 0 0 8192 2147483645 8 128 0 1 8 1 0 0 0 0 1920005 1 8 1 12305 0 0 2147483645
6 T1 1 0 0 0 8192 2147483645 8 128 0 1 8 1 0 0 0 0 7119982 1 8 1 4129 0 0 2147483645
7 rows selected.
注意：当时是将online$修改为3，3代表什么不知道。看来2才是离线状态，那么3代表什么。DFLMAXEXT，DFLMINLEN代初始小区大小和最大区大小
SQL> alter tablespace users offline;
Tablespace altered.
SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------------------------------------ ------------------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS OFFLINE
T1 ONLINE
6 rows selected.
SQL> select ts#,name,online$,contents$,undofile#,undoblock#,blocksize, dflmaxext,dflinit,dflincr,dflextpct,dflminext,dflminlen,inc#,
2 owner#,scnwrp,scnbas,pitrscnwrp,pitrscnbas,dflogging, bitmapped,plugged,directallowed,flags,spare1,spare2, affstrength from ts$;
TS# NAME ONLINE$ CONTENTS$ UNDOFILE# UNDOBLOCK# BLOCKSIZE DFLMAXEXT DFLINIT DFLINCR DFLEXTPCT DFLMINEXT DFLMINLEN INC# OWNER# SCNWRP SCNBAS PITRSCNWRP PITRSCNBAS DFLOGGING BITMAPPED PLUGGED DIRECTALLOWED FLAGS SPARE1 SPARE2 AFFSTRENGTH
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------------- ---------- ---------- ---------- -----------
0 SYSTEM 1 0 0 0 8192 2147483645 8 128 0 1 8 1 0 0 0 0 7 3 8 1 12289 0 0 2147483645
1 SYSAUX 1 0 0 0 8192 2147483645 8 128 0 1 8 1 0 0 0 0 5469 3 8 1 12321 0 0 2147483645
2 UNDOTBS1 1 0 0 0 8192 2147483645 8 128 0 1 8 2 0 0 0 0 1920437 1 8 1 12305 0 0 2147483645
3 TEMP 1 1 0 0 8192 2147483645 128 128 0 1 128 1 0 0 0 0 7237 0 128 1 12290 0 0 2147483645
4 USERS 2 0 1 136480 8192 2147483645 8 128 0 1 8 1 0 0 7141932 0 32861 1 8 1 4129 0 0 2147483645
5 UNDOTBS2 3 0 0 0 8192 2147483645 8 128 0 1 8 1 0 0 0 0 1920005 1 8 1 12305 0 0 2147483645
6 T1 1 0 0 0 8192 2147483645 8 128 0 1 8 1 0 0 0 0 7119982 1 8 1 4129 0 0 2147483645
7 rows selected.
第十六步
update ts$ set name="T1",online$=0,contents$=:4,undofile#=:5,undoblock#=:6, blocksize=:7,dflmaxext=:8,dflinit=:9,dflincr=:10,dflextpct=:11,dflminext=:12,
dflminlen=:13,owner#=:14,scnwrp=:15,scnbas=:16,pitrscnwrp=:17,pitrscnbas=:18,dflogging=:19,bitmapped=:20,inc#=:21,flags=:22 + :27 * (4294967296 * 4294967296),
plugged=:23,spare1=:24,spare2=:25,affstrength=:26 where ts#="T1"
此处是将online$修改为0
第二十二步
update file$ set blocks=0,ts#=DECODE(6,-1,NULL,:3),status$=2, relfile#=DECODE(5,0,NULL,:5),maxextend=:6,inc=0,crscnwrp=0,crscnbas=4294967295,
spare1=DECODE(4294967295,0,NULL,4294967295),spare2=0 where file#=5;
SQL> select * from file$;
FILE# STATUS$ BLOCKS TS# RELFILE# MAXEXTEND INC CRSCNWRP CRSCNBAS OWNERINSTANCE SPARE1 SPARE2 SPARE3 SPARE4
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------------------------------------------------------------ ---------- ---------- ---------- ----------
1 2 64000 0 1 4194302 1280 0 9 4194306 0
3 2 51200 1 3 4194302 1280 0 5480 12582914 0
5 2 6400 6 5 0 0 0 7119993 20971522 0
7 2 640 4 7 4194302 160 0 32876 29360130 0
2 1 256 4194302 1 0 1920016 8388610 0
4 2 3200 2 4 4194302 640 0 1920446 16777218 0
6 rows selected.
奇怪，没有看到insert file$而是直接update。难道哪里有触发器。后面单独测试添加数据文件
第二十三步
update file$ set blocks=6400,ts#=DECODE(6,-1,NULL,6),status$=2,
relfile#=DECODE(5,0,NULL,5),maxextend=:6,inc=0,crscnwrp=0,crscnbas=0,spare1=DECODE(20971522,0,NULL,20971522),spare2=0 where file#=5
修改了status状态
第二十四步
insert into WRI$_ALERT_THRESHOLD_LOG (sequence_id, object_type, object_name, object_id, opcode) values (599, 5, "T1", 6, 1)
这个表是由catalrt.sql在数据库创建的时候创建
第二十五步 更新控制文件
*** 2023-03-14T20:14:37.710508+08:00
WAIT #140018920245008: nam='control file sequential read' ela= 11 file#=0 block#=1 blocks=1 obj#=-1 tim=7911589848
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=1 block#=1 blocks=1 obj#=-1 tim=7911589880
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=16 blocks=1 obj#=-1 tim=7911589890
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=18 blocks=1 obj#=-1 tim=7911589899
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=24 blocks=1 obj#=-1 tim=7911589910
WAIT #140018920245008: nam='db file sequential read' ela= 2 file#=5 block#=1 blocks=1 obj#=-1 tim=7911589920
WAIT #140018920245008: nam='log file sync' ela= 190 buffer#=1765 sync scn=7120001 p3=0 obj#=-1 tim=7911590701
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=0 block#=1 blocks=1 obj#=-1 tim=7911590734
WAIT #140018920245008: nam='control file sequential read' ela= 4 file#=1 block#=1 blocks=1 obj#=-1 tim=7911590745
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=16 blocks=1 obj#=-1 tim=7911590753
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=18 blocks=1 obj#=-1 tim=7911590760
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=24 blocks=1 obj#=-1 tim=7911590770
WAIT #140018920245008: nam='db file sequential read' ela= 2 file#=5 block#=1 blocks=1 obj#=-1 tim=7911590779
WAIT #140018920245008: nam='db file single write' ela= 69 file#=5 block#=1 blocks=1 obj#=-1 tim=7911590863
WAIT #140018920245008: nam='control file parallel write' ela= 131 files=2 block#=17 requests=2 obj#=-1 tim=7911591009
WAIT #140018920245008: nam='control file parallel write' ela= 123 files=2 block#=15 requests=2 obj#=-1 tim=7911591145
WAIT #140018920245008: nam='control file parallel write' ela= 142 files=2 block#=1 requests=2 obj#=-1 tim=7911591303
WAIT #140018920245008: nam='control file sequential read' ela= 7 file#=0 block#=1 blocks=1 obj#=-1 tim=7911591360
WAIT #140018920245008: nam='control file sequential read' ela= 2 file#=0 block#=15 blocks=1 obj#=-1 tim=7911591372
WAIT #140018920245008: nam='control file sequential read' ela= 3 file#=0 block#=17 blocks=1 obj#=-1 tim=7911591381
看等待
log file sync，需要把日志写入redo。
db file single write，这个等待很少见，写的是5号数据文件的1号块，共一个block，那么数目是刷新数据文件头。
control file parallel write,跟新两路控制文件的1、15、17号块。
最后修改时间：2023-03-15 16:46:37
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
