open阶段的一致性检验（二）
SQL> select * from v$version where rownum=1;BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
SQL> !cat /etc/issue
Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Kernel \r on an \m
此篇文章是对http://blog.itpub.net/29876893/viewspace-1624484/之前写的文章补充，关数据库的OPEN过程，可以用10046事件来跟踪：
SQL> alter session set events '10046 trace name context forever, level 12';
会话已更改。
SQL> alter database open;
数据库已更改。
SQL> alter session set events '10046 trace name context off';
会话已更改。
SQL> select value from v$diag_info where name='Default Trace File';
VALUE
--------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/orcl3939/orcl3939/trace/orcl3939_ora_14781.trc
下面我们用tkprof工具格式化，被人易读取：
[oracle@localhost trace]$ tkprof orcl3939_ora_14781.trc
output = open
TKPROF: Release 11.2.0.1.0 - Development on 星期四 6月 11 18:39:52 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
下面摘自open.prf格式化文件：
TKPROF: Release 11.2.0.1.0 - Development on 星期四 6月 11 18:39:52 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Trace file: orcl3939_ora_14781.trc
Sort options: default
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
SQL ID: a01hp0psv0rrh
Plan Hash: 0
alter database open
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.02 0 0 0 0
Execute 1 0.32 0.76 20 34 64 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.32 0.79 20 34 64 0
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 2 0.00 0.00
SQL*Net message from client 2 19.69 29.81
Disk file operations I/O 15 0.00 0.00
control file sequential read 115 0.00 0.00
rdbms ipc reply 6 0.17 0.24
db file sequential read 25 0.02 0.02
control file parallel write 19 0.04 0.12
log file sync 2 0.00 0.00
instance state change 2 0.00 0.00
reliable message 1 0.00 0.00
os thread startup 1 0.02 0.02
********************************************************************************
SQL ID: 32r4f1brckzq1
Plan Hash: 0
create table bootstrap$ ( line# number not null, obj#
number not null, sql_text varchar2(4000) not null) storage (initial
50K objno 59 extents (file 1 block 520))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 6apq2rjyxmxpj
Plan Hash: 867914364
select line#, sql_text
from
bootstrap$ where obj# != :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 60 0.00 0.00 4 61 0 59
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 62 0.00 0.00 4 61 0 59
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
59 TABLE ACCESS FULL BOOTSTRAP$ (cr=61 pr=4 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
db file scattered read 1 0.00 0.00
********************************************************************************
SQL ID: 864bmh11c121a
Plan Hash: 0
CREATE ROLLBACK SEGMENT SYSTEM STORAGE ( INITIAL 112K NEXT 56K MINEXTENTS 1
MAXEXTENTS 32765 OBJNO 0 EXTENTS (FILE 1 BLOCK 128))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 7j058yj7fkg8b
Plan Hash: 0
CREATE CLUSTER C_OBJ#("OBJ#" NUMBER) PCTFREE 5 PCTUSED 40 INITRANS 2 MAXTRANS
255 STORAGE ( INITIAL 136K NEXT 200K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 2 EXTENTS (FILE 1 BLOCK 144)) SIZE 800
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 0cmnx32jn5wsp
Plan Hash: 1876228229
CREATE INDEX I_OBJ# ON CLUSTER C_OBJ# PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 3 EXTENTS (FILE 1 BLOCK 168))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_OBJ# (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL C_OBJ# (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: gsc5dr3tat6js
Plan Hash: 0
CREATE TABLE TAB$("OBJ#" NUMBER NOT NULL,"DATAOBJ#" NUMBER,"TS#" NUMBER NOT
NULL,"FILE#" NUMBER NOT NULL,"BLOCK#" NUMBER NOT NULL,"BOBJ#" NUMBER,"TAB#"
NUMBER,"COLS" NUMBER NOT NULL,"CLUCOLS" NUMBER,"PCTFREE$" NUMBER NOT NULL,
"PCTUSED$" NUMBER NOT NULL,"INITRANS" NUMBER NOT NULL,"MAXTRANS" NUMBER NOT
NULL,"FLAGS" NUMBER NOT NULL,"AUDIT$" VARCHAR2(38) NOT NULL,"ROWCNT" NUMBER,
"BLKCNT" NUMBER,"EMPCNT" NUMBER,"AVGSPC" NUMBER,"CHNCNT" NUMBER,"AVGRLN"
NUMBER,"AVGSPC_FLB" NUMBER,"FLBCNT" NUMBER,"ANALYZETIME" DATE,"SAMPLESIZE"
NUMBER,"DEGREE" NUMBER,"INSTANCES" NUMBER,"INTCOLS" NUMBER NOT NULL,
"KERNELCOLS" NUMBER NOT NULL,"PROPERTY" NUMBER NOT NULL,"TRIGFLAG" NUMBER,
"SPARE1" NUMBER,"SPARE2" NUMBER,"SPARE3" NUMBER,"SPARE4" VARCHAR2(1000),
"SPARE5" VARCHAR2(1000),"SPARE6" DATE) STORAGE ( OBJNO 4 TABNO 1) CLUSTER
C_OBJ#(OBJ#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 1vrxtnkskdyy7
Plan Hash: 0
CREATE TABLE CLU$("OBJ#" NUMBER NOT NULL,"DATAOBJ#" NUMBER,"TS#" NUMBER NOT
NULL,"FILE#" NUMBER NOT NULL,"BLOCK#" NUMBER NOT NULL,"COLS" NUMBER NOT
NULL,"PCTFREE$" NUMBER NOT NULL,"PCTUSED$" NUMBER NOT NULL,"INITRANS"
NUMBER NOT NULL,"MAXTRANS" NUMBER NOT NULL,"SIZE$" NUMBER,"HASHFUNC"
VARCHAR2(30),"HASHKEYS" NUMBER,"FUNC" NUMBER,"EXTIND" NUMBER,"FLAGS" NUMBER,
"DEGREE" NUMBER,"INSTANCES" NUMBER,"AVGCHN" NUMBER,"SPARE1" NUMBER,"SPARE2"
NUMBER,"SPARE3" NUMBER,"SPARE4" NUMBER,"SPARE5" VARCHAR2(1000),"SPARE6"
VARCHAR2(1000),"SPARE7" DATE) STORAGE ( OBJNO 5 TABNO 2) CLUSTER
C_OBJ#(OBJ#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: gtdvd3b0ugku9
Plan Hash: 0
CREATE CLUSTER C_TS#("TS#" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 2 MAXTRANS
255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 6 EXTENTS (FILE 1 BLOCK 176))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 2k93zvdmn4bqb
Plan Hash: 2460502694
CREATE INDEX I_TS# ON CLUSTER C_TS# PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 7 EXTENTS (FILE 1 BLOCK 184))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_TS# (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL C_TS# (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: ayptzt24bv5g5
Plan Hash: 0
CREATE CLUSTER C_FILE#_BLOCK#("TS#" NUMBER,"SEGFILE#" NUMBER,"SEGBLOCK#"
NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL
24K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 8
EXTENTS (FILE 1 BLOCK 192)) SIZE 225
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: arbddafw3sf4v
Plan Hash: 784518581
CREATE INDEX I_FILE#_BLOCK# ON CLUSTER C_FILE#_BLOCK# PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 9 EXTENTS (FILE 1 BLOCK 200))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_FILE#_BLOCK# (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL C_FILE#_BLOCK# (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: bwkgx73msmb86
Plan Hash: 0
CREATE CLUSTER C_USER#("USER#" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 2
MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 10 EXTENTS (FILE 1 BLOCK 208)) SIZE 372
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: d612ncf4w03r4
Plan Hash: 467322958
CREATE INDEX I_USER# ON CLUSTER C_USER# PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 11 EXTENTS (FILE 1 BLOCK 216))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_USER# (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL C_USER# (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: a06jf3z447pvw
Plan Hash: 0
CREATE TABLE FET$("TS#" NUMBER NOT NULL,"FILE#" NUMBER NOT NULL,"BLOCK#"
NUMBER NOT NULL,"LENGTH" NUMBER NOT NULL) STORAGE ( OBJNO 12 TABNO 1)
CLUSTER C_TS#(TS#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: bucm261v1abd7
Plan Hash: 0
CREATE TABLE UET$("SEGFILE#" NUMBER NOT NULL,"SEGBLOCK#" NUMBER NOT NULL,
"EXT#" NUMBER NOT NULL,"TS#" NUMBER NOT NULL,"FILE#" NUMBER NOT NULL,
"BLOCK#" NUMBER NOT NULL,"LENGTH" NUMBER NOT NULL) STORAGE ( OBJNO 13
TABNO 1) CLUSTER C_FILE#_BLOCK#(TS#,SEGFILE#,SEGBLOCK#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 2saj8tt3njnwb
Plan Hash: 0
CREATE TABLE SEG$("FILE#" NUMBER NOT NULL,"BLOCK#" NUMBER NOT NULL,"TYPE#"
NUMBER NOT NULL,"TS#" NUMBER NOT NULL,"BLOCKS" NUMBER NOT NULL,"EXTENTS"
NUMBER NOT NULL,"INIEXTS" NUMBER NOT NULL,"MINEXTS" NUMBER NOT NULL,
"MAXEXTS" NUMBER NOT NULL,"EXTSIZE" NUMBER NOT NULL,"EXTPCT" NUMBER NOT
NULL,"USER#" NUMBER NOT NULL,"LISTS" NUMBER,"GROUPS" NUMBER,"BITMAPRANGES"
NUMBER NOT NULL,"CACHEHINT" NUMBER NOT NULL,"SCANHINT" NUMBER NOT NULL,
"HWMINCR" NUMBER NOT NULL,"SPARE1" NUMBER,"SPARE2" NUMBER) STORAGE ( OBJNO
14 TABNO 2) CLUSTER C_FILE#_BLOCK#(TS#,FILE#,BLOCK#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: asgjp8bs7qgnb
Plan Hash: 0
CREATE TABLE UNDO$("US#" NUMBER NOT NULL,"NAME" VARCHAR2(30) NOT NULL,"USER#"
NUMBER NOT NULL,"FILE#" NUMBER NOT NULL,"BLOCK#" NUMBER NOT NULL,"SCNBAS"
NUMBER,"SCNWRP" NUMBER,"XACTSQN" NUMBER,"UNDOSQN" NUMBER,"INST#" NUMBER,
"STATUS$" NUMBER NOT NULL,"TS#" NUMBER,"UGRP#" NUMBER,"KEEP" NUMBER,
"OPTIMAL" NUMBER,"FLAGS" NUMBER,"SPARE1" NUMBER,"SPARE2" NUMBER,"SPARE3"
NUMBER,"SPARE4" VARCHAR2(1000),"SPARE5" VARCHAR2(1000),"SPARE6" DATE)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT
1024K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 15 EXTENTS
(FILE 1 BLOCK 224))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 8wwfvptfwkbfh
Plan Hash: 0
CREATE TABLE TS$("TS#" NUMBER NOT NULL,"NAME" VARCHAR2(30) NOT NULL,"OWNER#"
NUMBER NOT NULL,"ONLINE$" NUMBER NOT NULL,"CONTENTS$" NUMBER NOT NULL,
"UNDOFILE#" NUMBER,"UNDOBLOCK#" NUMBER,"BLOCKSIZE" NUMBER NOT NULL,"INC#"
NUMBER NOT NULL,"SCNWRP" NUMBER,"SCNBAS" NUMBER,"DFLMINEXT" NUMBER NOT NULL,
"DFLMAXEXT" NUMBER NOT NULL,"DFLINIT" NUMBER NOT NULL,"DFLINCR" NUMBER NOT
NULL,"DFLMINLEN" NUMBER NOT NULL,"DFLEXTPCT" NUMBER NOT NULL,"DFLOGGING"
NUMBER NOT NULL,"AFFSTRENGTH" NUMBER NOT NULL,"BITMAPPED" NUMBER NOT NULL,
"PLUGGED" NUMBER NOT NULL,"DIRECTALLOWED" NUMBER NOT NULL,"FLAGS" NUMBER
NOT NULL,"PITRSCNWRP" NUMBER,"PITRSCNBAS" NUMBER,"OWNERINSTANCE"
VARCHAR2(30),"BACKUPOWNER" VARCHAR2(30),"GROUPNAME" VARCHAR2(30),"SPARE1"
NUMBER,"SPARE2" NUMBER,"SPARE3" VARCHAR2(1000),"SPARE4" DATE) STORAGE (
OBJNO 16 TABNO 2) CLUSTER C_TS#(TS#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: brwww2atavyra
Plan Hash: 0
CREATE TABLE FILE$("FILE#" NUMBER NOT NULL,"STATUS$" NUMBER NOT NULL,"BLOCKS"
NUMBER NOT NULL,"TS#" NUMBER,"RELFILE#" NUMBER,"MAXEXTEND" NUMBER,"INC"
NUMBER,"CRSCNWRP" NUMBER,"CRSCNBAS" NUMBER,"OWNERINSTANCE" VARCHAR2(30),
"SPARE1" NUMBER,"SPARE2" NUMBER,"SPARE3" VARCHAR2(1000),"SPARE4" DATE)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT
1024K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 17 EXTENTS
(FILE 1 BLOCK 232))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: aq19zrtmdanug
Plan Hash: 0
CREATE TABLE OBJ$("OBJ#" NUMBER NOT NULL,"DATAOBJ#" NUMBER,"OWNER#" NUMBER
NOT NULL,"NAME" VARCHAR2(30) NOT NULL,"NAMESPACE" NUMBER NOT NULL,"SUBNAME"
VARCHAR2(30),"TYPE#" NUMBER NOT NULL,"CTIME" DATE NOT NULL,"MTIME" DATE NOT
NULL,"STIME" DATE NOT NULL,"STATUS" NUMBER NOT NULL,"REMOTEOWNER"
VARCHAR2(30),"LINKNAME" VARCHAR2(128),"FLAGS" NUMBER,"OID$" RAW(16),
"SPARE1" NUMBER,"SPARE2" NUMBER,"SPARE3" NUMBER,"SPARE4" VARCHAR2(1000),
"SPARE5" VARCHAR2(1000),"SPARE6" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRANS 255 STORAGE ( INITIAL 16K NEXT 104K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 18 EXTENTS (FILE 1 BLOCK 240))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: gzssu8qckx8bc
Plan Hash: 0
CREATE TABLE IND$("OBJ#" NUMBER NOT NULL,"DATAOBJ#" NUMBER,"TS#" NUMBER NOT
NULL,"FILE#" NUMBER NOT NULL,"BLOCK#" NUMBER NOT NULL,"BO#" NUMBER NOT NULL,
"INDMETHOD#" NUMBER NOT NULL,"COLS" NUMBER NOT NULL,"PCTFREE$" NUMBER NOT
NULL,"INITRANS" NUMBER NOT NULL,"MAXTRANS" NUMBER NOT NULL,"PCTTHRES$"
NUMBER,"TYPE#" NUMBER NOT NULL,"FLAGS" NUMBER NOT NULL,"PROPERTY" NUMBER
NOT NULL,"BLEVEL" NUMBER,"LEAFCNT" NUMBER,"DISTKEY" NUMBER,"LBLKKEY" NUMBER,
"DBLKKEY" NUMBER,"CLUFAC" NUMBER,"ANALYZETIME" DATE,"SAMPLESIZE" NUMBER,
"ROWCNT" NUMBER,"INTCOLS" NUMBER NOT NULL,"DEGREE" NUMBER,"INSTANCES"
NUMBER,"TRUNCCNT" NUMBER,"SPARE1" NUMBER,"SPARE2" NUMBER,"SPARE3" NUMBER,
"SPARE4" VARCHAR2(1000),"SPARE5" VARCHAR2(1000),"SPARE6" DATE) STORAGE (
OBJNO 19 TABNO 3) CLUSTER C_OBJ#(BO#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 1ncu5rdtv0j40
Plan Hash: 0
CREATE TABLE ICOL$("OBJ#" NUMBER NOT NULL,"BO#" NUMBER NOT NULL,"COL#" NUMBER
NOT NULL,"POS#" NUMBER NOT NULL,"SEGCOL#" NUMBER NOT NULL,"SEGCOLLENGTH"
NUMBER NOT NULL,"OFFSET" NUMBER NOT NULL,"INTCOL#" NUMBER NOT NULL,"SPARE1"
NUMBER,"SPARE2" NUMBER,"SPARE3" NUMBER,"SPARE4" VARCHAR2(1000),"SPARE5"
VARCHAR2(1000),"SPARE6" DATE) STORAGE ( OBJNO 20 TABNO 4) CLUSTER
C_OBJ#(BO#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 8tq27mzf4ja8u
Plan Hash: 0
CREATE TABLE COL$("OBJ#" NUMBER NOT NULL,"COL#" NUMBER NOT NULL,"SEGCOL#"
NUMBER NOT NULL,"SEGCOLLENGTH" NUMBER NOT NULL,"OFFSET" NUMBER NOT NULL,
"NAME" VARCHAR2(30) NOT NULL,"TYPE#" NUMBER NOT NULL,"LENGTH" NUMBER NOT
NULL,"FIXEDSTORAGE" NUMBER NOT NULL,"PRECISION#" NUMBER,"SCALE" NUMBER,
"NULL$" NUMBER NOT NULL,"DEFLENGTH" NUMBER,"DEFAULT$" LONG,"INTCOL#" NUMBER
NOT NULL,"PROPERTY" NUMBER NOT NULL,"CHARSETID" NUMBER,"CHARSETFORM" NUMBER,
"SPARE1" NUMBER,"SPARE2" NUMBER,"SPARE3" NUMBER,"SPARE4" VARCHAR2(1000),
"SPARE5" VARCHAR2(1000),"SPARE6" DATE) STORAGE ( OBJNO 21 TABNO 5) CLUSTER
C_OBJ#(OBJ#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: b7cj348smsncv
Plan Hash: 0
CREATE TABLE USER$("USER#" NUMBER NOT NULL,"NAME" VARCHAR2(30) NOT NULL,
"TYPE#" NUMBER NOT NULL,"PASSWORD" VARCHAR2(30),"DATATS#" NUMBER NOT NULL,
"TEMPTS#" NUMBER NOT NULL,"CTIME" DATE NOT NULL,"PTIME" DATE,"EXPTIME" DATE,
"LTIME" DATE,"RESOURCE$" NUMBER NOT NULL,"AUDIT$" VARCHAR2(38),"DEFROLE"
NUMBER NOT NULL,"DEFGRP#" NUMBER,"DEFGRP_SEQ#" NUMBER,"ASTATUS" NUMBER NOT
NULL,"LCOUNT" NUMBER NOT NULL,"DEFSCHCLASS" VARCHAR2(30),"EXT_USERNAME"
VARCHAR2(4000),"SPARE1" NUMBER,"SPARE2" NUMBER,"SPARE3" NUMBER,"SPARE4"
VARCHAR2(1000),"SPARE5" VARCHAR2(1000),"SPARE6" DATE) STORAGE ( OBJNO 22
TABNO 1) CLUSTER C_USER#(USER#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: abz4w3ug15h6y
Plan Hash: 0
CREATE TABLE PROXY_DATA$("CLIENT#" NUMBER NOT NULL,"PROXY#" NUMBER NOT NULL,
"CREDENTIAL_TYPE#" NUMBER NOT NULL,"CREDENTIAL_VERSION#" NUMBER NOT NULL,
"CREDENTIAL_MINOR#" NUMBER NOT NULL,"FLAGS" NUMBER NOT NULL) PCTFREE 10
PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K
MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 23 EXTENTS (FILE 1
BLOCK 248))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 01srqknh66jbn
Plan Hash: 2421997849
CREATE UNIQUE INDEX I_PROXY_DATA$ ON PROXY_DATA$(CLIENT#,PROXY#) PCTFREE 10
INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1
MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 24 EXTENTS (FILE 1 BLOCK 256))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_PROXY_DATA$ (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL PROXY_DATA$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: gk4v9sjd5pusr
Plan Hash: 0
CREATE TABLE PROXY_ROLE_DATA$("CLIENT#" NUMBER NOT NULL,"PROXY#" NUMBER NOT
NULL,"ROLE#" NUMBER NOT NULL) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 25 EXTENTS (FILE 1 BLOCK 264))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 241a8sxpw7xg2
Plan Hash: 2742304880
CREATE INDEX I_PROXY_ROLE_DATA$_1 ON PROXY_ROLE_DATA$(CLIENT#,PROXY#) PCTFREE
10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1
MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 26 EXTENTS (FILE 1 BLOCK 272))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_PROXY_ROLE_DATA$_1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL PROXY_ROLE_DATA$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 4aumj460nfvbk
Plan Hash: 3155272959
CREATE UNIQUE INDEX I_PROXY_ROLE_DATA$_2 ON PROXY_ROLE_DATA$(CLIENT#,PROXY#,
ROLE#) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K
MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 27 EXTENTS (FILE 1
BLOCK 280))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_PROXY_ROLE_DATA$_2 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL PROXY_ROLE_DATA$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 9q1b421017a8x
Plan Hash: 0
CREATE TABLE CON$("OWNER#" NUMBER NOT NULL,"NAME" VARCHAR2(30) NOT NULL,
"CON#" NUMBER NOT NULL,"SPARE1" NUMBER,"SPARE2" NUMBER,"SPARE3" NUMBER,
"SPARE4" VARCHAR2(1000),"SPARE5" VARCHAR2(1000),"SPARE6" DATE) PCTFREE 10
PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K
MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 28 EXTENTS (FILE 1
BLOCK 288))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: ca3tvkavsqc2w
Plan Hash: 0
CREATE CLUSTER C_COBJ#("OBJ#" NUMBER) PCTFREE 0 PCTUSED 50 INITRANS 2
MAXTRANS 255 STORAGE ( INITIAL 56K NEXT 1024K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 29 EXTENTS (FILE 1 BLOCK 296)) SIZE 300
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 3xxzvxdvxw0w4
Plan Hash: 1506643731
CREATE INDEX I_COBJ# ON CLUSTER C_COBJ# PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 30 EXTENTS (FILE 1 BLOCK 304))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_COBJ# (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL C_COBJ# (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 4smn50z75bn8p
Plan Hash: 0
CREATE TABLE CDEF$("CON#" NUMBER NOT NULL,"OBJ#" NUMBER NOT NULL,"COLS"
NUMBER,"TYPE#" NUMBER NOT NULL,"ROBJ#" NUMBER,"RCON#" NUMBER,"RRULES"
VARCHAR2(3),"MATCH#" NUMBER,"REFACT" NUMBER,"ENABLED" NUMBER,"CONDLENGTH"
NUMBER,"CONDITION" LONG,"INTCOLS" NUMBER,"MTIME" DATE,"DEFER" NUMBER,
"SPARE1" NUMBER,"SPARE2" NUMBER,"SPARE3" NUMBER,"SPARE4" VARCHAR2(1000),
"SPARE5" VARCHAR2(1000),"SPARE6" DATE) STORAGE ( OBJNO 31 TABNO 1) CLUSTER
C_COBJ#(OBJ#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: dk15zc78v9bmm
Plan Hash: 0
CREATE TABLE CCOL$("CON#" NUMBER NOT NULL,"OBJ#" NUMBER NOT NULL,"COL#"
NUMBER NOT NULL,"POS#" NUMBER,"INTCOL#" NUMBER NOT NULL,"SPARE1" NUMBER,
"SPARE2" NUMBER,"SPARE3" NUMBER,"SPARE4" VARCHAR2(1000),"SPARE5"
VARCHAR2(1000),"SPARE6" DATE) STORAGE ( OBJNO 32 TABNO 2) CLUSTER
C_COBJ#(OBJ#)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 8tdy251ry2npr
Plan Hash: 1311951907
CREATE INDEX I_TAB1 ON TAB$(BOBJ#) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE
( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0
OBJNO 33 EXTENTS (FILE 1 BLOCK 312))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_TAB1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL TAB$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: fqkyj700r5a76
Plan Hash: 241391319
CREATE UNIQUE INDEX I_UNDO1 ON UNDO$(US#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 34 EXTENTS (FILE 1 BLOCK 320))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_UNDO1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL UNDO$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 6fnzq8u013fjt
Plan Hash: 4258903948
CREATE INDEX I_UNDO2 ON UNDO$(NAME) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 35 EXTENTS (FILE 1 BLOCK 328))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_UNDO2 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL UNDO$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 18806807b36ng
Plan Hash: 2550726283
CREATE UNIQUE INDEX I_OBJ1 ON OBJ$(OBJ#,OWNER#,TYPE#) PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 36 EXTENTS (FILE 1 BLOCK 336))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 8urmvm9u914ww
Plan Hash: 2394141674
CREATE UNIQUE INDEX I_OBJ2 ON OBJ$(OWNER#,NAME,NAMESPACE,REMOTEOWNER,LINKNAME,
SUBNAME,TYPE#,SPARE3,OBJ#) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (
INITIAL 16K NEXT 104K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0
OBJNO 37 EXTENTS (FILE 1 BLOCK 344))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_OBJ2 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 1y72jj9kg8837
Plan Hash: 3559676290
CREATE INDEX I_OBJ3 ON OBJ$(OID$) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE
( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0
OBJNO 38 EXTENTS (FILE 1 BLOCK 352))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_OBJ3 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 86y7jw3uf3hyf
Plan Hash: 3252617493
CREATE INDEX I_OBJ4 ON OBJ$(DATAOBJ#,TYPE#,OWNER#) PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 39 EXTENTS (FILE 1 BLOCK 360))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_OBJ4 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: bmtc4zunkrhcc
Plan Hash: 440321312
CREATE UNIQUE INDEX I_OBJ5 ON OBJ$(SPARE3,NAME,NAMESPACE,TYPE#,OWNER#,
REMOTEOWNER,LINKNAME,SUBNAME,OBJ#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 40 EXTENTS (FILE 1 BLOCK 368))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_OBJ5 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 316bkh08ut0c8
Plan Hash: 1674788349
CREATE UNIQUE INDEX I_IND1 ON IND$(OBJ#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 41 EXTENTS (FILE 1 BLOCK 376))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_IND1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL IND$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 8f8nq4tmvrtac
Plan Hash: 4278495183
CREATE INDEX I_ICOL1 ON ICOL$(OBJ#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 42 EXTENTS (FILE 1 BLOCK 384))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_ICOL1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL ICOL$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: fj16zvcuykr1z
Plan Hash: 1670493793
CREATE UNIQUE INDEX I_FILE1 ON FILE$(FILE#) PCTFREE 10 INITRANS 2 MAXTRANS
255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 43 EXTENTS (FILE 1 BLOCK 392))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_FILE1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL FILE$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 4ph8prwk20gmy
Plan Hash: 4134020651
CREATE UNIQUE INDEX I_FILE2 ON FILE$(TS#,RELFILE#) PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 44 EXTENTS (FILE 1 BLOCK 400))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_FILE2 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL FILE$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 5k99xvnhga9g3
Plan Hash: 4116875600
CREATE UNIQUE INDEX I_TS1 ON TS$(NAME) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 45 EXTENTS (FILE 1 BLOCK 408))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_TS1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL TS$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 1y18bw8njtmb5
Plan Hash: 1629724816
CREATE UNIQUE INDEX I_USER1 ON USER$(NAME) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 46 EXTENTS (FILE 1 BLOCK 416))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_USER1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 2abyfa63xhwjc
Plan Hash: 3810221949
CREATE UNIQUE INDEX I_USER2 ON USER$(USER#,TYPE#,SPARE1,SPARE2) PCTFREE 10
INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1
MAXEXTENTS 2147483645 PCTINCREASE 0 OBJNO 47 EXTENTS (FILE 1 BLOCK 424))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_USER2 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 01jyua0awvwb9
Plan Hash: 237031462
CREATE UNIQUE INDEX I_COL1 ON COL$(OBJ#,NAME) PCTFREE 10 INITRANS 2 MAXTRANS
255 STORAGE ( INITIAL 32K NEXT 104K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 48 EXTENTS (FILE 1 BLOCK 432))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_COL1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL COL$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: ak7z567h3x7y0
Plan Hash: 4024264167
CREATE INDEX I_COL2 ON COL$(OBJ#,COL#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 32K NEXT 104K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 49 EXTENTS (FILE 1 BLOCK 440))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_COL2 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL COL$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 2wbjjcu6pdpxr
Plan Hash: 2334685287
CREATE UNIQUE INDEX I_COL3 ON COL$(OBJ#,INTCOL#) PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE ( INITIAL 32K NEXT 104K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 50 EXTENTS (FILE 1 BLOCK 448))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_COL3 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL COL$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 14zdn2tchuany
Plan Hash: 2990811106
CREATE UNIQUE INDEX I_CON1 ON CON$(OWNER#,NAME) PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 51 EXTENTS (FILE 1 BLOCK 456))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_CON1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL CON$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 74t75zp7r60qa
Plan Hash: 1332379569
CREATE UNIQUE INDEX I_CON2 ON CON$(CON#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 52 EXTENTS (FILE 1 BLOCK 464))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_CON2 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL CON$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 8usvxbumstp2f
Plan Hash: 961929801
CREATE UNIQUE INDEX I_CDEF1 ON CDEF$(CON#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 53 EXTENTS (FILE 1 BLOCK 472))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_CDEF1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL CDEF$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: f6gmshxhs0u67
Plan Hash: 4079943056
CREATE INDEX I_CDEF2 ON CDEF$(OBJ#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 54 EXTENTS (FILE 1 BLOCK 480))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_CDEF2 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL CDEF$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: fda96v5a41791
Plan Hash: 3194737163
CREATE INDEX I_CDEF3 ON CDEF$(ROBJ#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 55 EXTENTS (FILE 1 BLOCK 488))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_CDEF3 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL CDEF$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 5uaq1vphxtn0m
Plan Hash: 1077327578
CREATE INDEX I_CDEF4 ON CDEF$(ENABLED) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 56 EXTENTS (FILE 1 BLOCK 496))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_CDEF4 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL CDEF$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: fnyrjkq3y5f7w
Plan Hash: 1435095171
CREATE INDEX I_CCOL1 ON CCOL$(CON#,COL#) PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 OBJNO 57 EXTENTS (FILE 1 BLOCK 504))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD NON UNIQUE I_CCOL1 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL CCOL$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 9a9j7rqjb0ymh
Plan Hash: 1536140006
CREATE UNIQUE INDEX I_CCOL2 ON CCOL$(CON#,INTCOL#) PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1024K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 OBJNO 58 EXTENTS (FILE 1 BLOCK 512))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 INDEX BUILD UNIQUE I_CCOL2 (cr=0 pr=0 pw=0 time=0 us)(object id 0)
0 SORT CREATE INDEX (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL CCOL$ (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: bqbdby3c400p7
Plan Hash: 2970138452
select rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,nvl(degree,1), nvl(instances,
1)
from
tab$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 19 0.00 0.00 0 0 0 0
Fetch 19 0.00 0.00 5 58 0 19
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 39 0.00 0.00 5 58 0 19
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=3 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=2 pw=0 time=0 us)(object id 3)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 5 0.00 0.00
********************************************************************************
SQL ID: f8mu51fbs6x5v
Plan Hash: 3312860272
select blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, nvl(degree,
1), nvl(instances,1)
from
ind$ where bo# = :1 and obj# = :2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 34 0.00 0.00 0 0 0 0
Fetch 34 0.00 0.00 4 102 0 34
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 69 0.00 0.00 4 102 0 34
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID IND$ (cr=3 pr=2 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_IND1 (cr=2 pr=2 pw=0 time=0 us)(object id 41)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 4 0.00 0.00
********************************************************************************
SQL ID: 32d4jrb4pd4sj
Plan Hash: 3410197392
select charsetid, charsetform
from
col$ where obj# = :1 and col# = :2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 45 0.00 0.00 0 0 0 0
Fetch 45 0.00 0.00 0 141 0 45
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 91 0.00 0.00 0 141 0 45
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
********************************************************************************
SQL ID: 4krwuz0ctqxdt
Plan Hash: 1218588913
select ctime, mtime, stime
from
obj$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 58 0.00 0.00 0 0 0 0
Execute 58 0.00 0.00 0 0 0 0
Fetch 58 0.00 0.00 3 174 0 58
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 174 0.01 0.01 3 174 0 58
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=3 pw=0 time=0 us)
1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=2 pw=0 time=0 us)(object id 36)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 3 0.00 0.00
********************************************************************************
SQL ID: 3nkd3g3ju5ph1
Plan Hash: 2853959010
select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1,
spare2
from
obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null
and linkname is null and subname is null
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 329 0.07 0.08 0 0 0 0
Fetch 329 0.04 0.82 90 1316 0 329
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 659 0.11 0.90 90 1316 0 329
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=3 pw=0 time=0 us)
1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=3 pw=0 time=0 us)(object id 37)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 101 0.08 0.46
********************************************************************************
SQL ID: 2ajy4zgqrakrx
Plan Hash: 2970138452
select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0),
audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,
avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1),
nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0)
,nvl(spare2,0),spare4,spare6
from
tab$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 12 0.00 0.00 0 0 0 0
Fetch 12 0.00 0.00 6 36 0 12
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 25 0.00 0.00 6 36 0 12
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=1 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 6 0.00 0.00
********************************************************************************
SQL ID: bkdusjx00dsmc
Plan Hash: 452902013
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property,
i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey, i.lblkkey,
i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,
nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),
i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),
nvl(i.spare1,i.intcols),i.spare4,spare2,spare6, decode(i.pctthres$,null,
null, mod(trunc(i.pctthres$/256),256))
from
ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1)))
deferrable#, min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=
:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=
:1 order by i.obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 13 0.00 0.00 0 0 0 0
Fetch 28 0.00 0.01 8 74 0 15
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 42 0.00 0.02 8 74 0 15
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 MERGE JOIN OUTER (cr=3 pr=0 pw=0 time=0 us)
0 SORT JOIN (cr=3 pr=0 pw=0 time=0 us)
0 TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
0 SORT JOIN (cr=0 pr=0 pw=0 time=0 us)
0 VIEW (cr=0 pr=0 pw=0 time=0 us)
0 SORT GROUP BY (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS CLUSTER CDEF$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_COBJ# (cr=0 pr=0 pw=0 time=0 us)(object id 30)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 8 0.00 0.01
********************************************************************************
SQL ID: 83taa7kaw59c1
Plan Hash: 3765558045
select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,
nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,
scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,
rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,
nvl(spare3,0)
from
col$ where obj#=:1 order by intcol#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 133 0.02 0.02 0 0 0 0
Fetch 1787 0.03 0.02 10 427 0 1654
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1921 0.05 0.05 10 427 0 1654
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
3 SORT ORDER BY (cr=3 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
3 TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=4 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 10 0.00 0.00
********************************************************************************
SQL ID: g64r07v2jn8nq
Plan Hash: 415205717
SELECT NULL
FROM
PROPS$ WHERE NAME='BOOTSTRAP_UPGRADE_ERROR'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL PROPS$ (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 5n1fs4m2n2y0r
Plan Hash: 299250003
select pos#,intcol#,col#,spare1,bo#,spare2,spare3
from
icol$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 187 0.02 0.02 0 0 0 0
Fetch 487 0.01 0.05 12 974 0 300
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 675 0.04 0.08 12 974 0 300
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
2 TABLE ACCESS BY INDEX ROWID ICOL$ (cr=6 pr=2 pw=0 time=0 us)
2 INDEX RANGE SCAN I_ICOL1 (cr=4 pr=2 pw=0 time=6 us)(object id 42)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 12 0.03 0.04
********************************************************************************
SQL ID: 87gaftwrm2h68
Plan Hash: 1218588913
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname
from
obj$ o where o.obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 145 0.03 0.02 0 0 0 0
Fetch 145 0.00 0.05 13 435 0 145
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 291 0.04 0.07 13 435 0 145
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=1 pw=0 time=0 us)
1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=1 pw=0 time=0 us)(object id 36)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 13 0.04 0.04
********************************************************************************
SQL ID: 9cxfrybccgqbc
Plan Hash: 2726665657
SELECT NULL
FROM
REGISTRY$ WHERE CID='CATPROC' AND SUBSTR(VERSION,1,8) = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.01 2 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 2 3 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL REGISTRY$ (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.01
********************************************************************************
SQL ID: 3ktacv9r56b51
Plan Hash: 4184428695
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#,
nvl(property,0),subname,type#,d_attrs
from
dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 43 0.00 0.00 0 0 0 0
Execute 43 0.01 0.00 0 0 0 0
Fetch 199 0.02 0.20 77 479 0 156
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 285 0.04 0.21 77 479 0 156
Misses in library cache during parse: 2
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY (cr=3 pr=3 pw=0 time=0 us cost=0 size=0 card=0)
0 NESTED LOOPS OUTER (cr=3 pr=3 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=3 pr=3 pw=0 time=0 us)
0 INDEX RANGE SCAN I_DEPENDENCY1 (cr=3 pr=3 pw=0 time=0 us)(object id 106)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 77 0.05 0.18
********************************************************************************
SQL ID: 8swypbbr0m372
Plan Hash: 893970548
select order#,columns,types
from
access$ where d_obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 43 0.00 0.00 0 0 0 0
Execute 43 0.00 0.00 0 0 0 0
Fetch 175 0.01 0.03 33 350 0 132
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 261 0.02 0.04 33 350 0 132
Misses in library cache during parse: 2
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID ACCESS$ (cr=2 pr=2 pw=0 time=0 us)
0 INDEX RANGE SCAN I_ACCESS1 (cr=2 pr=2 pw=0 time=0 us)(object id 108)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 33 0.01 0.03
********************************************************************************
SQL ID: 05sghzkq6r6yv
Plan Hash: 4141019660
select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,
maxtrans,hashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),
nvl(flags,0),nvl(spare1,0)
from
clu$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER CLU$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
********************************************************************************
SQL ID: gx4mv66pvj3xz
Plan Hash: 2570921597
select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),
rowid,cols,nvl(defer,0),mtime,nvl(spare1,0),spare2,spare3
from
cdef$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 30 0.00 0.00 0 0 0 0
Fetch 117 0.00 0.00 2 167 0 87
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 148 0.01 0.01 2 167 0 87
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS CLUSTER CDEF$ (cr=2 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 30)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 7bd391hat42zk
Plan Hash: 906473769
select /*+ rule */ name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,
scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1
from
undo$ where us#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 31 0.00 0.00 0 0 0 0
Execute 31 0.00 0.00 0 0 0 0
Fetch 31 0.00 0.00 2 61 0 30
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 93 0.00 0.00 2 61 0 30
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: RULE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID UNDO$ (cr=2 pr=2 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_UNDO1 (cr=1 pr=1 pw=0 time=0 us)(object id 34)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 7jpt4cpfvcy1k
Plan Hash: 284504113
select ts#,online$
from
ts$ where name=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 3 6 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.00 0.00 3 6 0 3
Misses in library cache during parse: 2
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID TS$ (cr=2 pr=2 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_TS1 (cr=1 pr=1 pw=0 time=0 us)(object id 45)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 3 0.00 0.00
********************************************************************************
SQL ID: 57guu81bd4bc5
Plan Hash: 2397009925
select name,online$,contents$,undofile#,undoblock#,blocksize,dflmaxext,
dflinit,dflincr,dflextpct,dflminext, dflminlen, owner#,scnwrp,scnbas,
NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, flags,
plugged, NVL(spare1,0), NVL(spare2,0), affstrength
from
ts$ where ts#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 6 0.00 0.00 5 12 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 18 0.00 0.00 5 12 0 6
Misses in library cache during parse: 2
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER TS$ (cr=2 pr=1 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_TS# (cr=1 pr=1 pw=0 time=0 us)(object id 7)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 5 0.00 0.00
********************************************************************************
SQL ID: d4m7ss0gdqhw9
Plan Hash: 3480137939
select max(maxconcurrency)
from
sys.wrh$_undostat where instance_number = :1 and dbid = :2 and snap_id in
(select snap_id from dba_hist_snapshot where end_interval_time >
(select max(end_interval_time)-7 from dba_hist_snapshot))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.01 0 0 0 0
Fetch 1 0.00 0.00 20 30 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.01 20 30 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=30 pr=20 pw=0 time=0 us)
184 FILTER (cr=30 pr=20 pw=0 time=1098 us)
276 MERGE JOIN (cr=23 pr=20 pw=0 time=4216 us)
277 SORT JOIN (cr=16 pr=14 pw=0 time=460 us)
277 TABLE ACCESS FULL WRH$_UNDOSTAT (cr=16 pr=14 pw=0 time=368 us)
276 SORT JOIN (cr=7 pr=6 pw=0 time=0 us)
58 TABLE ACCESS FULL WRM$_SNAPSHOT (cr=7 pr=6 pw=0 time=114 us)
1 SORT AGGREGATE (cr=7 pr=0 pw=0 time=0 us)
58 TABLE ACCESS FULL WRM$_SNAPSHOT (cr=7 pr=0 pw=0 time=57 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
db file scattered read 3 0.00 0.00
********************************************************************************
SQL ID: 1gu8t96d0bdmu
Plan Hash: 3526770254
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,
nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,
t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,
t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1),
nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),
nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,
ts.logicalread
from
tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 112 0.02 0.02 0 0 0 0
Fetch 112 0.02 0.02 62 461 0 112
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 225 0.05 0.04 62 461 0 112
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 NESTED LOOPS OUTER (cr=4 pr=3 pw=0 time=0 us)
1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=2 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=1 pw=0 time=0 us)(object id 3)
0 TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=1 pr=1 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=1 pr=1 pw=0 time=0 us)(object id 430)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 62 0.00 0.00
********************************************************************************
SQL ID: 7ng34ruy5awxq
Plan Hash: 306576078
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,
i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,
i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,
nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),
i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),
nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,
null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,
ist.logicalread
from
ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols,
min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4)))
valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where
i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 112 0.02 0.03 0 0 0 0
Fetch 284 0.02 0.08 27 682 0 172
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 398 0.05 0.11 27 682 0 172
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 MERGE JOIN OUTER (cr=7 pr=3 pw=0 time=0 us)
1 SORT JOIN (cr=4 pr=1 pw=0 time=0 us)
1 NESTED LOOPS OUTER (cr=4 pr=1 pw=0 time=0 us)
1 TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
0 TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=1 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=1 pw=0 time=0 us)(object id 432)
1 SORT JOIN (cr=3 pr=2 pw=0 time=0 us)
1 VIEW (cr=3 pr=2 pw=0 time=0 us)
1 SORT GROUP BY (cr=3 pr=2 pw=0 time=0 us)
1 TABLE ACCESS CLUSTER CDEF$ (cr=3 pr=2 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=1 pw=0 time=0 us)(object id 30)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 27 0.02 0.06
********************************************************************************
SQL ID: 9tgj4g8y4rwy8
Plan Hash: 3755742892
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,
NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),
NVL(scanhint,0),NVL(bitmapranges,0)
from
seg$ where ts#=:1 and file#=:2 and block#=:3
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 95 0.00 0.00 0 0 0 0
Execute 95 0.01 0.02 0 0 0 0
Fetch 95 0.00 0.05 18 285 0 95
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 285 0.02 0.08 18 285 0 95
Misses in library cache during parse: 2
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER SEG$ (cr=3 pr=3 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=2 pw=0 time=0 us)(object id 9)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 18 0.02 0.05
********************************************************************************
SQL ID: g3wrkmxkxzhf2
Plan Hash: 749386351
select cols,audit$,textlength,intcols,property,flags,rowid
from
view$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 8 0.00 0.00 0 0 0 0
Fetch 8 0.00 0.00 12 24 0 8
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 17 0.00 0.00 12 24 0 8
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID VIEW$ (cr=3 pr=3 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_VIEW1 (cr=2 pr=2 pw=0 time=0 us)(object id 75)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 12 0.00 0.00
********************************************************************************
SQL ID: grwydz59pu6mc
Plan Hash: 3684871272
select text
from
view$ where rowid=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 12 0.00 0.00 0 0 0 0
Execute 12 0.00 0.00 0 0 0 0
Fetch 12 0.00 0.00 0 24 0 12
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 36 0.00 0.00 0 24 0 12
Misses in library cache during parse: 2
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 3w4qs0tbpmxr6
Plan Hash: 1224215794
select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3
from
cdef$ where robj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 29 0.00 0.00 0 0 0 0
Fetch 29 0.00 0.00 3 58 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 59 0.01 0.00 3 58 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=2 pr=2 pw=0 time=0 us)
0 INDEX RANGE SCAN I_CDEF3 (cr=2 pr=2 pw=0 time=0 us)(object id 55)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 3 0.00 0.00
********************************************************************************
SQL ID: 53saa2zkr6wc3
Plan Hash: 1514015273
select intcol#,nvl(pos#,0),col#,nvl(spare1,0)
from
ccol$ where con#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 87 0.01 0.01 0 0 0 0
Fetch 179 0.00 0.00 5 358 0 92
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 267 0.01 0.01 5 358 0 92
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID CCOL$ (cr=4 pr=2 pw=0 time=0 us)
1 INDEX RANGE SCAN I_CCOL2 (cr=3 pr=2 pw=0 time=0 us)(object id 58)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 5 0.00 0.00
********************************************************************************
SQL ID: 6aq34nj2zb2n7
Plan Hash: 2874733959
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2))
from
objauth$ where obj#=:1 and col# is not null group by privilege#, col#,
grantee# order by col#, grantee#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 57 0.01 0.01 0 0 0 0
Fetch 57 0.00 0.00 6 114 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 115 0.01 0.02 6 114 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT GROUP BY (cr=2 pr=2 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=2 pw=0 time=0 us)
0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=2 pw=0 time=0 us)(object id 62)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 6 0.00 0.00
********************************************************************************
SQL ID: 2q93zsrvbdw48
Plan Hash: 2874733959
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))
from
objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by
grantee#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 57 0.01 0.01 0 0 0 0
Fetch 84 0.00 0.01 4 141 0 27
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 142 0.01 0.02 4 141 0 27
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT GROUP BY (cr=3 pr=1 pw=0 time=0 us)
1 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=3 pr=1 pw=0 time=0 us)
1 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=0 us)(object id 62)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 4 0.00 0.01
********************************************************************************
SQL ID: 5ansr7r9htpq3
Plan Hash: 3078630091
update undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,
xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12,spare1=:13
where
us#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 20 0.00 0.00 0 0 0 0
Execute 20 0.01 0.01 1 20 41 20
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 40 0.01 0.02 1 20 41 20
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 UPDATE UNDO$ (cr=1 pr=1 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_UNDO1 (cr=1 pr=0 pw=0 time=0 us)(object id 34)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: bsa0wjtftg3uw
Plan Hash: 2020579421
select file#
from
file$ where ts#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 6 0.00 0.00 2 9 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 12 0.00 0.00 2 9 0 3
Misses in library cache during parse: 2
Misses in library cache during execute: 2
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID FILE$ (cr=3 pr=2 pw=0 time=0 us)
1 INDEX RANGE SCAN I_FILE2 (cr=2 pr=1 pw=0 time=0 us)(object id 44)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 9p6bq1v54k13j
Plan Hash: 415205717
select value$
from
sys.props$ where name = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 8 0.00 0.00 0 0 0 0
Execute 33 0.00 0.00 0 0 0 0
Fetch 33 0.00 0.00 0 99 0 24
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 74 0.01 0.01 0 99 0 24
Misses in library cache during parse: 4
Misses in library cache during execute: 6
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL PROPS$ (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 0sffr2n5z3px5
Plan Hash: 1322523323
select count(*)
from
fixed_obj$
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.11 4 5 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.11 4 5 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=5 pr=4 pw=0 time=0 us)
909 TABLE ACCESS FULL FIXED_OBJ$ (cr=5 pr=4 pw=0 time=681 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.11 0.11
db file scattered read 1 0.00 0.00
********************************************************************************
SQL ID: 71ucy323126pb
Plan Hash: 4101856904
select timestamp, obj#
from
fixed_obj$ order by obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 910 0.00 0.00 4 1819 0 909
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 912 0.00 0.00 4 1819 0 909
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
909 TABLE ACCESS BY INDEX ROWID FIXED_OBJ$ (cr=1819 pr=4 pw=0 time=5318 us)
909 INDEX FULL SCAN I_FIXED_OBJ$_OBJ# (cr=910 pr=4 pw=0 time=2724 us)(object id 102)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 4 0.00 0.00
********************************************************************************
SQL ID: gaxdqmv51zwgx
Plan Hash: 3901020767
select obj#
from
fixed_obj$
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 910 0.00 0.00 0 911 0 909
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 912 0.00 0.00 0 911 0 909
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
909 TABLE ACCESS FULL FIXED_OBJ$ (cr=911 pr=0 pw=0 time=2724 us)
********************************************************************************
SQL ID: 6d8vr86tu1ku4
Plan Hash: 1676180847
select TOTAL
from
SYS.ID_GENS$
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL ID_GENS$ (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: axmdf8vq7k1rh
Plan Hash: 2203911306
select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,
flags
from
seq$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 3 4 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.00 3 4 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID SEQ$ (cr=2 pr=2 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_SEQ1 (cr=1 pr=1 pw=0 time=0 us)(object id 79)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 3 0.00 0.00
********************************************************************************
SQL ID: 6b7hj70p170j1
Plan Hash: 2605232930
select migrated
from
MIGRATE$
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL MIGRATE$ (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 1a8n1zgb7m90w
Plan Hash: 1457651150
select user#,password,datats#,tempts#,type#,defrole,resource$, ptime,exptime,
ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',
defschclass),spare1,spare4,ext_username,spare2
from
user$ where name=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 9 0.00 0.00 0 0 0 0
Execute 9 0.00 0.00 0 0 0 0
Fetch 9 0.00 0.01 5 16 0 7
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 27 0.00 0.01 5 16 0 7
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=2 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=1 pw=0 time=0 us)(object id 46)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 5 0.01 0.01
********************************************************************************
SQL ID: 8jh91432xkp96
Plan Hash: 415205717
select value$
from
sys.props$ where name = 'DEFAULT_TBS_TYPE'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL PROPS$ (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: cb21bacyh3c7d
Plan Hash: 3452538079
select metadata
from
kopm$ where name='DB_FDO'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 2 6 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.00 0.00 2 6 0 3
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID KOPM$ (cr=2 pr=2 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_KOPM1 (cr=1 pr=1 pw=0 time=0 us)(object id 553)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: a9j9r51pdk8dq
Plan Hash: 590607356
select attribute, value, pool_name
from
resource_storage_pool_mapping$ where status = 'ACTIVE'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 4 0.00 0.00 2 5 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 2 5 0 3
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
3 TABLE ACCESS FULL RESOURCE_STORAGE_POOL_MAPPING$ (cr=5 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: f4b2ymck2ucx7
Plan Hash: 3700673869
select cpu_capable, io_capable
from
resource_capability$ where status = 'ACTIVE'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL RESOURCE_CAPABILITY$ (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 3ftfq20w8v4bf
Plan Hash: 444487566
select instance_number, io_shares
from
resource_instance_capability$ where status = 'ACTIVE'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL RESOURCE_INSTANCE_CAPABILITY$ (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 077urrxmf3ntp
Plan Hash: 1699419314
select name,mandatory,mgmt_method,mast_method,pdl_method,que_method,max_iops,
max_mbps,num_plan_directives,description,sub_plan
from
resource_plan$ where obj#=:1 and status = 'ACTIVE'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 3 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL RESOURCE_PLAN$ (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 9rj67fg1saqyf
Plan Hash: 130299585
select plan, group_or_subplan, is_subplan,description, mandatory,mgmt_p1,
mgmt_p2, mgmt_p3, mgmt_p4, mgmt_p5, mgmt_p6, mgmt_p7, mgmt_p8,
active_sess_pool_p1, queueing_p1, parallel_degree_limit_p1, switch_group,
switch_for_call, switch_time, switch_estimate,max_est_exec_time,
switch_io_megabytes, switch_io_reqs, undo_pool, max_idle_time,
max_idle_blocker_time, max_utilization_limit
from
resource_plan_directive$ where obj#=:1 and status = 'ACTIVE'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 5 6 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 5 6 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL RESOURCE_PLAN_DIRECTIVE$ (cr=6 pr=5 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
db file scattered read 1 0.00 0.00
********************************************************************************
SQL ID: 5uj419gr6k6jh
Plan Hash: 1457651150
select user#
from
sys.user$ where name = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 4 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 4 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us)(object id 46)
********************************************************************************
SQL ID: 4mva9b2zw46bh
Plan Hash: 2620256078
select oper, nclsrs, clpcstr
from
appqossys.wlm_classifier_plan where active='Y' order by seqno
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS FULL WLM_CLASSIFIER_PLAN (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 1qhzsmjb3rn1v
Plan Hash: 395742348
select name
from
service$ where lower(name) = lower(:1) and deletion_date is null
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 2 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 2 6 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL SERVICE$ (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 8w7h1kc1rtck9
Plan Hash: 395742348
select service_id, name, name_hash, network_name, creation_date,
creation_date_hash, goal, flags
from
service$ where lower(name) = lower(:1) and deletion_date is null
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 6 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL SERVICE$ (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 58t2f7m2dabhc
Plan Hash: 2176009191
update service$ set name = :1, name_hash = :2, network_name = :3,
creation_date = :4, creation_date_hash = :5, deletion_date = null, goal =
:6, flags = :7
where
service_id = :8 and deletion_date is null
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 6 9 2
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 6 9 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 UPDATE SERVICE$ (cr=3 pr=0 pw=0 time=0 us)
1 TABLE ACCESS FULL SERVICE$ (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 6an46xdq1t9mh
Plan Hash: 395742348
select name
from
service$ where lower(network_name) = lower(:1) and deletion_date is null
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 8 0.00 0.00 0 0 0 0
Execute 8 0.00 0.00 0 0 0 0
Fetch 8 0.00 0.00 0 24 0 8
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 24 0.00 0.00 0 24 0 8
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL SERVICE$ (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: fv2rb1zqxbjtd
Plan Hash: 395742348
select service_id, name, name_hash, network_name, creation_date ,
creation_date_hash, goal, flags
from
service$ where lower(network_name) = lower(:1) and deletion_date is null
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 8 0.00 0.00 0 0 0 0
Execute 8 0.00 0.00 0 0 0 0
Fetch 8 0.00 0.00 0 24 0 8
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 24 0.00 0.00 0 24 0 8
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL SERVICE$ (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 7nuw4xwrnuwxq
Plan Hash: 1720483994
select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#,
nvl(typidcol#, 0)
from
coltype$ where obj#=:1 order by intcol# desc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 18 0.00 0.00 0 0 0 0
Fetch 48 0.00 0.00 0 58 0 30
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 67 0.00 0.00 0 58 0 30
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY (cr=3 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS CLUSTER COLTYPE$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
********************************************************************************
SQL ID: 9rfqm06xmuwu0
Plan Hash: 832500465
select intcol#, toid, version#, intcols, intcol#s, flags, synobj#
from
subcoltype$ where obj#=:1 order by intcol# asc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 18 0.00 0.00 0 0 0 0
Fetch 18 0.00 0.00 0 58 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 37 0.00 0.00 0 58 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY (cr=3 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS CLUSTER SUBCOLTYPE$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
********************************************************************************
SQL ID: f3g84j69n0tjh
Plan Hash: 914792125
select col#,intcol#,ntab#
from
ntab$ where obj#=:1 order by intcol# asc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 18 0.00 0.00 0 0 0 0
Fetch 18 0.00 0.00 0 58 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 37 0.00 0.00 0 58 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY (cr=3 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS CLUSTER NTAB$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
********************************************************************************
SQL ID: 6qz82dptj0qr7
Plan Hash: 2819763574
select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk,
l.pctversion$, l.flags, l.property, l.retention, l.freepools
from
lob$ l where l.obj# = :1 order by l.intcol# asc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 18 0.00 0.00 0 0 0 0
Execute 18 0.00 0.00 0 0 0 0
Fetch 50 0.00 0.00 0 58 0 32
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 86 0.00 0.00 0 58 0 32
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT ORDER BY (cr=3 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
1 TABLE ACCESS CLUSTER LOB$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
********************************************************************************
SQL ID: 9g485acn2n30m
Plan Hash: 2544153582
select col#,intcol#,reftyp,stabid,expctoid
from
refcon$ where obj#=:1 order by intcol# asc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 18 0.00 0.00 0 0 0 0
Fetch 18 0.00 0.00 0 58 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 37 0.00 0.00 0 58 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY (cr=3 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS CLUSTER REFCON$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
********************************************************************************
SQL ID: 32bhha21dkv0v
Plan Hash: 3765558045
select col#,intcol#,charsetid,charsetform
from
col$ where obj#=:1 order by intcol# asc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 18 0.00 0.00 0 0 0 0
Fetch 452 0.00 0.00 0 58 0 434
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 471 0.00 0.00 0 58 0 434
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
26 SORT ORDER BY (cr=3 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
26 TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=50 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
********************************************************************************
SQL ID: 0fr8zhn4ymu3v
Plan Hash: 3815847153
select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum
from
opqtype$ where obj# = :1 order by intcol# asc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 18 0.00 0.00 0 0 0 0
Fetch 24 0.00 0.00 0 58 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 43 0.00 0.00 0 58 0 6
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY (cr=3 pr=0 pw=0 time=0 us cost=0 size=0 card=0)
0 TABLE ACCESS CLUSTER OPQTYPE$ (cr=3 pr=0 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
********************************************************************************
SQL ID: dxg261d9ss0ck
Plan Hash: 2393006291
select count(*)
from
props$ where name = 'Flashback Timestamp TimeZone' and value$ = 'GMT'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=3 pr=0 pw=0 time=0 us)
1 TABLE ACCESS FULL PROPS$ (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 90s8f6sukgqay
Plan Hash: 2801793080
select ROWID
from
SYS_FBA_FA where ROWNUM = 1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.01 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 COUNT STOPKEY (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL SYS_FBA_FA (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.01 0.01
********************************************************************************
SQL ID: f93g1utkcbzy1
Plan Hash: 3110443938
select ROWID
from
SYS_FBA_TSFA where ROWNUM = 1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.07 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.07 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 COUNT STOPKEY (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL SYS_FBA_TSFA (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.07 0.07
********************************************************************************
SQL ID: 6wp53frbh3spm
Plan Hash: 3967990499
select ROWID
from
SYS_FBA_BARRIERSCN where ROWNUM = 1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.09 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.09 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 COUNT STOPKEY (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL SYS_FBA_BARRIERSCN (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.09 0.09
********************************************************************************
SQL ID: 7g5v7b8dqr7uk
Plan Hash: 3889482324
select ROWID
from
SYS_FBA_TRACKEDTABLES where ROWNUM = 1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.08 2 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.08 2 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 COUNT STOPKEY (cr=3 pr=2 pw=0 time=0 us)
1 TABLE ACCESS FULL SYS_FBA_TRACKEDTABLES (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.08 0.08
********************************************************************************
SQL ID: 9huyzhfyuf268
Plan Hash: 57660753
select ROWID
from
SYS_FBA_PARTITIONS where ROWNUM = 1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.11 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.11 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 COUNT STOPKEY (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL SYS_FBA_PARTITIONS (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.11 0.11
********************************************************************************
SQL ID: fdhss3k1pqxhd
Plan Hash: 2435880060
select ROWID
from
SYS_FBA_USERS where ROWNUM = 1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.12 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.12 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 COUNT STOPKEY (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL SYS_FBA_USERS (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.12 0.12
********************************************************************************
SQL ID: 9nmbh2kt7shht
Plan Hash: 462368108
select ROWID
from
SYS_FBA_DL where ROWNUM = 1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 COUNT STOPKEY (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL SYS_FBA_DL (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 00yp7w9j0yqma
Plan Hash: 3600061239
select count(OBJ#)
from
SYS_FBA_TRACKEDTABLES where bitand(FLAGS,1)!=0
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=3 pr=0 pw=0 time=0 us)
1 TABLE ACCESS FULL SYS_FBA_TRACKEDTABLES (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: fzrshwabvtwc0
Plan Hash: 1102678565
select max(FA#)
from
SYS_FBA_FA
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_C001418 (cr=1 pr=1 pw=0 time=0 us)(object id 1207)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: caf2d6j6pnw9k
Plan Hash: 2311451600
SELECT 1
FROM
obj$ WHERE name LIKE 'XS$SESSIONS'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 8 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 8 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL OBJ$ (cr=8 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 8cha9jugr3azt
Plan Hash: 741887118
DELETE FROM xs$session_roles
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 1 3 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 DELETE XS$SESSION_ROLES (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL XS$SESSION_ROLES (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: cqjck7ghzkrd6
Plan Hash: 799097471
DELETE FROM xs$session_appns
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 1 3 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 DELETE XS$SESSION_APPNS (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL XS$SESSION_APPNS (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: f0gxvbzd3gw3y
Plan Hash: 2298130309
DELETE FROM xs$sessions
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 1 3 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 DELETE XS$SESSIONS (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL XS$SESSIONS (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: abw5v7x40qga7
Plan Hash: 1097271556
select sval1
from
sys.optstat_hist_control$ where sname = 'STATS_RETENTION'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL OPTSTAT_HIST_CONTROL$ (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 2mas563p6kug8
Plan Hash: 3280045914
select pval2
from
sys.aux_stats$ where sname = 'SYSSTATS_INFO' and pname = 'STATUS'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 2 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID AUX_STATS$ (cr=2 pr=2 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_AUX_STATS$ (cr=1 pr=1 pw=0 time=0 us)(object id 428)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 60bas3qkzdwga
Plan Hash: 302179760
select pname, pval1
from
sys.aux_stats$ where sname = 'SYSSTATS_MAIN' and pval1 IS NOT NULL
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 4 0.00 0.00 0 8 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 8 0 3
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
3 TABLE ACCESS BY INDEX ROWID AUX_STATS$ (cr=8 pr=0 pw=0 time=0 us)
9 INDEX RANGE SCAN I_AUX_STATS$ (cr=4 pr=0 pw=0 time=8 us)(object id 428)
********************************************************************************
SQL ID: 1p3jtmshuqhz5
Plan Hash: 1704729258
select 1
from
dual where exists (select 1 from system.repcat$_repprop prop where
prop.type in (-1,2,9,-4) and prop.how in (1,3))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 1 3 0 0
Fetch 1 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 FILTER (cr=3 pr=1 pw=0 time=0 us)
0 FAST DUAL (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL REPCAT$_REPPROP (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 2dg0p3udrqw5c
Plan Hash: 3309445266
SELECT c.capture#, c.capture_name, c.flags
FROM
sys.streams$_capture_process c, dba_queues q, dba_queue_tables qt ,
v$instance i WHERE c.queue_owner = q.owner and c.queue_name = q.name
and qt.queue_table = q.queue_table and qt.owner = q.owner and
qt.owner_instance = i.instance_number and bitand(c.flags, 512) != 512
and c.status = :1 ORDER BY c.capture#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.03 0.04 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.03 0.04 1 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY (cr=3 pr=1 pw=0 time=0 us cost=0 size=0 card=0)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 MERGE JOIN OUTER (cr=3 pr=1 pw=0 time=0 us)
0 SORT JOIN (cr=3 pr=1 pw=0 time=0 us)
0 MERGE JOIN (cr=3 pr=1 pw=0 time=0 us)
0 SORT JOIN (cr=3 pr=1 pw=0 time=0 us)
0 MERGE JOIN (cr=3 pr=1 pw=0 time=0 us)
0 SORT JOIN (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL STREAMS$_CAPTURE_PROCESS (cr=3 pr=1 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER1 (cr=0 pr=0 pw=0 time=0 us)(object id 46)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUES (cr=0 pr=0 pw=0 time=0 us)
0 INDEX RANGE SCAN I1_QUEUES (cr=0 pr=0 pw=0 time=0 us)(object id 5603)
0 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=0 pr=0 pw=0 time=0 us)(object id 5596)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
0 SORT JOIN (cr=0 pr=0 pw=0 time=0 us)
0 VIEW DBA_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
0 SORT UNIQUE (cr=0 pr=0 pw=0 time=0 us)
0 UNION-ALL (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL AQ$_QUEUE_TABLE_AFFINITIES (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=0 pr=0 pw=0 time=0 us)(object id 5596)
0 TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_COL1 (cr=0 pr=0 pw=0 time=0 us)(object id 48)
0 TABLE ACCESS CLUSTER COLTYPE$ (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX RANGE SCAN I_OBJ3 (cr=0 pr=0 pw=0 time=0 us)(object id 38)
0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us)(object id 11)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL AQ$_QUEUE_TABLE_AFFINITIES (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=0 pr=0 pw=0 time=0 us)(object id 5596)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
0 SORT JOIN (cr=0 pr=0 pw=0 time=0 us)
0 FIXED TABLE FULL X$KSUXSINST (cr=0 pr=0 pw=0 time=0 us)
0 SORT JOIN (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL SERVICE$ (cr=0 pr=0 pw=0 time=0 us)
0 FIXED TABLE FULL X$QUIESCE (cr=0 pr=0 pw=0 time=0 us)
0 FIXED TABLE FULL X$KVIT (cr=0 pr=0 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 3nhfzxjzx2btx
Plan Hash: 0
select ks.inst_id,ksuxsins,ksuxssid,ksuxshst,ksuxsver,ksuxstim,
decode(ksuxssts,0,'STARTED',1,'MOUNTED',2,'OPEN',3,'OPEN MIGRATE','UNKNOWN')
,decode(ksuxsshr,0,'NO',1,'YES',2,NULL),ksuxsthr,decode(ksuxsarc,0,
'STOPPED',1,'STARTED','FAILED'),decode(ksuxslsw,0,NULL,2,'ARCHIVE LOG',3,
'CLEAR LOG',4,'CHECKPOINT', 5,'REDO GENERATION'),decode(ksuxsdba,0,
'ALLOWED','RESTRICTED'),decode(ksuxsshp,0,'NO','YES'),decode(kvitval,0,
'ACTIVE',2147483647,'SUSPENDED','INSTANCE RECOVERY'),decode(ksuxsrol,1,
'PRIMARY_INSTANCE',2,'SECONDARY_INSTANCE','UNKNOWN'), decode(qui_state,0,
'NORMAL',1,'QUIESCING',2,'QUIESCED','UNKNOWN'), decode(bitand(ksuxsdst, 1),
0, 'NO', 1, 'YES', 'NO')
from
x$ksuxsinst ks, x$kvit kv, x$quiesce qu where kvittag = 'kcbwst'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
SQL ID: 5r4jv9ywsx8gh
Plan Hash: 0
select INSTANCE_NUMBER , INSTANCE_NAME , HOST_NAME , VERSION , STARTUP_TIME ,
STATUS , PARALLEL , THREAD# , ARCHIVER , LOG_SWITCH_WAIT , LOGINS ,
SHUTDOWN_PENDING, DATABASE_STATUS, INSTANCE_ROLE, ACTIVE_STATE, BLOCKED
from
GV$INSTANCE where inst_id = USERENV('Instance')
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
SQL ID: 0kugqg48477gf
Plan Hash: 828554155
select distinct(-privilege#),nvl(option$,0)
from
sysauth$ where grantee#=:1 and privilege#<0
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 202 0.00 0.00 4 4 0 201
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 204 0.00 0.00 4 4 0 201
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
201 SORT UNIQUE (cr=4 pr=4 pw=0 time=200 us)
201 TABLE ACCESS BY INDEX ROWID SYSAUTH$ (cr=4 pr=4 pw=0 time=900 us)
201 INDEX RANGE SCAN I_SYSAUTH1 (cr=2 pr=2 pw=0 time=400 us)(object id 121)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 4 0.00 0.00
********************************************************************************
SQL ID: 0m78skf1mudnb
Plan Hash: 3506511888
select audit$,properties
from
type_misc$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 6 0.00 0.00 3 18 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 18 0.00 0.00 3 18 0 6
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER TYPE_MISC$ (cr=3 pr=1 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 3 0.00 0.00
********************************************************************************
SQL ID: 3g7sxtj9d6zd3
Plan Hash: 742841275
select privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))
from
objauth$ where obj#=:1 and grantee#=:2 group by privilege#,nvl(col#,0)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 4 5 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 4 5 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT GROUP BY (cr=2 pr=2 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=2 pw=0 time=0 us)
0 INDEX RANGE SCAN I_OBJAUTH2 (cr=2 pr=2 pw=0 time=0 us)(object id 63)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 4 0.00 0.00
********************************************************************************
SQL ID: 525j9xq684qa0
Plan Hash: 2171020028
SELECT a.apply#, a.apply_name, a.flags
FROM
sys.streams$_apply_process a, dba_queues q, dba_queue_tables qt ,v$instance
i WHERE a.queue_owner = q.owner and a.queue_name = q.name and
qt.queue_table = q.queue_table and qt.owner = q.owner and
qt.owner_instance = i.instance_number and a.status = :1 ORDER BY
a.apply#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.01 0.01 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.01 1 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT ORDER BY (cr=3 pr=1 pw=0 time=0 us cost=0 size=0 card=0)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 MERGE JOIN OUTER (cr=3 pr=1 pw=0 time=0 us)
0 SORT JOIN (cr=3 pr=1 pw=0 time=0 us)
0 MERGE JOIN (cr=3 pr=1 pw=0 time=0 us)
0 SORT JOIN (cr=3 pr=1 pw=0 time=0 us)
0 MERGE JOIN (cr=3 pr=1 pw=0 time=0 us)
0 SORT JOIN (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL STREAMS$_APPLY_PROCESS (cr=3 pr=1 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER1 (cr=0 pr=0 pw=0 time=0 us)(object id 46)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUES (cr=0 pr=0 pw=0 time=0 us)
0 INDEX RANGE SCAN I1_QUEUES (cr=0 pr=0 pw=0 time=0 us)(object id 5603)
0 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=0 pr=0 pw=0 time=0 us)(object id 5596)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
0 SORT JOIN (cr=0 pr=0 pw=0 time=0 us)
0 VIEW DBA_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
0 SORT UNIQUE (cr=0 pr=0 pw=0 time=0 us)
0 UNION-ALL (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL AQ$_QUEUE_TABLE_AFFINITIES (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=0 pr=0 pw=0 time=0 us)(object id 5596)
0 TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_COL1 (cr=0 pr=0 pw=0 time=0 us)(object id 48)
0 TABLE ACCESS CLUSTER COLTYPE$ (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX RANGE SCAN I_OBJ3 (cr=0 pr=0 pw=0 time=0 us)(object id 38)
0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us)(object id 11)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL AQ$_QUEUE_TABLE_AFFINITIES (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=0 pr=0 pw=0 time=0 us)(object id 5596)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
0 SORT JOIN (cr=0 pr=0 pw=0 time=0 us)
0 FIXED TABLE FULL X$KSUXSINST (cr=0 pr=0 pw=0 time=0 us)
0 SORT JOIN (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL SERVICE$ (cr=0 pr=0 pw=0 time=0 us)
0 FIXED TABLE FULL X$QUIESCE (cr=0 pr=0 pw=0 time=0 us)
0 FIXED TABLE FULL X$KVIT (cr=0 pr=0 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 2qqqjzkhmsbgv
Plan Hash: 1308273333
select location_name
from
loc$
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL LOC$ (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 3dy4t9mwf8rkg
Plan Hash: 1771576174
select count(*)
from
dba_scheduler_jobs where job_action = 'sys.dbms_aqadm_sys.register_driver'
and instance_id = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.07 0.08 0 0 0 0
Fetch 1 0.00 0.00 4 5 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.08 0.08 4 5 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=5 pr=4 pw=0 time=0 us)
0 VIEW DBA_SCHEDULER_JOBS (cr=5 pr=4 pw=0 time=0 us)
0 UNION-ALL (cr=5 pr=4 pw=0 time=0 us)
0 NESTED LOOPS (cr=5 pr=4 pw=0 time=0 us)
0 NESTED LOOPS (cr=5 pr=4 pw=0 time=0 us)
0 NESTED LOOPS OUTER (cr=5 pr=4 pw=0 time=0 us)
0 NESTED LOOPS (cr=5 pr=4 pw=0 time=0 us)
1 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
1 FIXED TABLE FULL X$KCCDI2 (cr=0 pr=0 pw=0 time=0 us)
1 FIXED TABLE FULL X$KCCDI (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL SCHEDULER$_JOB (cr=5 pr=4 pw=0 time=0 us)
0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36)
0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36)
0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us)(object id 11)
0 FILTER (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS OUTER (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL SCHEDULER$_LIGHTWEIGHT_JOB (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID SCHEDULER$_LWJOB_OBJ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN SCHEDULER$_LOBJ_PK (cr=0 pr=0 pw=0 time=0 us)(object id 5845)
0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us)(object id 11)
0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36)
0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
control file sequential read 7 0.00 0.00
db file sequential read 1 0.00 0.00
db file scattered read 1 0.00 0.00
********************************************************************************
SQL ID: 6004acmhbg1w3
Plan Hash: 0
select di.inst_id,di.didbi,di.didbn,to_date(di.dicts,'MM/DD/RR HH24:MI:SS',
'NLS_CALENDAR=Gregorian'),to_number(di.dirls),to_date(di.dirlc,'MM/DD/RR
HH24:MI:SS','NLS_CALENDAR=Gregorian'),to_number(di.diprs),to_date(di.diprc,
'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),decode(di.dimla,0,
'NOARCHIVELOG',1,'ARCHIVELOG','MANUAL'),to_number(di.discn),
to_number(di.difas),decode(bitand(di.diflg,256),256,'CREATED',
decode(bitand(di.diflg,1024),1024,'STANDBY',decode(bitand(di.diflg,32768),
32768,'CLONE',decode(bitand(di.diflg,4096),4096,'BACKUP','CURRENT')))),
to_date(di.dicct,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),di.dicsq,
to_number(di.dickp_scn),to_date(di.dickp_tim,'MM/DD/RR HH24:MI:SS',
'NLS_CALENDAR=Gregorian'),decode(bitand(di.diflg,4),4,'REQUIRED',
decode(di.diirs,0,'NOT ALLOWED','ALLOWED')),to_date(di.divts,'MM/DD/RR
HH24:MI:SS','NLS_CALENDAR=Gregorian'),decode(di.didor,0,'MOUNTED',
decode(di.didor,1,'READ WRITE',decode(di.didor,2,'READ ONLY', 'READ ONLY
WITH APPLY'))),decode(bitand(di.diflg,65536),65536,'MAXIMUM PROTECTION',
decode(bitand(di.diflg,128),128,'MAXIMUM AVAILABILITY',
decode(bitand(di.diflg,134217728),134217728,'RESYNCHRONIZATION',
decode(bitand(di.diflg,8),8,'UNPROTECTED','MAXIMUM PERFORMANCE')))),
decode(di.diprt,1,'MAXIMUM PROTECTION',2,'MAXIMUM AVAILABILITY',3,
'RESYNCHRONIZATION',4,'MAXIMUM PERFORMANCE',5,'UNPROTECTED', 'UNKNOWN'),
decode(di.dirae,0,'DISABLED',1,'SEND',2,'RECEIVE',3,'ENABLED','UNKNOWN'),
to_number(di.diacid),to_number(di.diacid),decode(bitand(di.difl2,32768),
32768,'SNAPSHOT STANDBY',decode(bitand(di.diflg,33554432),33554432,'LOGICAL
STANDBY',decode(bitand(di.diflg,1024),1024,'PHYSICAL STANDBY','PRIMARY'))),
to_number(di.diars),decode(bitand(difl2,1),1,'ENABLED','DISABLED'),
decode(di.disos,0,'IMPOSSIBLE',1,'NOT ALLOWED',2,'SWITCHOVER LATENT',3,
'SWITCHOVER PENDING',4,'TO PRIMARY',5,'TO STANDBY',6,'RECOVERY NEEDED',7,
'SESSIONS ACTIVE',8,'PREPARING SWITCHOVER',9,'PREPARING DICTIONARY',10,'TO
LOGICAL STANDBY',11,'FAILED DESTINATION',12,'RESOLVABLE GAP',13,'LOG SWITCH
GAP',14,'UNRESOLVABLE GAP',NULL),decode(di.didgd,0,'DISABLED','ENABLED'),
decode(bitand(di.diflg,1048576),1048576,'ALL',decode(bitand(di.diflg,
2097152),2097152,'STANDBY','NONE')),decode(bitand(diflg,1073741824),
1073741824, 'YES', decode(bitand(diflg, 131072 + 262144 +
524288),0, decode(bitand(difl2,2 + 64), 0,'NO',
'IMPLICIT'), 'IMPLICIT')),decode(bitand(di.diflg,131072)
,131072,'YES','NO'),decode(bitand(di.diflg,262144),262144,'YES','NO'),
decode(bitand(di.diflg,268435456),268435456,'YES','NO'),di.diplid, di.dipln,
di2.di2rdi, di2.di2inc,to_number(di.dicur_scn),decode(bitand(di2.di2flag,1)
,1,'YES', decode(di2.di2rsp_oldest,0,'NO','RESTORE POINT
ONLY')),decode(bitand(diflg,524288),524288,'YES','NO'),decode(bitand(difl2,
2),2,'YES','NO'),di2.di2dbun, to_number(di2.di2actiscn), decode(di.difsts,0,
'DISABLED',1,'BYSTANDER',2,'SYNCHRONIZED',3,'UNSYNCHRONIZED',4,'SUSPENDED',
5,'STALLED',6,'LOADING DICTIONARY',7,'PRIMARY UNOBSERVED',8,'REINSTATE
REQUIRED',10,'REINSTATE FAILED',11,'TARGET OVER LAG LIMIT',12,'TARGET UNDER
LAG LIMIT',''), di.diftgt, di.difths,decode(di.difopr,1,'YES',2,'NO',3,
'UNKNOWN',''), di.difobs, decode(bitand(difl2, 16384), 16384, 'YES', 'NO'),
di2.di2pdbun, decode(bitand(di.difl2,64), 64, 'YES', 'NO'),
decode(di2.di2min_req_capture_scn, 0, to_number(null),
di2.di2min_req_capture_scn)
from
x$kccdi di, x$kccdi2 di2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)
********************************************************************************
SQL ID: 052f2k8ayzqp3
Plan Hash: 0
select DBID, NAME, CREATED, RESETLOGS_CHANGE#, RESETLOGS_TIME,
PRIOR_RESETLOGS_CHANGE#, PRIOR_RESETLOGS_TIME,LOG_MODE, CHECKPOINT_CHANGE#,
ARCHIVE_CHANGE#, CONTROLFILE_TYPE, CONTROLFILE_CREATED,
CONTROLFILE_SEQUENCE#, CONTROLFILE_CHANGE#, CONTROLFILE_TIME,
OPEN_RESETLOGS, VERSION_TIME, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL,
REMOTE_ARCHIVE, ACTIVATION#, SWITCHOVER#, DATABASE_ROLE, ARCHIVELOG_CHANGE#,
ARCHIVELOG_COMPRESSION, SWITCHOVER_STATUS, DATAGUARD_BROKER, GUARD_STATUS,
SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK,
SUPPLEMENTAL_LOG_DATA_UI, FORCE_LOGGING, PLATFORM_ID, PLATFORM_NAME,
RECOVERY_TARGET_INCARNATION#, LAST_OPEN_INCARNATION#, CURRENT_SCN,
FLASHBACK_ON,SUPPLEMENTAL_LOG_DATA_FK, SUPPLEMENTAL_LOG_DATA_ALL,
DB_UNIQUE_NAME, STANDBY_BECAME_PRIMARY_SCN, FS_FAILOVER_STATUS,
FS_FAILOVER_CURRENT_TARGET, FS_FAILOVER_THRESHOLD,
FS_FAILOVER_OBSERVER_PRESENT, FS_FAILOVER_OBSERVER_HOST,
CONTROLFILE_CONVERTED, PRIMARY_DB_UNIQUE_NAME, SUPPLEMENTAL_LOG_DATA_PL,
MIN_REQUIRED_CAPTURE_CHANGE#
from
GV$DATABASE where inst_id = USERENV('Instance')
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
SQL ID: bd4bznqbq73hk
Plan Hash: 2595917966
select bo#, intcol#
from
icoldep$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 4 0.00 0.00 1 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 1 6 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID ICOLDEP$ (cr=3 pr=1 pw=0 time=0 us)
1 INDEX RANGE SCAN I_ICOLDEP$_OBJ (cr=2 pr=1 pw=0 time=0 us)(object id 115)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: b1wc53ddd6h3p
Plan Hash: 1637390370
select audit$,options
from
procedure$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 9 0.00 0.00 0 0 0 0
Execute 9 0.00 0.00 0 0 0 0
Fetch 9 0.00 0.06 11 27 0 9
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 27 0.00 0.06 11 27 0 9
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID PROCEDURE$ (cr=3 pr=3 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_PROCEDURE1 (cr=2 pr=2 pw=0 time=0 us)(object id 230)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 11 0.02 0.06
********************************************************************************
SQL ID: ga9j9xk5cy9s0
Plan Hash: 1516415349
select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece
from
idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 12 0.00 0.00 0 0 0 0
Execute 12 0.00 0.00 0 0 0 0
Fetch 29 0.00 0.09 16 54 0 17
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 53 0.01 0.10 16 54 0 17
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
2 SORT ORDER BY (cr=4 pr=4 pw=0 time=0 us cost=0 size=0 card=0)
2 TABLE ACCESS BY INDEX ROWID IDL_SB4$ (cr=4 pr=4 pw=0 time=62 us)
2 INDEX RANGE SCAN I_IDL_SB41 (cr=2 pr=2 pw=0 time=3 us)(object id 238)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 16 0.05 0.09
********************************************************************************
SQL ID: cvn54b7yz0s8u
Plan Hash: 2334475966
select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece
from
idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 12 0.00 0.00 0 0 0 0
Execute 12 0.00 0.00 0 0 0 0
Fetch 27 0.00 0.10 24 64 0 20
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 51 0.01 0.11 24 64 0 20
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT ORDER BY (cr=3 pr=3 pw=0 time=0 us cost=0 size=0 card=0)
1 TABLE ACCESS BY INDEX ROWID IDL_UB1$ (cr=3 pr=3 pw=0 time=0 us)
1 INDEX RANGE SCAN I_IDL_UB11 (cr=2 pr=2 pw=0 time=0 us)(object id 235)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 24 0.04 0.10
********************************************************************************
SQL ID: c6awqs517jpj0
Plan Hash: 1780865333
select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece
from
idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 12 0.00 0.00 0 0 0 0
Execute 12 0.00 0.00 0 0 0 0
Fetch 26 0.00 0.07 29 61 0 14
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 50 0.01 0.08 29 61 0 14
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT ORDER BY (cr=3 pr=3 pw=0 time=0 us cost=0 size=0 card=0)
1 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ (cr=3 pr=3 pw=0 time=0 us)
1 INDEX RANGE SCAN I_IDL_CHAR1 (cr=2 pr=2 pw=0 time=0 us)(object id 236)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 29 0.02 0.07
********************************************************************************
SQL ID: 39m4sx9k63ba2
Plan Hash: 323350262
select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece
from
idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 12 0.00 0.00 0 0 0 0
Execute 12 0.00 0.00 0 0 0 0
Fetch 52 0.01 0.06 84 148 0 46
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 76 0.02 0.07 84 148 0 46
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
6 SORT ORDER BY (cr=7 pr=7 pw=0 time=0 us cost=0 size=0 card=0)
6 TABLE ACCESS BY INDEX ROWID IDL_UB2$ (cr=7 pr=7 pw=0 time=2830 us)
6 INDEX RANGE SCAN I_IDL_UB21 (cr=2 pr=2 pw=0 time=20 us)(object id 237)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 84 0.01 0.06
********************************************************************************
SQL ID: grzuvf0hjxt1f
Plan Hash: 108095504
select audit$
from
library$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 1 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 1 6 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER LIBRARY$ (cr=3 pr=1 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us)(object id 3)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 6w3rdsz64hdhk
Plan Hash: 142325956
select min(timeout)
from
sys.reg$
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) REG$_T (cr=1 pr=1 pw=0 time=0 us)(object id 5579)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: af3baktns96r4
Plan Hash: 2607794745
select count(*)
from
sys.aq_event_table
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 1 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL AQ_EVENT_TABLE (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 7f2p5r411nrcz
Plan Hash: 3023127171
(SELECT sequence#, src_sid, src_serial#,
src_state, src_userid, src_schemaid FROM
tsm_src$ WHERE
src_inst_name = nvl(:1, src_inst_name) AND
src_inst_id = nvl(:2, src_inst_id) AND
src_start_time < :3 AND
src_state NOT IN (6, 7)) UNION ALL
(SELECT sequence#,
dst_sid, dst_serial#, dst_state,
dst_userid, dst_schemaid FROM tsm_dst$
WHERE dst_inst_name =
nvl(:1, dst_inst_name) AND dst_inst_id =
nvl(:2, dst_inst_id) AND dst_start_time < :3
AND dst_state NOT IN (6, 7))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 6 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 6 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 UNION-ALL (cr=6 pr=2 pw=0 time=0 us)
0 TABLE ACCESS FULL TSM_SRC$ (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL TSM_DST$ (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: fapvqzp8sd0zt
Plan Hash: 3343329764
select q.eventid, q.table_objno
from
system.aq$_queues q
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 40 0.00 0.00 2 41 0 39
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 42 0.00 0.00 2 41 0 39
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
39 TABLE ACCESS FULL AQ$_QUEUES (cr=41 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: c4psbujzwz0s6
Plan Hash: 3784679302
select a.schema, a.name, b.name, b.eventid, a.flags, a.sort_cols
from
system.aq$_queues b, system.aq$_queue_tables a,
sys.aq$_queue_table_affinities t where a.objno = b.table_objno and
t.table_objno = b.table_objno and bitand(b.properties, 512) = 512 and
t.owner_instance = :1 for update of t.owner_instance
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 3 0 0
Fetch 1 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 FOR UPDATE (cr=3 pr=0 pw=0 time=0 us)
0 BUFFER SORT (cr=3 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL AQ$_QUEUES (cr=3 pr=0 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLE_AFFINITIES (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN AQ$_QTABLE_AFFINITIES_PK (cr=0 pr=0 pw=0 time=0 us)(object id 5606)
0 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=0 pr=0 pw=0 time=0 us)(object id 5596)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 15ww8f92wgzxd
Plan Hash: 3416153831
select eventid, destination, name, schema, disabled, flags, job_name,
propagation_name
from
(select source_queue_schema, source_queue, propagation_name, '"' ||
destination_queue_schema || '"."' || destination_queue || '"'||
nvl2(destination_dblink, '@', '') || destination_dblink as dest
from sys.streams$_propagation_process) sp, (select q.eventid, s.destination,
q.name, t.schema, s.disabled, t.flags, s.job_name from
system.aq$_queues q, sys.aq$_schedules s, system.aq$_queue_tables t,
sys.aq$_queue_table_affinities aft where q.oid = s.oid and q.table_objno =
t.objno and aft.table_objno = t.objno and bitand(q.properties, 512) = 512
and aft.owner_instance = :1 ) where sp.source_queue_schema (+)= schema and
sp.source_queue (+)= name and sp.dest (+)= destination
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 MERGE JOIN OUTER (cr=3 pr=1 pw=0 time=0 us)
0 SORT JOIN (cr=3 pr=1 pw=0 time=0 us)
0 VIEW (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS FULL AQ$_SCHEDULES (cr=3 pr=1 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUES (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN AQ$_QUEUES_PRIMARY (cr=0 pr=0 pw=0 time=0 us)(object id 5601)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=0 pr=0 pw=0 time=0 us)
0 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=0 pr=0 pw=0 time=0 us)(object id 5596)
0 INDEX UNIQUE SCAN AQ$_QTABLE_AFFINITIES_PK (cr=0 pr=0 pw=0 time=0 us)(object id 5606)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLE_AFFINITIES (cr=0 pr=0 pw=0 time=0 us)
0 SORT JOIN (cr=0 pr=0 pw=0 time=0 us)
0 VIEW (cr=0 pr=0 pw=0 time=0 us)
0 TABLE ACCESS FULL STREAMS$_PROPAGATION_PROCESS (cr=0 pr=0 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 79w2cqu2gmjm8
Plan Hash: 2645993454
select 1
from
aq$_schedules
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 6 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 6 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_SCHEDULES (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 2jr8c42qx700h
Plan Hash: 3034582372
select 1
from
sys.aq$_queue_table_affinities
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 2 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 2 6 0 2
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL AQ$_QUEUE_TABLE_AFFINITIES (cr=3 pr=2 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 1q2yh37mcyspc
Plan Hash: 2697005088
select count(aft.table_objno)
from
system.aq$_queue_tables t, sys.aq$_queue_table_affinities aft where
aft.table_objno = t.objno and aft.owner_instance = :1 and bitand(t.flags,
4+16+32+64+128+256) = 0 and NOT ( t.name in ('DEF$_AQCALL' ,
'DEF$_AQERROR') and t.schema = 'SYSTEM')
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 3 6 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 3 6 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=6 pr=3 pw=0 time=0 us)
18 NESTED LOOPS (cr=6 pr=3 pw=0 time=425 us)
20 NESTED LOOPS (cr=5 pr=2 pw=0 time=304 us)
20 INDEX RANGE SCAN I1_QUEUE_TABLE_AFFINITIES (cr=1 pr=1 pw=0 time=38 us)(object id 5607)
20 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=4 pr=1 pw=0 time=0 us)(object id 5596)
18 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=1 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 3 0.00 0.00
********************************************************************************
SQL ID: ayyw8ywjuqak1
Plan Hash: 2983345655
select t.schema, t.name, t.objno, t.flags, t.timezone
from
system.aq$_queue_tables t, sys.aq$_queue_table_affinities aft where
aft.table_objno = t.objno and aft.owner_instance = :1 and
bitand(t.flags, 4+16+32+64+128+256) = 0 and NOT ( t.name in
('DEF$_AQCALL' , 'DEF$_AQERROR') and t.schema = 'SYSTEM') and exists
(select 1 from system.aq$_queues q where q.table_objno =
t.objno and q.usage = 0)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.01 0 60 0 16
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.01 0 60 0 16
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
16 FILTER (cr=60 pr=0 pw=0 time=1215 us)
18 NESTED LOOPS (cr=6 pr=0 pw=0 time=714 us)
20 NESTED LOOPS (cr=5 pr=0 pw=0 time=456 us)
20 INDEX RANGE SCAN I1_QUEUE_TABLE_AFFINITIES (cr=1 pr=0 pw=0 time=76 us)(object id 5607)
20 INDEX UNIQUE SCAN AQ$_QUEUE_TABLES_PRIMARY (cr=4 pr=0 pw=0 time=0 us)(object id 5596)
18 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLES (cr=1 pr=0 pw=0 time=0 us)
16 TABLE ACCESS FULL AQ$_QUEUES (cr=54 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 9zpztc7h1az2x
Plan Hash: 672769927
select min(next_date)
from
"SYS"."AQ$_SCHEDULER$_EVENT_QTAB_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_12209 (cr=1 pr=1 pw=0 time=0 us)(object id 12210)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 14s3z6v0m3ug9
Plan Hash: 1202243636
select 1
from
"SYS"."AQ$_SCHEDULER$_EVENT_QTAB_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_SCHEDULER$_EVENT_QTAB_L (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 9afz3av0ahau0
Plan Hash: 1494822036
select min(next_date)
from
"SYS"."AQ$_SCHEDULER$_REMDB_JOBQTAB_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_12243 (cr=1 pr=1 pw=0 time=0 us)(object id 12244)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: gzyt498gtbgt5
Plan Hash: 2826905927
select 1
from
"SYS"."AQ$_SCHEDULER$_REMDB_JOBQTAB_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_SCHEDULER$_REMDB_JOBQTAB_L (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: chtu940qhsubv
Plan Hash: 4206934885
select min(next_date)
from
"SYS"."AQ$_SCHEDULER_FILEWATCHER_QT_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_12273 (cr=1 pr=1 pw=0 time=0 us)(object id 12274)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 9gwhf5twaty38
Plan Hash: 4015179154
select 1
from
"SYS"."AQ$_SCHEDULER_FILEWATCHER_QT_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_SCHEDULER_FILEWATCHER_QT_L (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 4cvqvs489pd6k
Plan Hash: 3938281362
select min(next_date)
from
"SYS"."AQ$_ALERT_QT_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 5 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 5 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=3 pr=5 pw=0 time=0 us)
1 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_12329 (cr=3 pr=5 pw=0 time=0 us)(object id 12330)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
db file scattered read 1 0.00 0.00
********************************************************************************
SQL ID: 3rw49yhahg984
Plan Hash: 3808094885
select 1
from
"SYS"."AQ$_ALERT_QT_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.01 6 7 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 6 7 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_ALERT_QT_L (cr=7 pr=6 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
db file scattered read 1 0.01 0.01
********************************************************************************
SQL ID: dnw4gjpv5ssfr
Plan Hash: 987508402
select min(time_manager_info)
from
"SYS"."AQ_EVENT_TABLE"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.01 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) AQ$_AQ_EVENT_TABLE_T (cr=1 pr=1 pw=0 time=0 us)(object id 12553)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.01 0.01
********************************************************************************
SQL ID: ac8wzzswuaxq6
Plan Hash: 999410102
select min(next_date)
from
"SYS"."AQ$_AQ_PROP_TABLE_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_12568 (cr=1 pr=1 pw=0 time=0 us)(object id 12569)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 0576dn78v0sa8
Plan Hash: 2790004782
select 1
from
"SYS"."AQ$_AQ_PROP_TABLE_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_AQ_PROP_TABLE_L (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 39sapw7j19n9v
Plan Hash: 2863688657
select min(next_date)
from
"SYS"."AQ$_SYS$SERVICE_METRICS_TAB_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_12870 (cr=1 pr=1 pw=0 time=0 us)(object id 12871)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: b4p816cw0mt42
Plan Hash: 2094602082
select 1
from
"SYS"."AQ$_SYS$SERVICE_METRICS_TAB_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_SYS$SERVICE_METRICS_TAB_L (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: g392shwjn48m7
Plan Hash: 573438997
select min(next_date)
from
"WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.01 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_13388 (cr=1 pr=1 pw=0 time=0 us)(object id 13389)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.01 0.01
********************************************************************************
SQL ID: fn5q3pxjh5v2r
Plan Hash: 646133317
select 1
from
"WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_WM$EVENT_QUEUE_TABLE_L (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: ffm1rpqjrj55q
Plan Hash: 3953874105
select min(time_manager_info)
from
"SYSMAN"."MGMT_TASK_QTABLE"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.01 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) AQ$_MGMT_TASK_QTABLE_T (cr=1 pr=1 pw=0 time=0 us)(object id 66548)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: ga4sc56kbz3jf
Plan Hash: 1086404281
select min(next_date)
from
"SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_66870 (cr=1 pr=1 pw=0 time=0 us)(object id 66871)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 2nkbcfxuxtrdr
Plan Hash: 3308748171
select 1
from
"SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 6 7 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 6 7 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_MGMT_NOTIFY_QTABLE_L (cr=7 pr=6 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
db file scattered read 1 0.00 0.00
********************************************************************************
SQL ID: gsc454xj7tk2h
Plan Hash: 1025196078
select min(time_manager_info)
from
"SYSMAN"."MGMT_NOTIFY_INPUT_QTABLE"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.03 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.03 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) AQ$_MGMT_NOTIFY_INPUT_QTABLE_T (cr=1 pr=1 pw=0 time=0 us)(object id 66903)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 22btuvwjkf1kj
Plan Hash: 2876601122
select min(time_manager_info)
from
"SYSMAN"."MGMT_PAF_MSG_QTABLE_1"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) AQ$_MGMT_PAF_MSG_QTABLE_1_T (cr=1 pr=1 pw=0 time=0 us)(object id 69921)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 5s1wd9yx3929g
Plan Hash: 3132517126
select min(time_manager_info)
from
"SYSMAN"."MGMT_PAF_MSG_QTABLE_2"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) AQ$_MGMT_PAF_MSG_QTABLE_2_T (cr=1 pr=1 pw=0 time=0 us)(object id 69931)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: dmr975jmy58r2
Plan Hash: 862409410
select min(next_date)
from
"SYSMAN"."AQ$_MGMT_LOADER_QTABLE_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_70037 (cr=1 pr=1 pw=0 time=0 us)(object id 70038)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: a1bjn0qkhs39k
Plan Hash: 2791117221
select 1
from
"SYSMAN"."AQ$_MGMT_LOADER_QTABLE_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_MGMT_LOADER_QTABLE_L (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 99jc17m962bm2
Plan Hash: 1808714049
select min(next_date)
from
"IX"."AQ$_ORDERS_QUEUETABLE_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.01 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.02 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_74037 (cr=1 pr=1 pw=0 time=0 us)(object id 74038)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.01 0.01
********************************************************************************
SQL ID: 9za9hdyvyagpb
Plan Hash: 3902031869
select 1
from
"IX"."AQ$_ORDERS_QUEUETABLE_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 6 7 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 6 7 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_ORDERS_QUEUETABLE_L (cr=7 pr=6 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
db file scattered read 1 0.00 0.00
********************************************************************************
SQL ID: 5udzcsnqp12qu
Plan Hash: 1427393521
select min(next_date)
from
"IX"."AQ$_STREAMS_QUEUE_TABLE_T"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.01 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
0 INDEX FULL SCAN (MIN/MAX) SYS_IOT_TOP_74055 (cr=1 pr=1 pw=0 time=0 us)(object id 74056)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.01 0.01
********************************************************************************
SQL ID: cqnu7wcfkmpq9
Plan Hash: 3495518987
select 1
from
"IX"."AQ$_STREAMS_QUEUE_TABLE_L"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL AQ$_STREAMS_QUEUE_TABLE_L (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: cjk1ffy5kmm5s
Plan Hash: 1964104430
select obj#
from
oid$ where user#=:1 and oid$=:2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 7 0.00 0.00 0 0 0 0
Fetch 7 0.00 0.00 4 17 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 15 0.00 0.00 4 17 0 3
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID OID$ (cr=2 pr=2 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_OID1 (cr=2 pr=2 pw=0 time=0 us)(object id 501)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 10 0.00 0.01
********************************************************************************
SQL ID: 9gkq7rruycsjp
Plan Hash: 3362549386
select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused,
definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts,
defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256)
subparttype, mod(trunc(spare2/256), 256) subpartkeycols,
mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296),
256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize
from
partobj$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID PARTOBJ$ (cr=1 pr=1 pw=0 time=0 us)
0 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=1 pr=1 pw=0 time=0 us)(object id 573)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 3p51cyr9xywzk
Plan Hash: 1451523286
select count(*)
from
obj$ o, user$ u where o.name='XDB$SCHEMA' and o.owner#=u.user# and u.name=
'XDB'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 5 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 5 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=5 pr=2 pw=0 time=0 us)
1 NESTED LOOPS (cr=5 pr=2 pw=0 time=0 us)
1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=1 pw=0 time=0 us)
1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us)(object id 46)
1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=1 pw=0 time=0 us)(object id 37)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: gtf6tgc2ycgxx
Plan Hash: 2546093158
select count(*)
from
XDB.XDB$SCHEMA s where s.xmldata.schema_url =
'http://xmlns.oracle.com/xdb/XDBSchema.xsd'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.02 0.04 8 16 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.01 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.02 0.05 9 17 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=0 us)
1 INDEX RANGE SCAN XDB$SCHEMA_URL (cr=1 pr=1 pw=0 time=0 us)(object id 56463)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.01 0.01
********************************************************************************
SQL ID: gtjjya8d0hbp3
Plan Hash: 1640708800
select dbid, startup_time, parallel, version, name, instance_name, host_name,
platform_name
from
V$DATABASE, V$INSTANCE
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
1 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
1 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
1 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us)
1 FIXED TABLE FULL X$QUIESCE (cr=0 pr=0 pw=0 time=0 us)
1 FIXED TABLE FULL X$KVIT (cr=0 pr=0 pw=0 time=0 us)
1 FIXED TABLE FULL X$KSUXSINST (cr=0 pr=0 pw=0 time=0 us)
1 FIXED TABLE FULL X$KCCDI2 (cr=0 pr=0 pw=0 time=0 us)
1 FIXED TABLE FULL X$KCCDI (cr=0 pr=0 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
control file sequential read 7 0.00 0.00
********************************************************************************
SQL ID: 23g91gw32rz3s
Plan Hash: 953717036
SELECT signature
FROM
sql$
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL SQL$ (cr=3 pr=1 pw=0 time=0 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 01ymz5y0873v2
Plan Hash: 415205717
select decode(value$, 'CAPTURE', 1, 0)
from
props$ where name = 'WORKLOAD_CAPTURE_MODE'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL PROPS$ (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 8jftqdvptmg7h
Plan Hash: 415205717
select decode(value$, 'PREPARE' , 1 , 'REPLAY' , 2 , 0 )
from
props$ where name = 'WORKLOAD_REPLAY_MODE'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL PROPS$ (cr=3 pr=0 pw=0 time=0 us)
********************************************************************************
SQL ID: 8mz0wa11tacp0
Plan Hash: 1928007844
select table_objno, primary_instance, secondary_instance, owner_instance
from
sys.aq$_queue_table_affinities a where a.owner_instance <> :1 and
dbms_aqadm_syscalls.get_owner_instance(a.primary_instance,
a.secondary_instance, a.owner_instance) = :2 order by table_objno
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.01 0.01 1 6 0 0
Fetch 1 0.00 0.00 1 2 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.01 2 8 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLE_AFFINITIES (cr=2 pr=1 pw=0 time=0 us cost=2 size=12 card=1)
20 INDEX FULL SCAN AQ$_QTABLE_AFFINITIES_PK (cr=1 pr=1 pw=0 time=38 us cost=1 size=0 card=20)(object id 5606)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 2syvqzbxp4k9z
Plan Hash: 2369835006
select u.name, o.name, a.interface_version#, o.obj#
from
association$ a, user$ u, obj$ o where a.obj# = :1
and a.property = :2
and a.statstype# = o.obj# and
u.user# = o.owner#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 4 0.00 0.00 0 0 0 0
Execute 4 0.00 0.00 0 0 0 0
Fetch 4 0.00 0.00 1 4 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 12 0.00 0.01 1 4 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 NESTED LOOPS (cr=1 pr=1 pw=0 time=0 us cost=2 size=102 card=1)
0 NESTED LOOPS (cr=1 pr=1 pw=0 time=0 us cost=1 size=85 card=1)
0 TABLE ACCESS BY INDEX ROWID ASSOCIATION$ (cr=1 pr=1 pw=0 time=0 us cost=0 size=52 card=1)
0 INDEX RANGE SCAN ASSOC1 (cr=1 pr=1 pw=0 time=0 us cost=0 size=0 card=1)(object id 440)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=33 card=1)
0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 36)
0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=17 card=1)
0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 11)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 96g93hntrzjtr
Plan Hash: 2239883476
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#,
sample_size, minimum, maximum, distcnt, lowval, hival, density, col#,
spare1, spare2, avgcln
from
hist_head$ where obj#=:1 and intcol#=:2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 91 0.01 0.02 0 0 0 0
Fetch 91 0.01 0.02 19 270 0 88
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 183 0.03 0.04 19 270 0 88
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: RULE
Parsing user id: SYS (recursive depth: 3)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=3 pr=3 pw=0 time=0 us)
1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=2 pr=2 pw=0 time=0 us)(object id 426)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 19 0.01 0.01
********************************************************************************
SQL ID: db78fxqxwxt7r
Plan Hash: 3312420081
select /*+ rule */ bucket, endpoint, col#, epvalue
from
histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 75 0.02 0.01 0 0 0 0
Fetch 75 0.01 0.13 25 238 0 1255
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 151 0.03 0.15 25 238 0 1255
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: RULE
Parsing user id: SYS (recursive depth: 3)
Rows Row Source Operation
------- ---------------------------------------------------
20 SORT ORDER BY (cr=3 pr=3 pw=0 time=38 us cost=0 size=0 card=0)
20 TABLE ACCESS CLUSTER HISTGRM$ (cr=3 pr=3 pw=0 time=19 us)
1 INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=2 pr=2 pw=0 time=0 us)(object id 421)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 25 0.03 0.12
********************************************************************************
SQL ID: 2xyb5d6xg9srh
Plan Hash: 723397186
select a.default_cpu_cost, a.default_io_cost
from
association$ a where a.obj# = :1
and a.property = :2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 2 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 2 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID ASSOCIATION$ (cr=1 pr=0 pw=0 time=0 us cost=0 size=52 card=1)
0 INDEX RANGE SCAN ASSOC1 (cr=1 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 440)
********************************************************************************
SQL ID: 6c9wx6z8w9qpu
Plan Hash: 723397186
select a.default_selectivity
from
association$ a where a.obj# = :1
and a.property = :2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 2 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 2 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS BY INDEX ROWID ASSOCIATION$ (cr=1 pr=0 pw=0 time=0 us cost=0 size=39 card=1)
0 INDEX RANGE SCAN ASSOC1 (cr=1 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 440)
********************************************************************************
SQL ID: fcsk4kqjdy4vu
Plan Hash: 3201447092
select regid, regflags, numobjs, objarray, plsqlcallback, changelag,
username
from
invalidation_registry$
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 1 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL INVALIDATION_REGISTRY$ (cr=3 pr=1 pw=0 time=0 us cost=2 size=393 card=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: dmprqvgbzutrw
Plan Hash: 1069138862
select table_objno, primary_instance, secondary_instance, owner_instance
from
sys.aq$_queue_table_affinities a where a.owner_instance <> :1 and
dbms_aqadm_syscalls.get_owner_instance(a.primary_instance,
a.secondary_instance, a.owner_instance) = :2 order by
a.owner_instance, table_objno for update of a.owner_instance
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 1 0 0
Fetch 1 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 1 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 FOR UPDATE (cr=1 pr=0 pw=0 time=0 us)
0 BUFFER SORT (cr=1 pr=0 pw=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID AQ$_QUEUE_TABLE_AFFINITIES (cr=1 pr=0 pw=0 time=0 us cost=2 size=12 card=1)
0 INDEX FULL SCAN I1_QUEUE_TABLE_AFFINITIES (cr=1 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 5607)
********************************************************************************
SQL ID: 9zzuyxx4pjhsx
Plan Hash: 2350108572
select p_obj#, flags, code, audit$
from
edition$ where obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 2 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.01 2 3 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL EDITION$ (cr=3 pr=2 pw=0 time=0 us cost=2 size=48 card=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 459f3z9u4fb3u
Plan Hash: 415205717
select value$
from
props$ where name = 'GLOBAL_DB_NAME'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 4 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 4 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL PROPS$ (cr=4 pr=0 pw=0 time=0 us cost=2 size=28 card=1)
********************************************************************************
SQL ID: 6v0cyda83r2qf
Plan Hash: 2510613180
select decode(u.type#, 2, u.ext_username, u.name), o.name, trigger$.sys_evts,
trigger$.type#
from
obj$ o, user$ u, trigger$ where o.type# = 12 and
(bitand(trigger$.property, 8) = 8) and (bitand(trigger$.property, 16) !=
16) and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.02 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 26 0.01 0.18 129 157 0 25
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 28 0.03 0.20 129 157 0 25
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
25 SORT ORDER BY (cr=157 pr=129 pw=0 time=0 us cost=85 size=4125 card=25)
25 HASH JOIN (cr=157 pr=129 pw=0 time=24 us cost=84 size=4125 card=25)
25 NESTED LOOPS (cr=150 pr=128 pw=0 time=3600 us)
25 NESTED LOOPS (cr=134 pr=114 pw=0 time=672 us cost=80 size=1300 card=25)
25 TABLE ACCESS FULL TRIGGER$ (cr=107 pr=104 pw=0 time=144 us cost=30 size=375 card=25)
25 INDEX RANGE SCAN I_OBJ1 (cr=27 pr=10 pw=0 time=0 us cost=1 size=0 card=1)(object id 36)
25 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=16 pr=14 pw=0 time=0 us cost=2 size=37 card=1)
97 TABLE ACCESS FULL USER$ (cr=7 pr=1 pw=0 time=192 us cost=3 size=10961 card=97)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 26 0.02 0.14
db file scattered read 13 0.01 0.03
********************************************************************************
SQL ID: 3k0c6241uw582
Plan Hash: 1964643588
select actionsize
from
trigger$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 2 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 2 6 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=2 pw=0 time=0 us cost=2 size=9 card=1)
1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=2 pw=0 time=0 us cost=1 size=0 card=1)(object id 162)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 2 0.00 0.00
********************************************************************************
SQL ID: 07pcqtmt58zv9
Plan Hash: 1964643588
select action#
from
trigger$ where obj# = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 8 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 8 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=0 pw=0 time=0 us cost=2 size=8 card=1)
1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 162)
********************************************************************************
SQL ID: 6mhctgagpvvhp
Plan Hash: 1964643588
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
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 6 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=0 pw=0 time=0 us cost=2 size=155 card=1)
1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 162)
********************************************************************************
SQL ID: f91p5x1pzsmu1
Plan Hash: 1482114444
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) union select type#,
intcol#,position#,69,0,0,0,0,0,0 from triggercol$ where obj#=:6 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# = :7 and bitand(tc.type#,20) != 20
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.03 0.03 0 0 0 0
Fetch 2 0.00 0.04 3 30 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.03 0.08 3 30 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
0 SORT UNIQUE (cr=15 pr=2 pw=0 time=0 us cost=16 size=257 card=8)
0 UNION-ALL (cr=15 pr=2 pw=0 time=0 us)
0 CONCATENATION (cr=10 pr=2 pw=0 time=0 us)
0 NESTED LOOPS (cr=5 pr=2 pw=0 time=0 us)
0 NESTED LOOPS (cr=5 pr=2 pw=0 time=0 us cost=4 size=58 card=1)
0 NESTED LOOPS (cr=5 pr=2 pw=0 time=0 us cost=3 size=25 card=1)
1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=0 pw=0 time=0 us cost=2 size=9 card=1)
1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 162)
0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=2 pw=0 time=0 us cost=1 size=16 card=1)(object id 164)
0 INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 50)
0 TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=33 card=1)
0 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us)
0 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us cost=4 size=58 card=1)
0 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us cost=3 size=25 card=1)
1 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=0 pw=0 time=0 us cost=2 size=9 card=1)
1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 162)
0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 time=0 us cost=1 size=16 card=1)(object id 164)
0 INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 50)
0 TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=33 card=1)
0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=2 pr=0 pw=0 time=0 us cost=2 size=16 card=1)(object id 164)
0 NESTED LOOPS (cr=3 pr=0 pw=0 time=0 us cost=3 size=125 card=5)
0 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=3 pr=0 pw=0 time=0 us cost=2 size=9 card=1)
1 INDEX UNIQUE SCAN I_TRIGGER2 (cr=2 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 162)
0 INDEX RANGE SCAN I_TRIGGERCOL2 (cr=0 pr=0 pw=0 time=0 us cost=1 size=80 card=5)(object id 164)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 3 0.04 0.04
********************************************************************************
SQL ID: 4zzxr8rvht74z
Plan Hash: 3368685730
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#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.01 1 6 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.01 1 6 0 2
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 NESTED LOOPS (cr=3 pr=1 pw=0 time=0 us cost=3 size=30 card=1)
1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=0 us cost=2 size=8 card=1)(object id 36)
1 INDEX RANGE SCAN I_USER2 (cr=1 pr=1 pw=0 time=0 us cost=1 size=22 card=1)(object id 47)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.01 0.01
********************************************************************************
SQL ID: 24nspfz4sky5q
Plan Hash: 0
SELECT *
FROM
V$DATABASE
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
********************************************************************************
SQL ID: 7d5jf0vyq8f0j
Plan Hash: 415205717
select p.value$, lengthb(p.value$)
from
sys.props$ p where p.name = 'BACK_END_DB'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 0 0
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
0 TABLE ACCESS FULL PROPS$ (cr=3 pr=0 pw=0 time=0 us cost=2 size=28 card=1)
********************************************************************************
SQL ID: c8pktxyw9kfd8
Plan Hash: 0
DECLARE openMode V$DATABASE.open_mode%TYPE;
olapOn BOOLEAN;
histRetention BOOLEAN;
hist_id NUMBER;
sessionCount
NUMBER;
BEGIN
SELECT open_mode INTO openMode FROM V$DATABASE;
IF
(openMode != 'READ WRITE') THEN
histRetention := FALSE;
OlapiHistoryRetention(olapOn, histRetention, sessionCount);
RETURN;
END IF;
OlapiHistoryRetention(olapOn, histRetention, hist_id);
IF
(olapOn AND histRetention) THEN
BEGIN
SELECT
Olapi_History_Seq.NEXTVAL INTO hist_id FROM DUAL;
INSERT INTO
Olapi_History VALUES(SYS_CONTEXT('USERENV', 'Instance'),
hist_id,
CURRENT_TIMESTAMP, NULL, NULL, 0);
EXCEPTION
WHEN OTHERS THEN
histRetention := FALSE;
OlapiHistoryRetention(olapOn, histRetention,
sessionCount);
END;
END IF;
END;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.01 0.01 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 3xfg4hg8m0xm2
Plan Hash: 735420252
SELECT OPEN_MODE
FROM
V$DATABASE
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 2)
Rows Row Source Operation
------- ---------------------------------------------------
1 MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=0 us cost=0 size=2600 card=100)
1 FIXED TABLE FULL X$KCCDI (cr=0 pr=0 pw=0 time=0 us cost=0 size=26 card=1)
1 BUFFER SORT (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=100)
1 FIXED TABLE FULL X$KCCDI2 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=100)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
control file sequential read 7 0.00 0.00
********************************************************************************
BEGIN
-- Pin all PLSQL in the SYSMAN schema in memory
EMD_MAINTENANCE.PIN_PLSQL;
EXCEPTION
-- Trap all exceptions so database startup will not be impacted
-- by errors. Called routines should handle errors appropriately.
WHEN OTHERS THEN
NULL;
END;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 3 18 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.01 0.01 3 18 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 72 (recursive depth: 1)
********************************************************************************
SQL ID: ct4hvmdaryzh7
Plan Hash: 96862774
select ftp_port, ftp_protocol, http_port, http_protocol, http2_port,
http2_protocol, nfs_port, nfs_protocol, http_host, http2_host
from
xdb.xdb$root_info
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 6 7 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 6 7 0 1
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS FULL XDB$ROOT_INFO (cr=7 pr=6 pw=0 time=0 us cost=3 size=22 card=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
db file scattered read 1 0.00 0.00
********************************************************************************
SQL ID: 06nvwn223659v
Plan Hash: 0
alter session set events '10046 trace name context off'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 0
Parsing user id: SYS
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.02 0 0 0 0
Execute 2 0.32 0.76 20 34 64 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.32 0.79 20 34 64 0
Misses in library cache during parse: 1
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 2 0.00 0.00
SQL*Net message from client 2 19.69 29.81
Disk file operations I/O 15 0.00 0.00
control file sequential read 115 0.00 0.00
rdbms ipc reply 6 0.17 0.24
db file sequential read 25 0.02 0.02
control file parallel write 19 0.04 0.12
log file sync 2 0.00 0.00
instance state change 2 0.00 0.00
reliable message 1 0.00 0.00
os thread startup 1 0.02 0.02
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 652 0.44 0.50 8 16 0 0
Execute 2338 0.74 0.76 9 66 50 24
Fetch 7631 0.40 3.06 931 11864 0 7789
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 10621 1.58 4.34 948 11946 50 7813
Misses in library cache during parse: 233
Misses in library cache during execute: 105
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
control file sequential read 21 0.00 0.00
db file sequential read 795 0.12 2.45
db file scattered read 25 0.01 0.05
3 user SQL statements in session.
2222 internal SQL statements in session.
2225 SQL statements in session.
********************************************************************************
Trace file: orcl3939_ora_14781.trc
Trace file compatibility: 11.1.0.7
Sort options: default
1 session in tracefile.
3 user SQL statements in trace file.
2222 internal SQL statements in trace file.
2225 SQL statements in trace file.
225 unique SQL statements in trace file.
44932 lines in trace file.
24 elapsed seconds in trace file.