TKPROF: Release 12.2.0.1.0 - Development on Sun Feb 11 14:25:26 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Trace file: /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_STATS.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
********************************************************************************
begin
dbms_stats.gather_table_stats (
ownname => 'U',
tabname => 'ORDS',
no_invalidate => false
);
end;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.15 0.15 0 37 29 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.15 0.15 0 37 29 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 114
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 7 0.00 0.00
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 0.00 0.00
********************************************************************************
SQL ID: 9d8cr4qsr2h11 Plan Hash: 1805486652
SELECT VALUE
FROM
NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_SORT'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 16 0.00 0.00 0 0 0 0
Fetch 16 0.00 0.00 0 0 0 16
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 33 0.00 0.00 0 0 0 16
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 114 (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FIXED TABLE FULL X$NLS_PARAMETERS (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=31 card=1)
********************************************************************************
SQL ID: d45q8yjz3ah0u Plan Hash: 1805486652
SELECT VALUE
FROM
NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_COMP'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 16 0.00 0.00 0 0 0 0
Fetch 16 0.00 0.00 0 0 0 16
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 33 0.00 0.00 0 0 0 16
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 114 (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FIXED TABLE FULL X$NLS_PARAMETERS (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=31 card=1)
********************************************************************************
SQL ID: 2s9bghg5agn03 Plan Hash: 4291532097
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ P.VALCHAR
FROM
SYS.OPTSTAT_USER_PREFS$ P, OBJ$ O, USER$ U WHERE P.OBJ#=O.OBJ# AND U.USER#=
O.OWNER# AND U.NAME=:B3 AND O.NAME=:B2 AND O.NAMESPACE = 1 AND
O.REMOTEOWNER IS NULL AND O.LINKNAME IS NULL AND O.SUBNAME IS NULL AND
O.TYPE# = 2 AND P.PNAME=:B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 46 0.01 0.01 0 0 0 0
Fetch 46 0.00 0.00 0 276 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 93 0.01 0.01 0 276 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=0 us starts=1 cost=4 size=171 card=1)
0 0 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=0 us starts=1 cost=4 size=171 card=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=111 card=1)(object id 37)
0 0 0 INDEX UNIQUE SCAN I_USER_PREFS$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 681)
0 0 0 TABLE ACCESS BY INDEX ROWID OPTSTAT_USER_PREFS$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=42 card=1)
********************************************************************************
SQL ID: b9nbhsbx8tqz5 Plan Hash: 1097271556
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SPARE4
FROM
SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 56 0.00 0.00 0 0 0 0
Fetch 56 0.00 0.00 0 168 0 56
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 113 0.00 0.00 0 168 0 56
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS FULL OPTSTAT_HIST_CONTROL$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=25 card=1)
********************************************************************************
SQL ID: 5uu6gr69xhk48 Plan Hash: 3095026863
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ T.PROPERTY
FROM
SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T WHERE U.NAME = :B2 AND U.USER# =
O.OWNER# AND O.NAME = :B1 AND O.NAMESPACE = 1 AND O.REMOTEOWNER IS NULL AND
O.LINKNAME IS NULL AND O.SUBNAME IS NULL AND O.TYPE# = 2 AND O.OBJ# =
T.OBJ#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 16 0.00 0.00 0 0 0 0
Fetch 16 0.00 0.00 0 128 0 16
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 33 0.00 0.00 0 128 0 16
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 HASH JOIN (cr=8 pr=0 pw=0 time=1000 us starts=1 cost=4 size=141 card=1)
1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=1000 us starts=1 cost=4 size=141 card=1)
1 1 1 STATISTICS COLLECTOR (cr=5 pr=0 pw=0 time=0 us starts=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=111 card=1)(object id 37)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=1000 us starts=1 cost=1 size=12 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS FULL TAB$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=12 card=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 1 0.00 0.00
********************************************************************************
SQL ID: 8ggw94h7mvxd7 Plan Hash: 0
COMMIT
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 11 0.00 0.00 0 0 0 0
Execute 13 0.00 0.00 0 0 5 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 24 0.00 0.00 0 0 5 0
Misses in library cache during parse: 0
Parsing user id: 114 (recursive depth: 1)
********************************************************************************
SQL ID: b4fqsa2zhnqm8 Plan Hash: 750105498
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ O.NAME
FROM
OBJ$ O, USER$ U WHERE O.OWNER# = U.USER# AND O.OBJ# = (SELECT
SYS_CONTEXT('USERENV', 'BG_JOB_ID') FROM DUAL)
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 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.00 0 0 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us starts=1 cost=4 size=47 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=1 cost=4 size=47 card=1)
0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=1 cost=3 size=43 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=1 cost=2 size=0 card=1)(object id 36)
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us starts=1 cost=2 size=0 card=1)
0 0 0 INDEX RANGE SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=4 card=1)(object id 47)
0 0 0 INDEX FULL SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=4 card=1)(object id 47)
********************************************************************************
SQL ID: 5mgx3qrjw4kn1 Plan Hash: 2973543806
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */
ST_OPR_ID_SEQ.NEXTVAL
FROM
DUAL
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: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SEQUENCE ST_OPR_ID_SEQ (cr=0 pr=0 pw=0 time=0 us starts=1)
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us starts=1 cost=2 size=0 card=1)
********************************************************************************
SQL ID: ddsukg4u01c36 Plan Hash: 0
insert /* QOSH:REC_STS */ into sys.wri$_optstat_opr (id, operation, target,
start_time, end_time, status, job_name, session_id, notes)
values
(:1,:2,:3,:4,:5,:6,:7,:8,:9)
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 8 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 1 8 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL WRI$_OPTSTAT_OPR (cr=1 pr=0 pw=0 time=1000 us starts=1)
********************************************************************************
SQL ID: 3rju5whzbh017 Plan Hash: 3326593961
SELECT /*+ ordered index(u) index(o) index(po)
OPT_PARAM('_parallel_syspls_obey_force' 'false') */ MOD(PO.SPARE2, 256),
PO.PARTTYPE FROM SYS.USER$ U, SYS.OBJ$ O, SYS.PARTOBJ$ PO WHERE U.NAME =
:B3 AND O.NAME = :B2 AND O.NAMESPACE = :B1 AND U.USER# = O.OWNER# AND
O.OBJ# = PO.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.00 0 6 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 6 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=0 us starts=1 cost=4 size=76 card=1)
0 0 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=0 us starts=1 cost=4 size=76 card=1)
1 1 1 HASH JOIN (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=65 card=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=65 card=1)
1 1 1 STATISTICS COLLECTOR (cr=2 pr=0 pw=0 time=0 us starts=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=47 card=1)(object id 37)
0 0 0 INDEX SKIP SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=47 card=1)(object id 37)
0 0 0 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 80)
0 0 0 TABLE ACCESS BY INDEX ROWID PARTOBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=11 card=1)
********************************************************************************
SQL ID: 7gzcdxb9drpf8 Plan Hash: 3179548805
SELECT /*+ leading(u) use_nl_with_index(o)
OPT_PARAM('_parallel_syspls_obey_force' 'false') */ O.OBJ#, O.TYPE# FROM
SYS.USER$ U, SYS.OBJ$ O WHERE U.NAME = :B3 AND O.OWNER# = U.USER# AND
O.NAME = :B2 AND O.NAMESPACE = 1 AND O.REMOTEOWNER IS NULL AND O.LINKNAME
IS NULL AND (O.SUBNAME IS NULL AND :B1 IS NULL OR O.SUBNAME = :B1 ) AND
O.TYPE# IN (2,19,34)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 15 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 15 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=111 card=1)(object id 37)
********************************************************************************
SQL ID: 8xp6fvkdf5878 Plan Hash: 2970138452
SELECT /*+ index(t) OPT_PARAM('_parallel_syspls_obey_force' 'false') */
T.PROPERTY
FROM
SYS.TAB$ T WHERE T.OBJ# = :B1
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: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=12 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: 2wd0su2xk5d3g Plan Hash: 220572989
SELECT /*+ first_rows(1)
OPT_PARAM('_parallel_syspls_obey_force' 'false') */ '"'||OI.NAME||'"' FROM
SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.OBJ$ OI WHERE U.NAME = :B2 AND
OT.OWNER# = U.USER# AND OT.NAME = :B1 AND I.BO# = OT.OBJ# AND I.TYPE# = 4
AND I.OBJ# = OI.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.00 0 10 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 10 0 0
Misses in library cache during parse: 0
Optimizer mode: FIRST_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 HASH JOIN (cr=10 pr=0 pw=0 time=0 us starts=1 cost=6 size=114 card=1)
0 0 0 NESTED LOOPS (cr=10 pr=0 pw=0 time=0 us starts=1 cost=6 size=114 card=1)
0 0 0 NESTED LOOPS (cr=10 pr=0 pw=0 time=0 us starts=1 cost=6 size=114 card=1)
0 0 0 STATISTICS COLLECTOR (cr=10 pr=0 pw=0 time=0 us starts=1)
0 0 0 HASH JOIN (cr=10 pr=0 pw=0 time=0 us starts=1 cost=4 size=74 card=1)
0 0 0 NESTED LOOPS (cr=10 pr=0 pw=0 time=0 us starts=1 cost=4 size=74 card=1)
2 2 2 STATISTICS COLLECTOR (cr=5 pr=0 pw=0 time=0 us starts=1)
2 2 2 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=61 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
2 2 2 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=43 card=1)(object id 37)
0 0 0 TABLE ACCESS CLUSTER IND$ (cr=5 pr=0 pw=0 time=0 us starts=2 cost=1 size=13 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=4 pr=0 pw=0 time=0 us starts=2 cost=0 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED IND$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=13 card=1)
0 0 0 INDEX FULL SCAN I_IND1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 41)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=40 card=1)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=40 card=1)(object id 40)
********************************************************************************
SQL ID: 1fm07xd16u5nr Plan Hash: 0
insert /* QOSH:REC_STS */ into sys.wri$_optstat_opr_tasks (op_id, job_name,
status, start_time, end_time, target, target_type, target_size,
estimated_cost, batching_coeff, actions, priority, notes, flags,
target_objn)
values
(:1,:2,:3,:4,:5,:6,:7, :8,:9,
:10,:11,:12,:13,:14,:15)
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 1 49 4
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.00 0.00 0 1 49 4
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL WRI$_OPTSTAT_OPR_TASKS (cr=1 pr=0 pw=0 time=0 us starts=1)
********************************************************************************
SQL ID: d7bgf84kwj3s7 Plan Hash: 324713838
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ P.VALCHAR
FROM
SYS.OPTSTAT_USER_PREFS$ P WHERE P.OBJ#=:B2 AND P.PNAME=:B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 6 0.00 0.00 0 6 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 13 0.00 0.00 0 6 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS BY INDEX ROWID OPTSTAT_USER_PREFS$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=1 size=42 card=1)
0 0 0 INDEX UNIQUE SCAN I_USER_PREFS$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 681)
********************************************************************************
SQL ID: 5j3ram21g5s8r Plan Hash: 2507555410
SELECT /*+ ordered use_nl(o c cu h) index(u i_user1) index(o i_obj2)
index(ci_obj#) index(cu i_col_usage$)
index(h
i_hh_obj#_intcol#)
OPT_PARAM('_parallel_syspls_obey_force'
'false') */ C.NAME COL_NAME, C.TYPE# COL_TYPE, C.CHARSETFORM COL_CSF, CASE
WHEN C.DEFLENGTH <= 32767 THEN C.DEFAULT$ ELSE NULL END COL_DEF, C.NULL$
COL_NULL, C.PROPERTY COL_PROP, C.COL# COL_UNUM, C.INTCOL# COL_INUM, C.OBJ#
COL_OBJ, C.SCALE COL_SCALE, CASE WHEN NVL(H.DISTCNT,0) = 0 OR H.ROW_CNT = 0
THEN -4 WHEN EXISTS(SELECT 1 FROM SYS.HISTGRM$ HG WHERE T.OBJ# = HG.OBJ#
AND H.INTCOL# = HG.INTCOL# AND HG.EP_REPEAT_COUNT > 0 AND ROWNUM < 2) THEN
H.ROW_CNT WHEN BITAND(H.SPARE2, 64) > 0 THEN H.ROW_CNT WHEN
(BITAND(H.SPARE2, 32) > 0 OR H.BUCKET_CNT > 2049 OR (H.BUCKET_CNT >=
H.DISTCNT AND H.DENSITY*H.BUCKET_CNT < 1)) THEN H.ROW_CNT ELSE H.BUCKET_CNT
END H_BCNT, (T.ROWCNT-H.NULL_CNT)/GREATEST(H.DISTCNT,1) H_PFREQ, C.LENGTH
COL_LEN, CU.TIMESTAMP CU_TIME, CU.EQUALITY_PREDS CU_EP, CU.EQUIJOIN_PREDS
CU_EJP, CU.RANGE_PREDS CU_RP, CU.LIKE_PREDS CU_LP, CU.NONEQUIJOIN_PREDS
CU_NEJP, CU.NULL_PREDS CU_NP FROM SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T,
SYS.COL$ C, SYS.COL_USAGE$ CU, SYS.HIST_HEAD$ H WHERE :B3 = '0' AND U.NAME =
:B2 AND O.OWNER# = U.USER# AND O.TYPE# = 2 AND O.NAME = :B1 AND O.OBJ# =
T.OBJ# AND O.OBJ# = C.OBJ# AND C.OBJ# = CU.OBJ#(+) AND C.INTCOL# =
CU.INTCOL#(+) AND C.OBJ# = H.OBJ#(+) AND C.INTCOL# = H.INTCOL#(+) UNION ALL
SELECT /*+ ordered use_nl(c) */ C.KQFCONAM COL_NAME, C.KQFCODTY COL_TYPE,
DECODE(C.KQFCODTY, 1, 1, 0) COL_CSF, NULL COL_DEF, 0 COL_NULL, 0 COL_PROP,
C.KQFCOCNO COL_UNUM, C.KQFCOCNO COL_INUM, O.KQFTAOBJ COL_OBJ,
DECODE(C.KQFCODTY, 2, -127, 0) COL_SCALE, H.BUCKET_CNT H_BCNT,
(ST.ROWCNT-NULL_CNT)/GREATEST(H.DISTCNT,1) H_PFREQ, DECODE(C.KQFCODTY, 2,
22, C.KQFCOSIZ) COL_LEN, CU.TIMESTAMP CU_TIME, CU.EQUALITY_PREDS CU_EP,
CU.EQUIJOIN_PREDS CU_EJP, CU.RANGE_PREDS CU_RP, CU.LIKE_PREDS CU_LP,
CU.NONEQUIJOIN_PREDS CU_NEJP, CU.NULL_PREDS CU_NP FROM SYS.X$KQFTA O,
SYS.TAB_STATS$ ST, SYS.X$KQFCO C, SYS.COL_USAGE$ CU, SYS.HIST_HEAD$ H WHERE
:B3 != '0' AND :B2 = 'SYS' AND O.KQFTANAM = :B1 AND O.KQFTAOBJ = ST.OBJ#(+)
AND O.KQFTAOBJ = C.KQFCOTOB AND C.KQFCOTOB = CU.OBJ#(+) AND C.KQFCOCNO =
CU.INTCOL#(+) AND C.KQFCOTOB = H.OBJ#(+) AND C.KQFCOCNO = H.INTCOL#(+)
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 0 48 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.00 0 48 0 6
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
3 3 3 UNION-ALL (cr=24 pr=0 pw=0 time=0 us starts=1)
0 0 0 COUNT STOPKEY (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 TABLE ACCESS CLUSTER HISTGRM$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=11 card=1)
0 0 0 INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 65)
3 3 3 FILTER (cr=24 pr=0 pw=0 time=0 us starts=1)
3 3 3 NESTED LOOPS OUTER (cr=24 pr=0 pw=0 time=0 us starts=1 cost=8 size=184 card=1)
3 3 3 NESTED LOOPS OUTER (cr=18 pr=0 pw=0 time=0 us starts=1 cost=6 size=154 card=1)
3 3 3 NESTED LOOPS (cr=11 pr=0 pw=0 time=0 us starts=1 cost=5 size=121 card=1)
1 1 1 HASH JOIN (cr=8 pr=0 pw=0 time=0 us starts=1 cost=4 size=73 card=1)
1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=0 us starts=1 cost=4 size=73 card=1)
1 1 1 STATISTICS COLLECTOR (cr=5 pr=0 pw=0 time=0 us starts=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=65 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=47 card=1)(object id 37)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=1 size=8 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS FULL TAB$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=8 card=1)
3 3 3 TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=1 size=576 card=12)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 3)
2 2 2 TABLE ACCESS BY INDEX ROWID COL_USAGE$ (cr=7 pr=0 pw=0 time=0 us starts=3 cost=1 size=33 card=1)
2 2 2 INDEX UNIQUE SCAN I_COL_USAGE$ (cr=5 pr=0 pw=0 time=0 us starts=3 cost=0 size=0 card=1)(object id 655)
3 3 3 TABLE ACCESS BY INDEX ROWID BATCHED HIST_HEAD$ (cr=6 pr=0 pw=0 time=0 us starts=3 cost=2 size=30 card=1)
3 3 3 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=5 pr=0 pw=0 time=0 us starts=3 cost=1 size=0 card=1)(object id 70)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 HASH JOIN OUTER (cr=0 pr=0 pw=0 time=0 us starts=0 cost=40 size=1904 card=17)
0 0 0 NESTED LOOPS OUTER (cr=0 pr=0 pw=0 time=0 us starts=0 cost=40 size=1904 card=17)
0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 HASH JOIN OUTER (cr=0 pr=0 pw=0 time=0 us starts=0 cost=6 size=1581 card=17)
0 0 0 NESTED LOOPS OUTER (cr=0 pr=0 pw=0 time=0 us starts=0 cost=6 size=1581 card=17)
0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=3 size=1020 card=17)
0 0 0 HASH JOIN OUTER (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=30 card=1)
0 0 0 NESTED LOOPS OUTER (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=30 card=1)
0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 FIXED TABLE FULL X$KQFTA (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=20 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=10 card=1)
0 0 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 74)
0 0 0 TABLE ACCESS FULL TAB_STATS$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=10 card=1)
0 0 0 FIXED TABLE FULL X$KQFCO (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=510 card=17)
0 0 0 TABLE ACCESS BY INDEX ROWID COL_USAGE$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=33 card=1)
0 0 0 INDEX UNIQUE SCAN I_COL_USAGE$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 655)
0 0 0 TABLE ACCESS FULL COL_USAGE$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=33 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED HIST_HEAD$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=19 card=1)
0 0 0 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 70)
0 0 0 TABLE ACCESS FULL HIST_HEAD$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=19 card=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 1 0.00 0.00
********************************************************************************
SQL ID: 7azxftvubufnj Plan Hash: 2456673777
SELECT COUNT(UNQ) UNQ, COUNT(PFX) PFX FROM (SELECT /*+ first_rows(1)
leading(cc)
OPT_PARAM('_parallel_syspls_obey_force'
'false') */ CD.TYPE# UNQ, NULL PFX FROM SYS.CCOL$ CC, SYS.CDEF$ CD WHERE
CC.OBJ# = :B2 AND CC.INTCOL# = :B1 AND CD.CON# = CC.CON# AND CD.OBJ# =
CC.OBJ# AND CD.ENABLED IS NOT NULL AND CD.INTCOLS = 1 AND CD.TYPE# IN (2,3)
AND BITAND(CD.DEFER, 2+4) = 4 AND ROWNUM < 2 UNION ALL SELECT /*+
first_rows(1) leading(i) */ CASE WHEN I.INTCOLS = 1 AND BITAND(I.PROPERTY,1)
= 1 THEN 3 ELSE NULL END UNQ, CASE WHEN IC.POS# = 1 THEN 1 ELSE NULL END
PFX FROM SYS.IND$ I, SYS.ICOL$ IC WHERE I.BO# = :B2 AND I.BO# = IC.BO# AND
IC.INTCOL# = :B1 AND I.OBJ# = IC.OBJ# AND BITAND(I.FLAGS,1025) = 0 AND
ROWNUM < 2 )
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 6 0.00 0.00 0 0 0 0
Fetch 6 0.00 0.00 0 70 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 13 0.00 0.00 0 70 0 6
Misses in library cache during parse: 0
Optimizer mode: FIRST_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=13 pr=0 pw=0 time=1000 us starts=1)
2 2 2 VIEW (cr=13 pr=0 pw=0 time=1000 us starts=1 cost=7 size=32 card=2)
2 2 2 UNION-ALL (cr=13 pr=0 pw=0 time=1000 us starts=1)
1 1 1 COUNT STOPKEY (cr=7 pr=0 pw=0 time=0 us starts=1)
1 1 1 HASH JOIN (cr=7 pr=0 pw=0 time=0 us starts=1 cost=3 size=35 card=1)
1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=0 us starts=1 cost=3 size=35 card=1)
2 2 2 STATISTICS COLLECTOR (cr=3 pr=0 pw=0 time=0 us starts=1)
2 2 2 TABLE ACCESS CLUSTER CCOL$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=13 card=1)
1 1 1 INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 30)
1 1 1 TABLE ACCESS CLUSTER CDEF$ (cr=4 pr=0 pw=0 time=0 us starts=2 cost=1 size=22 card=1)
0 0 0 TABLE ACCESS CLUSTER CDEF$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=22 card=1)
0 0 0 INDEX UNIQUE SCAN I_COBJ# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 30)
1 1 1 COUNT STOPKEY (cr=6 pr=0 pw=0 time=1000 us starts=1)
1 1 1 HASH JOIN (cr=6 pr=0 pw=0 time=1000 us starts=1 cost=4 size=38 card=1)
3 3 3 NESTED LOOPS (cr=3 pr=0 pw=0 time=0 us starts=1 cost=4 size=38 card=1)
3 3 3 STATISTICS COLLECTOR (cr=3 pr=0 pw=0 time=0 us starts=1)
3 3 3 TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=63 card=3)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS CLUSTER ICOL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=17 card=1)
0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 3)
1 1 1 TABLE ACCESS CLUSTER ICOL$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=17 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 3)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 11 0.00 0.00
********************************************************************************
SQL ID: 62yyzw3309d6a Plan Hash: 2667441017
SELECT VALUE
FROM
V$SESSION_FIX_CONTROL WHERE BUGNO = :B1 AND SESSION_ID = USERENV('SID')
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 27 0.00 0.00 0 0 0 0
Fetch 27 0.00 0.00 0 0 0 27
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 55 0.00 0.00 0 0 0 27
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 FIXED TABLE FIXED INDEX X$QKSBGSES (ind:1) (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=15 card=1)
********************************************************************************
SQL ID: cpktjtz97gsjn Plan Hash: 1978163079
select /* KSXM:FLUSH DML_MON */ type#
from
obj$ where obj# = :pobjn
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 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=9 card=1)(object id 36)
********************************************************************************
SQL ID: fc054jsw0dcmu Plan Hash: 1945975270
select /* KSXM:FLUSH DML_MON */ obj#
from
( select obj#, 2 type from tab$ where obj#
= :pobjn and :type = 2 /*A*/ union all
select obj#, 19 type from tabpart$
where obj# = :pobjn and :type = 19 /*B*/ union all
select bo#, 2 type from
tabpart$ where obj# = :pobjn and :type = 19 /*C*/ union all
select obj#, 19
type from tabpart$ where bo# = :pobjn and :type = 2 /*D*/ union all
select obj#,
34 type from tabsubpart$ /*E*/ where
obj# = :pobjn and :type = 34 union
all
select pobj#, 19 type from tabsubpart$
/*F*/ where obj# = :pobjn and :type = 34
union all
select /*+ leading(tsp) use_nl(tcp) index(tsp) index(tcp) */
/*G*/ tcp.bo#, 2 type
from tabsubpart$ tsp, tabcompart$ tcp
where tsp.pobj# = tcp.obj# and tsp.obj# = :pobjn and
:type = 34 union all
select obj#, 19 type from tabcompart$
/*H*/ where obj# = :pobjn and :type = 19
union all
select obj#, 34 type from tabsubpart$
/*I*/ where pobj# = :pobjn and :type = 19
union all
select bo#, 2 type from tabcompart$
where obj# = :pobjn and :type = 19 /*J*/ union all
select /*+ leading(tcp)
use_nl(tsp) index(tsp) index(tcp) */ /*K*/ tsp.obj#, 34 type
from tabsubpart$
tsp, tabcompart$ tcp where tsp.pobj#
= tcp.obj# and tcp.bo# = :pobjn and :type = 2 union all
select obj#,
19 type from tabcompart$ where bo# = :pobjn and :type = 2 /*L*/ ) order by
type desc
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 9 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 9 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT ORDER BY (cr=9 pr=0 pw=0 time=0 us starts=1 cost=23 size=576 card=36)
1 1 1 VIEW (cr=9 pr=0 pw=0 time=0 us starts=1 cost=22 size=576 card=36)
1 1 1 UNION-ALL (cr=9 pr=0 pw=0 time=0 us starts=1)
1 1 1 FILTER (cr=3 pr=0 pw=0 time=0 us starts=1)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=5 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 3)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 INDEX UNIQUE SCAN I_TABPART_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=5 card=1)(object id 799)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 TABLE ACCESS BY INDEX ROWID TABPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=10 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABPART_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 799)
0 0 0 FILTER (cr=2 pr=0 pw=0 time=0 us starts=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED TABPART$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=5 size=50 card=5)
0 0 0 INDEX RANGE SCAN I_TABPART_BOPART$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=0 card=5)(object id 798)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 INDEX UNIQUE SCAN I_TABSUBPART$_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=5 card=1)(object id 811)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 TABLE ACCESS BY INDEX ROWID TABSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=10 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABSUBPART$_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 811)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=20 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID TABSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=10 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABSUBPART$_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 811)
0 0 0 TABLE ACCESS BY INDEX ROWID TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=10 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 821)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 INDEX UNIQUE SCAN I_TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=5 card=1)(object id 821)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 TABLE ACCESS FULL TABSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=110 card=11)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 TABLE ACCESS BY INDEX ROWID TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=10 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 821)
0 0 0 FILTER (cr=1 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=0 us starts=1 cost=4 size=220 card=11)
0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=0 us starts=1 cost=4 size=220 card=11)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED TABCOMPART$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=2 size=10 card=1)
0 0 0 INDEX RANGE SCAN I_TABCOMPART_BOPART$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 820)
0 0 0 INDEX RANGE SCAN I_TABSUBPART_POBJSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=11)(object id 810)
0 0 0 TABLE ACCESS BY INDEX ROWID TABSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=110 card=11)
0 0 0 FILTER (cr=3 pr=0 pw=0 time=0 us starts=1)
0 0 0 TABLE ACCESS FULL TABCOMPART$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=10 card=1)
********************************************************************************
SQL ID: 4p9b90fawtgjc Plan Hash: 3179548805
SELECT O.OBJ#
FROM
OBJ$ O, USER$ U WHERE O.OWNER# = U.USER# AND U.NAME = :B2 AND O.NAME = :B1
AND O.SUBNAME IS NULL AND O.TYPE# = 2
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 0 10 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.00 0 10 0 2
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=67 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=49 card=1)(object id 37)
********************************************************************************
SQL ID: cy0mgyw1a6bg0 Plan Hash: 2710014632
SELECT /*+ leading(u o)
OPT_PARAM('_parallel_syspls_obey_force' 'false') */ O.SUBNAME PART_NAME,
O.OBJ# OBJ_NUM FROM SYS.USER$ U, SYS.OBJ$ O, SYS.TABPART$ TP,
SYS.TABCOMPART$ TCP WHERE :B3 IS NULL AND U.NAME = :B2 AND O.OWNER# =
U.USER# AND O.NAME = :B1 AND O.NAMESPACE = 1 AND O.REMOTEOWNER IS NULL AND
O.LINKNAME IS NULL AND O.TYPE# = 19 AND O.OBJ# = TP.OBJ#(+) AND O.OBJ# =
TCP.OBJ#(+) UNION ALL SELECT * FROM ( SELECT /*+ leading(u o) */ O.SUBNAME
PART_NAME, O.OBJ# OBJ_NUM FROM SYS.USER$ U, SYS.OBJ$ O WHERE U.NAME = :B2
AND O.OWNER# = U.USER# AND O.NAME = :B1 AND O.NAMESPACE = 1 AND
O.REMOTEOWNER IS NULL AND O.LINKNAME IS NULL AND O.SUBNAME = :B3 AND
O.TYPE# = 19 UNION ALL SELECT /*+ leading(u osp tsp) */ OP.SUBNAME
PART_NAME, OP.OBJ# OBJ_NUM FROM SYS.USER$ U, SYS.OBJ$ OSP, SYS.TABSUBPART$
TSP, SYS.OBJ$ OP WHERE U.NAME = :B2 AND OSP.OWNER# = U.USER# AND OSP.NAME =
:B1 AND OSP.NAMESPACE = 1 AND OSP.REMOTEOWNER IS NULL AND OSP.LINKNAME IS
NULL AND OSP.SUBNAME = :B3 AND OSP.TYPE# = 34 AND OSP.OBJ# = TSP.OBJ# AND
OP.OBJ# = TSP.POBJ# ) WHERE ROWNUM < 2 UNION ALL SELECT NULL PART_NAME,
NULL OBJ_NUM FROM SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T WHERE :B4 = 'y' AND
U.NAME = :B2 AND O.OWNER# = U.USER# AND O.NAME = :B1 AND O.TYPE# = 2 AND
T.OBJ# = O.OBJ# AND BITAND(T.PROPERTY, 32) <> 32
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 9 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 9 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UNION-ALL (cr=9 pr=0 pw=0 time=0 us starts=1)
0 0 0 FILTER (cr=5 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=111 card=1)(object id 37)
0 0 0 COUNT STOPKEY (cr=4 pr=0 pw=0 time=0 us starts=1)
0 0 0 VIEW (cr=4 pr=0 pw=0 time=0 us starts=1 cost=7 size=158 card=2)
0 0 0 UNION-ALL (cr=4 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=1 cost=1 size=111 card=1)(object id 37)
0 0 0 HASH JOIN (cr=2 pr=0 pw=0 time=0 us starts=1 cost=5 size=146 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=5 size=146 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=5 size=146 card=1)
0 0 0 STATISTICS COLLECTOR (cr=2 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=3 size=139 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=1 cost=1 size=111 card=1)(object id 37)
0 0 0 TABLE ACCESS BY INDEX ROWID TABSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=10 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABSUBPART$_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 811)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=7 card=1)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=7 card=1)(object id 40)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 HASH JOIN (cr=0 pr=0 pw=0 time=0 us starts=0 cost=4 size=77 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=4 size=77 card=1)
0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=3 size=65 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
0 0 0 INDEX UNIQUE SCAN I_USER1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 46)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=47 card=1)(object id 37)
0 0 0 TABLE ACCESS CLUSTER TAB$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=12 card=1)
0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS FULL TAB$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=12 card=1)
********************************************************************************
SQL ID: g9xgz7a9xz7yv Plan Hash: 3095026863
SELECT /*+ use_nl(u,o,t) OPT_PARAM('_parallel_syspls_obey_force' 'false') */
NVL(T.DEGREE,1)
FROM
USER$ U,OBJ$ O,TAB$ T WHERE U.NAME=:B2 AND O.NAME=:B1 AND O.OBJ#=T.OBJ# AND
U.USER#=O.OWNER#
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 10 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 10 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 NESTED LOOPS (cr=10 pr=0 pw=0 time=0 us starts=1 cost=4 size=68 card=1)
2 2 2 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=61 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
2 2 2 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=43 card=1)(object id 37)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=5 pr=0 pw=0 time=0 us starts=2 cost=1 size=7 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=4 pr=0 pw=0 time=0 us starts=2 cost=0 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: cb21bacyh3c7d Plan Hash: 3452538079
select metadata
from
kopm$ where name='DB_FDO'
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 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 1
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS BY INDEX ROWID KOPM$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=108 card=1)
1 1 1 INDEX UNIQUE SCAN I_KOPM1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 774)
********************************************************************************
SQL ID: 9us3squgdwcxm Plan Hash: 2860568089
select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats
cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring
xmlindex_sel_idx_tbl opt_param('optimizer_inmemory_aware' 'false')
no_substrb_pad */to_char(count("ORDID")),substrb(dump(min("ORDID"),16,0,64)
,1,240),substrb(dump(max("ORDID"),16,0,64),1,240),
to_char(count("CATEGORYID")),substrb(dump(min("CATEGORYID"),16,0,64),1,240),
substrb(dump(max("CATEGORYID"),16,0,64),1,240),to_char(count("STATUS")),
substrb(dump(min("STATUS"),16,0,64),1,240),substrb(dump(max("STATUS"),16,0,
64),1,240),count(rowidtochar(rowid))
from
"U"."ORDS" t /* ACL,NIL,NIL,TOPN,NIL,NIL,TOPN,NIL,NIL,RWID,U254,U254,
U254U*/
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 38 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.01 0.01 0 38 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 114 (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=38 pr=0 pw=0 time=8999 us starts=1)
10000 10000 10000 OPTIMIZER STATISTICS GATHERING (cr=38 pr=0 pw=0 time=127569 us starts=1 cost=11 size=170000 card=10000)
10000 10000 10000 TABLE ACCESS FULL ORDS (cr=38 pr=0 pw=0 time=0 us starts=1 cost=11 size=170000 card=10000)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 8 0.00 0.00
********************************************************************************
SQL ID: 3qkhfbf2kyvhk Plan Hash: 1268306204
SELECT POS+1 POS, VAL, NONNULLS, NDV, SPLIT, RSIZE, ROWCNT, TOPNCNT, TOPN,
NULL MINFREQ, NULL MAXFREQ, NULL AVGFREQ, NULL STDDEVFREQ
FROM
XMLTABLE( '/process_result/select_list_item' PASSING :B1 COLUMNS POS NUMBER
PATH 'pos', VAL VARCHAR2(240) PATH 'value', NONNULLS NUMBER PATH 'nonnulls',
NDV NUMBER PATH 'ndv', SPLIT NUMBER PATH 'split', RSIZE NUMBER PATH
'rsize', ROWCNT NUMBER PATH 'rowcnt', TOPNCNT NUMBER PATH 'topncnt', TOPN
CLOB PATH 'topn_values' ) ORDER BY TOPNCNT DESC
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.04 0 0 0 0
Fetch 1 0.00 0.01 0 0 0 9
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.05 0 0 0 9
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 114 (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
9 9 9 SORT ORDER BY (cr=0 pr=0 pw=0 time=47994 us starts=1 cost=30 size=147024 card=8168)
9 9 9 XMLTABLE EVALUATION (cr=0 pr=0 pw=0 time=54987 us starts=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 26 0.00 0.00
acknowledge over PGA limit 5 0.01 0.05
********************************************************************************
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl opt_param('optimizer_inmemory_aware' 'false') no_substrb_pad */ substrb(dump("STATUS",16,0,64),1,240) val,
rowidtochar(rowid) rwid from "U"."ORDS" t where rowid in (chartorowid('AAAWt1AAHAAAAFjAAA'),chartorowid('AAAWt1AAHAAAAGCAAv')) order by "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 0 2 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 2 0 2
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 114 (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
2 2 2 SORT ORDER BY (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=17 card=1)
2 2 2 INLIST ITERATOR (cr=2 pr=0 pw=0 time=0 us starts=1)
2 2 2 TABLE ACCESS BY USER ROWID ORDS (cr=2 pr=0 pw=0 time=0 us starts=2 cost=1 size=17 card=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 1 0.00 0.00
********************************************************************************
SQL ID: 87gaftwrm2h68 Plan Hash: 1072382624
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 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 4 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.00 0 4 0 0
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=3 size=111 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=0 card=1)(object id 36)
********************************************************************************
SQL ID: a5qrn8rku8sbq Plan Hash: 2559119735
select substrb(dump(val,16,0,64),1,240) ep, freq, cdn, ndv, (sum(pop) over())
popcnt, (sum(pop*freq) over()) popfreq, substrb(dump(max(val) over(),16,
0,64),1,240) maxval, substrb(dump(min(val) over(),16,0,64),1,240) minval
from
(select val, freq, (sum(freq) over()) cdn, (count(*) over()) ndv, (case
when freq > ((sum(freq) over())/254) then 1 else 0 end) pop from (select
/*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact
use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl
opt_param('optimizer_inmemory_aware' 'false') no_substrb_pad */
"CATEGORYID" val, count("CATEGORYID") freq from "U"."ORDS" t where
"CATEGORYID" is not null group by "CATEGORYID")) order by val
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.02 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1001 0.02 0.01 0 27 0 1000
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1003 0.02 0.04 0 27 0 1000
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 114 (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1000 1000 1000 WINDOW SORT (cr=27 pr=0 pw=0 time=6999 us starts=1 cost=8 size=46000 card=1000)
1000 1000 1000 VIEW (cr=27 pr=0 pw=0 time=4999 us starts=1 cost=8 size=46000 card=1000)
1000 1000 1000 WINDOW BUFFER (cr=27 pr=0 pw=0 time=4999 us starts=1 cost=8 size=4000 card=1000)
1000 1000 1000 HASH GROUP BY (cr=27 pr=0 pw=0 time=4000 us starts=1 cost=8 size=4000 card=1000)
10000 10000 10000 INDEX FAST FULL SCAN CATEGORY_IDX (cr=27 pr=0 pw=0 time=0 us starts=1 cost=7 size=40000 card=10000)(object id 93047)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 8 0.00 0.00
acknowledge over PGA limit 2 0.01 0.02
********************************************************************************
SQL ID: 5s8s8wkv7kwpf Plan Hash: 2079990838
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ COUNT(*)
FROM
SYS.EXTERNAL_TAB$ WHERE OBJ# = :B1 AND TYPE$ IN ('ORACLE_HIVE',
'ORACLE_HDFS', 'ORACLE_BIGDATA')
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 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 1 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=1 pr=0 pw=0 time=0 us starts=1)
0 0 0 TABLE ACCESS BY INDEX ROWID EXTERNAL_TAB$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=1 size=19 card=1)
0 0 0 INDEX UNIQUE SCAN I_EXTERNAL_TAB1$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 1377)
********************************************************************************
SQL ID: 45019qrb7da32 Plan Hash: 4066817437
SELECT /*+ ordered index(u) index(o)
OPT_PARAM('_parallel_syspls_obey_force' 'false') */ COUNT(*) FROM USER$ U,
OBJ$ O WHERE U.NAME = :B4 AND O.OWNER# = U.USER# AND O.NAME = :B3 AND
O.NAMESPACE = :B2 AND O.REMOTEOWNER IS NULL AND O.LINKNAME IS NULL AND
O.SUBNAME IS NULL AND O.TYPE# = :B1 AND ROWNUM < 2
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 0 40 0 8
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 17 0.00 0.00 0 40 0 8
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=5 pr=0 pw=0 time=1000 us starts=1)
1 1 1 COUNT STOPKEY (cr=5 pr=0 pw=0 time=0 us starts=1)
1 1 1 HASH JOIN (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=129 card=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=129 card=1)
1 1 1 STATISTICS COLLECTOR (cr=2 pr=0 pw=0 time=0 us starts=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=111 card=1)(object id 37)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=111 card=1)
0 0 0 INDEX SKIP SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=0 card=1)(object id 36)
********************************************************************************
SQL ID: c8h20n1d0k95m Plan Hash: 1097271556
select /*+ no_parallel */ spare4
from
sys.optstat_hist_control$ where sname=: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 0 18 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 18 0.00 0.00 0 18 0 6
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 TABLE ACCESS FULL OPTSTAT_HIST_CONTROL$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=25 card=1)
********************************************************************************
SQL ID: 30rhvh0fq7jaj Plan Hash: 0
insert /* QOSH:SAVE_STAS */ into sys.wri$_optstat_tab_history(obj#, rowcnt,
blkcnt,avgrln, analyzetime,samplesize,cachedblk,cachehit,logicalread,
savtime,spare1, im_imcu_count,im_block_count,scanrate,flags)
values
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)
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 8 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 1 8 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL WRI$_OPTSTAT_TAB_HISTORY (cr=1 pr=0 pw=0 time=0 us starts=1)
********************************************************************************
SQL ID: gsfnqdfcvy33q Plan Hash: 2453887050
delete from superobj$
where
subobj# = :1
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 4 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.00 0.00 0 4 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE SUPEROBJ$ (cr=1 pr=0 pw=0 time=0 us starts=1)
0 0 0 INDEX UNIQUE SCAN I_SUPEROBJ1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=26 card=1)(object id 98)
********************************************************************************
SQL ID: 3kywng531fcxu Plan Hash: 2667651180
delete from tab_stats$
where
obj#=:1
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 8 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8 0.00 0.00 0 8 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 DELETE TAB_STATS$ (cr=2 pr=0 pw=0 time=0 us starts=1)
0 0 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=7 card=1)(object id 74)
********************************************************************************
SQL ID: gxm18860ab67a Plan Hash: 2918346288
update tab$ set ts#=:2,file#=:3,block#=:4,bobj#=decode(:5,0,null,:5),tab#=
decode(:6,0,null,:6),intcols=:7,kernelcols=:8,clucols=decode(:9,0,null,:9),
audit$=:10,flags=:11,pctfree$=:12,pctused$=:13,initrans=:14,maxtrans=:15,
rowcnt=:16,blkcnt=:17,empcnt=:18,avgspc=:19,chncnt=:20,avgrln=:21,
analyzetime=:22,samplesize=:23,cols=:24,property=:25,degree=decode(:26,1,
null,:26),instances=decode(:27,1,null,:27),dataobj#=:28,avgspc_flb=:29,
flbcnt=:30,trigflag=:31,spare1=:32,spare2=decode(:33,0,null,:33),spare4=:34,
spare6=:35,acdrflags=decode(:36,0,null,:36),acdrtsobj#=decode(:37,0,null,
:37),acdrdefaulttime=:38,acdrrowtsintcol#=:39
where
obj#=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 4 0.00 0.00 0 12 4 4
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.00 0 12 4 4
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UPDATE TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=138 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: ft7wcqu3hzvca Plan Hash: 3466694530
insert /* QOSH:OPEN_COL_STATS */ into sys.wri$_optstat_histhead_history
(obj#,intcol#,savtime,flags, null_cnt,minimum,maximum,distcnt,density,
lowval,hival,avgcln,sample_distcnt, sample_size,timestamp#,colname,
minimum_enc,maximum_enc) select h.obj#, h.intcol#, :3, bitand(h.spare2, 7)
+ 8 + decode(h.cache_cnt,0,0,64) + decode(bitand(h.spare2, 8), 0, 0, 128)
+ decode(bitand(h.spare2, 16), 0, 0, 1024) + decode(bitand(h.spare2,
32), 0, 0, 4096) + decode(bitand(h.spare2, 64), 0, 0, 8192) +
decode(bitand(h.spare2, 128), 0, 0, 16384) + decode(bitand(h.spare2, 256)
, 0, 0, 65536) + decode(bitand(h.spare2, 512), 0, 0, 131072) +
decode(bitand(h.spare2, 1024), 0, 0, 262144) + decode(bitand(h.spare2,
2048), 0, 0, 524288), h.null_cnt, h.minimum, h.maximum, h.distcnt,
h.density, h.lowval, h.hival, h.avgcln, h.spare1, h.sample_size,
h.timestamp#, :4, h.minimum_enc, h.maximum_enc from sys.hist_head$ h where
h.obj# = :1 and h.intcol# = :2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 10 24 3
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 10 24 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL WRI$_OPTSTAT_HISTHEAD_HISTORY (cr=4 pr=0 pw=0 time=0 us starts=1)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED HIST_HEAD$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=52 card=1)
1 1 1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 70)
********************************************************************************
SQL ID: dcs9a27q4mb39 Plan Hash: 0
insert /* QOSH:OPEN_COL_STATS */ into sys.wri$_optstat_histhead_history
(obj#,intcol#,flags,expression,colname,savtime)
values
(:1, :2, :3, :4, :5, :6)
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: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: du1vfy7c7zvf2 Plan Hash: 0
insert /* QOSH:OPEN_COL_STATS */ into sys.wri$_optstat_histgrm_history (obj#,
intcol#,savtime,bucket, endpoint,epvalue,colname,epvalue_raw,
ep_repeat_count,endpoint_enc) select hg.obj#,hg.intcol#,:3,hg.bucket,
hg.endpoint,hg.epvalue, :4, hg.epvalue_raw, hg.ep_repeat_count,
hg.endpoint_enc from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# =
:2
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: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
********************************************************************************
SQL ID: 6t9k34zjqr6yb Plan Hash: 1774962091
update hist_head$ set bucket_cnt=:3, row_cnt=:4, cache_cnt=:5,null_cnt=:6,
timestamp#=:7, sample_size=:8, minimum=:9, maximum=:10,distcnt=:11, lowval=
:12, hival=:13, density=:14, spare1=:15, spare2=:16, avgcln=:17, col#=:18,
minimum_enc=:19, maximum_enc=:20
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 3 0.00 0.00 0 6 3 3
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 6 3 3
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UPDATE HIST_HEAD$ (cr=2 pr=0 pw=0 time=0 us starts=1)
1 1 1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=52 card=1)(object id 70)
********************************************************************************
SQL ID: 34rznuxy8h2a4 Plan Hash: 0
insert into histgrm$(obj#,intcol#,row#,bucket,endpoint,col#,epvalue_raw,
ep_repeat_count,endpoint_enc)
values
(:1,:2,:3,:4,:5,:6,:7,:8,:9)
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 5 21 2
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 5 21 2
Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL HISTGRM$ (cr=5 pr=0 pw=0 time=1000 us starts=1)
********************************************************************************
SQL ID: 50kcsz2gh1w84 Plan Hash: 2616421621
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SU.NAME,
SO.NAME, A.STATSTYPE#, A.INTCOL#
FROM
ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU WHERE O.OWNER#=
U.USER# AND A.OBJ#=O.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=A.INTCOL# AND
A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.NAMESPACE = 1 AND
O.REMOTEOWNER IS NULL AND O.LINKNAME IS NULL AND O.SUBNAME IS NULL AND
O.TYPE#=2 AND U.NAME=:B3 AND O.NAME=:B2 AND C.NAME=:B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 69 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 69 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 HASH JOIN (cr=23 pr=0 pw=0 time=0 us starts=1 cost=6 size=250 card=1)
0 0 0 NESTED LOOPS (cr=23 pr=0 pw=0 time=0 us starts=1 cost=6 size=250 card=1)
0 0 0 NESTED LOOPS (cr=23 pr=0 pw=0 time=0 us starts=1 cost=6 size=250 card=1)
0 0 0 STATISTICS COLLECTOR (cr=23 pr=0 pw=0 time=0 us starts=1)
0 0 0 HASH JOIN (cr=23 pr=0 pw=0 time=0 us starts=1 cost=5 size=229 card=1)
0 0 0 NESTED LOOPS (cr=23 pr=0 pw=0 time=0 us starts=1 cost=5 size=229 card=1)
0 0 0 STATISTICS COLLECTOR (cr=23 pr=0 pw=0 time=0 us starts=1)
0 0 0 HASH JOIN (cr=23 pr=0 pw=0 time=0 us starts=1 cost=4 size=211 card=1)
0 0 0 NESTED LOOPS (cr=23 pr=0 pw=0 time=0 us starts=1 cost=4 size=211 card=1)
0 0 0 STATISTICS COLLECTOR (cr=23 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS (cr=23 pr=0 pw=0 time=0 us starts=1 cost=3 size=168 card=1)
16 16 16 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=57 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
16 16 16 TABLE ACCESS FULL ASSOCIATION$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=39 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=18 pr=0 pw=0 time=0 us starts=16 cost=0 size=111 card=1)
0 0 0 INDEX UNIQUE SCAN I_OBJ1 (cr=18 pr=0 pw=0 time=0 us starts=16 cost=0 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=43 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=43 card=1)(object id 40)
0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 11)
0 0 0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
0 0 0 INDEX UNIQUE SCAN I_COL3 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 50)
0 0 0 TABLE ACCESS BY INDEX ROWID COL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=21 card=1)
0 0 0 TABLE ACCESS FULL COL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=21 card=1)
********************************************************************************
SQL ID: dp0vgyb1hsfjb Plan Hash: 1662056740
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SU.NAME,
SO.NAME, A.STATSTYPE#, C.INTCOL#
FROM
ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT,
OBJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND
C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OID$ AND
A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.NAMESPACE = 1 AND
O.REMOTEOWNER IS NULL AND O.LINKNAME IS NULL AND O.SUBNAME IS NULL AND
O.TYPE#=2 AND O.NAME=:B3 AND U.NAME=:B2 AND C.NAME=:B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 156 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 156 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 HASH JOIN (cr=52 pr=0 pw=0 time=1000 us starts=1 cost=10 size=270 card=1)
0 0 0 NESTED LOOPS (cr=52 pr=0 pw=0 time=1000 us starts=1 cost=10 size=270 card=1)
0 0 0 STATISTICS COLLECTOR (cr=52 pr=0 pw=0 time=1000 us starts=1)
0 0 0 HASH JOIN (cr=52 pr=0 pw=0 time=1000 us starts=1 cost=9 size=252 card=1)
0 0 0 NESTED LOOPS (cr=52 pr=0 pw=0 time=1000 us starts=1 cost=9 size=252 card=1)
0 0 0 STATISTICS COLLECTOR (cr=52 pr=0 pw=0 time=1000 us starts=1)
0 0 0 HASH JOIN (cr=52 pr=0 pw=0 time=1000 us starts=1 cost=8 size=209 card=1)
0 0 0 NESTED LOOPS (cr=52 pr=0 pw=0 time=1000 us starts=1 cost=8 size=209 card=1)
0 0 0 STATISTICS COLLECTOR (cr=52 pr=0 pw=0 time=1000 us starts=1)
0 0 0 NESTED LOOPS (cr=52 pr=0 pw=0 time=1000 us starts=1 cost=7 size=202 card=1)
16 16 16 HASH JOIN (cr=43 pr=0 pw=0 time=0 us starts=1 cost=6 size=176 card=1)
16 16 16 NESTED LOOPS (cr=43 pr=0 pw=0 time=0 us starts=1 cost=6 size=176 card=1)
16 16 16 STATISTICS COLLECTOR (cr=18 pr=0 pw=0 time=0 us starts=1)
16 16 16 HASH JOIN (cr=18 pr=0 pw=0 time=0 us starts=1 cost=5 size=155 card=1)
16 16 16 NESTED LOOPS (cr=18 pr=0 pw=0 time=0 us starts=1 cost=5 size=155 card=1)
16 16 16 STATISTICS COLLECTOR (cr=5 pr=0 pw=0 time=0 us starts=1)
16 16 16 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=44 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
16 16 16 TABLE ACCESS FULL ASSOCIATION$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=26 card=1)
16 16 16 INDEX RANGE SCAN I_OBJ2 (cr=13 pr=0 pw=0 time=0 us starts=16 cost=2 size=111 card=1)(object id 37)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=111 card=1)(object id 40)
16 16 16 TABLE ACCESS CLUSTER COL$ (cr=25 pr=0 pw=0 time=1000 us starts=16 cost=1 size=21 card=1)
16 16 16 INDEX UNIQUE SCAN I_OBJ# (cr=9 pr=0 pw=0 time=0 us starts=16 cost=0 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS FULL COL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=21 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID COLTYPE$ (cr=9 pr=0 pw=0 time=0 us starts=16 cost=1 size=26 card=1)
0 0 0 INDEX UNIQUE SCAN I_COLTYPE2 (cr=9 pr=0 pw=0 time=0 us starts=16 cost=0 size=0 card=1)(object id 113)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=7 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=7 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=43 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=43 card=1)(object id 40)
0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 11)
0 0 0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
********************************************************************************
SQL ID: crmdt678jathx Plan Hash: 1179034175
SELECT /*+ rule
OPT_PARAM('_parallel_syspls_obey_force'
'false') */ '"'||UI.NAME||'"' IND_OWNER, '"'||OI.NAME||'"' IND_NAME,
OI.OBJ# OBJ_NUM, NVL(PO.FLAGS,0) LOCALITY, I.PROPERTY IPROP, I.TYPE# ITYPE
FROM SYS.USER$ UT, SYS.OBJ$ OT, SYS.IND$ I, SYS.OBJ$ OI, SYS.USER$ UI,
SYS.PARTOBJ$ PO WHERE ((:B3 IS NULL) OR (PO.FLAGS IS NULL) OR (PO.FLAGS = 2)
) AND UT.NAME = :B2 AND UT.USER# = OT.OWNER# AND OT.NAME = :B1 AND OT.TYPE#
= 2 AND OT.OBJ# = I.BO# AND I.OBJ# = OI.OBJ# AND OI.OWNER# = UI.USER# AND
I.OBJ# = PO.OBJ#(+) UNION ALL SELECT /*+ rule */ '"'||UI.NAME||'"'
IND_OWNER, '"'||OI.NAME||'"' IND_NAME, OI.OBJ# OBJ_NUM, 0 LOCALITY,
I.PROPERTY IPROP, I.TYPE# ITYPE FROM SYS.USER$ UT, SYS.OBJ$ OT, SYS.IND$ I,
SYS.TAB$ T, SYS.OBJ$ OI, SYS.USER$ UI WHERE :B4 IS NOT NULL AND UT.NAME =
:B2 AND UT.USER# = OT.OWNER# AND OT.NAME = :B1 AND OT.TYPE# = 2 AND OT.OBJ#
= T.OBJ# AND T.BOBJ# = I.BO# AND I.TYPE# = 3 AND I.OBJ# = OI.OBJ# AND
OI.OWNER# = UI.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 1 0.00 0.00 0 21 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 21 0 3
Misses in library cache during parse: 0
Optimizer mode: RULE
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
3 3 3 UNION-ALL (cr=21 pr=0 pw=0 time=0 us starts=1)
3 3 3 NESTED LOOPS (cr=21 pr=0 pw=0 time=0 us starts=1)
3 3 3 NESTED LOOPS (cr=16 pr=0 pw=0 time=0 us starts=1)
3 3 3 FILTER (cr=10 pr=0 pw=0 time=0 us starts=1)
3 3 3 NESTED LOOPS OUTER (cr=10 pr=0 pw=0 time=0 us starts=1)
3 3 3 NESTED LOOPS (cr=8 pr=0 pw=0 time=0 us starts=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1)(object id 37)
3 3 3 TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=0 us starts=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1)(object id 3)
0 0 0 TABLE ACCESS BY INDEX ROWID PARTOBJ$ (cr=2 pr=0 pw=0 time=0 us starts=3)
0 0 0 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=2 pr=0 pw=0 time=0 us starts=3)(object id 80)
3 3 3 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=6 pr=0 pw=0 time=0 us starts=3)
3 3 3 INDEX RANGE SCAN I_OBJ1 (cr=5 pr=0 pw=0 time=0 us starts=3)(object id 36)
3 3 3 TABLE ACCESS CLUSTER USER$ (cr=5 pr=0 pw=0 time=0 us starts=3)
3 3 3 INDEX UNIQUE SCAN I_USER# (cr=2 pr=0 pw=0 time=0 us starts=3)(object id 11)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 TABLE ACCESS BY INDEX ROWID USER$ (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 INDEX UNIQUE SCAN I_USER1 (cr=0 pr=0 pw=0 time=0 us starts=0)(object id 46)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=0)(object id 37)
0 0 0 TABLE ACCESS CLUSTER TAB$ (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0)(object id 3)
0 0 0 TABLE ACCESS CLUSTER IND$ (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0)(object id 3)
0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0)(object id 36)
0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us starts=0)(object id 11)
********************************************************************************
SQL ID: 751umqb58u1kn Plan Hash: 1853893377
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ ITU.NAME
OWNNAME, ITO.NAME TABNAME
FROM
SYS.USER$ U, SYS.OBJ$ IO, SYS.IND$ I, SYS.OBJ$ ITO, SYS.USER$ ITU WHERE
U.NAME = :B2 AND IO.NAME = :B1 AND IO.OWNER# = U.USER# AND IO.NAMESPACE = 4
AND IO.REMOTEOWNER IS NULL AND IO.LINKNAME IS NULL AND IO.SUBNAME IS NULL
AND IO.TYPE# = 1 AND IO.OBJ# = I.OBJ# AND ITO.OBJ# = I.BO# AND ITO.OWNER#=
ITU.USER#
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 0 156 0 12
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 25 0.00 0.00 0 156 0 12
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 HASH JOIN (cr=13 pr=0 pw=0 time=0 us starts=1 cost=7 size=200 card=1)
1 1 1 NESTED LOOPS (cr=13 pr=0 pw=0 time=0 us starts=1 cost=7 size=200 card=1)
1 1 1 STATISTICS COLLECTOR (cr=11 pr=0 pw=0 time=0 us starts=1)
1 1 1 HASH JOIN (cr=11 pr=0 pw=0 time=0 us starts=1 cost=6 size=182 card=1)
1 1 1 NESTED LOOPS (cr=11 pr=0 pw=0 time=0 us starts=1 cost=6 size=182 card=1)
1 1 1 STATISTICS COLLECTOR (cr=8 pr=0 pw=0 time=0 us starts=1)
1 1 1 HASH JOIN (cr=8 pr=0 pw=0 time=0 us starts=1 cost=4 size=139 card=1)
1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=0 us starts=1 cost=4 size=139 card=1)
1 1 1 STATISTICS COLLECTOR (cr=5 pr=0 pw=0 time=0 us starts=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=111 card=1)(object id 37)
1 1 1 TABLE ACCESS BY INDEX ROWID IND$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=1 size=10 card=1)
1 1 1 INDEX UNIQUE SCAN I_IND1 (cr=2 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 41)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED IND$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=10 card=1)
0 0 0 INDEX FULL SCAN I_IND1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 41)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=43 card=1)
1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 36)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=43 card=1)(object id 40)
1 1 1 TABLE ACCESS CLUSTER USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 11)
0 0 0 TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
********************************************************************************
SQL ID: dq5ash5k7v8pr Plan Hash: 1163018545
SELECT /*+ ordered use_nl(u io i ito t itu po)
OPT_PARAM('_parallel_syspls_obey_force' 'false') */ IO.OBJ# IOBJN,I.TYPE#
ITYPE,I.FLAGS IFLAGS,I.PROPERTY IPROP, I.INTCOLS IINTCOLS, NVL(I.DEGREE,1),
I.ANALYZETIME, ITU.NAME TOWN,ITO.NAME TAB,I.BO# TOBJN,T.FLAGS TFLAGS,
T.PROPERTY TPROP, ITO.TYPE# TTYPE, CASE WHEN BITAND(T.FLAGS, 16) = 0 THEN
NULL ELSE T.ROWCNT END NROWS, PO.PARTTYPE PTYPE,PO.PARTCNT PCNT,
PO.PARTKEYCOLS PTKCOLS, PO.FLAGS PFLAGS,MOD(PO.SPARE2,256) SPTYPE FROM
SYS.USER$ U,SYS.OBJ$ IO,SYS.IND$ I, SYS.OBJ$ ITO,SYS.USER$ ITU,SYS.TAB$ T,
PARTOBJ$ PO WHERE U.NAME=:B2 AND IO.NAME=:B1 AND IO.OWNER#=U.USER# AND
IO.TYPE#=1 AND IO.OBJ#=I.OBJ# AND ITO.OBJ#=I.BO# AND ITO.OWNER#=ITU.USER#
AND ITO.OBJ#=T.OBJ# AND IO.OBJ#=PO.OBJ#(+) UNION ALL SELECT /*+ ordered
use_nl(u io i ito t itu) */ IO.OBJ# IOBJN,I.TYPE# ITYPE,I.FLAGS IFLAGS,
I.PROPERTY IPROP, I.INTCOLS IINTCOLS, NVL(I.DEGREE,1), I.ANALYZETIME,
ITU.NAME TOWN,ITO.NAME TAB,I.BO# TOBJN,0 TFLAGS,0 TPROP, ITO.TYPE# TTYPE,
NULL NROWS, NULL PTYPE,NULL PCNT,NULL PTKCOLS, NULL PFLAGS,NULL SPTYPE FROM
SYS.USER$ U,SYS.OBJ$ IO,SYS.IND$ I, SYS.OBJ$ ITO,SYS.USER$ ITU,SYS.CLU$ T
WHERE U.NAME=:B2 AND IO.NAME=:B1 AND IO.OWNER#=U.USER# AND IO.TYPE#=1 AND
IO.OBJ#=I.OBJ# AND ITO.OBJ#=I.BO# AND ITO.OWNER#=ITU.USER# AND ITO.OBJ#=
T.OBJ#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 51 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 51 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 UNION-ALL (cr=17 pr=0 pw=0 time=0 us starts=1)
1 1 1 NESTED LOOPS OUTER (cr=17 pr=0 pw=0 time=0 us starts=1 cost=9 size=204 card=1)
1 1 1 NESTED LOOPS (cr=16 pr=0 pw=0 time=0 us starts=1 cost=8 size=183 card=1)
1 1 1 NESTED LOOPS (cr=13 pr=0 pw=0 time=0 us starts=1 cost=7 size=163 card=1)
1 1 1 NESTED LOOPS (cr=11 pr=0 pw=0 time=0 us starts=1 cost=6 size=145 card=1)
1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=0 us starts=1 cost=4 size=98 card=1)
1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=65 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=47 card=1)(object id 37)
1 1 1 TABLE ACCESS BY INDEX ROWID IND$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=1 size=33 card=1)
1 1 1 INDEX UNIQUE SCAN I_IND1 (cr=2 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 41)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=47 card=1)
1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 36)
1 1 1 TABLE ACCESS CLUSTER USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 11)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=1 size=20 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS BY INDEX ROWID PARTOBJ$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=1 size=21 card=1)
0 0 0 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 80)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=8 size=167 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=7 size=163 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=6 size=145 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=4 size=98 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=3 size=65 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
0 0 0 INDEX UNIQUE SCAN I_USER1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 46)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=47 card=1)(object id 37)
0 0 0 TABLE ACCESS BY INDEX ROWID IND$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=33 card=1)
0 0 0 INDEX UNIQUE SCAN I_IND1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 41)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=47 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 11)
0 0 0 TABLE ACCESS CLUSTER CLU$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=4 card=1)
0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: b1khwjh2yb2sz Plan Hash: 444875925
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */
DECODE(SUM(BITAND(TRIGFLAG, 67108864)), 67108864, 67108864, 0) +
DECODE(SUM(BITAND(TRIGFLAG, 134217728)), 134217728, 134217728, 0) FROM (
SELECT /*+ ordered index(i) use_nl_with_index(t)
OPT_PARAM('_parallel_syspls_obey_force' 'false') */ T.TRIGFLAG FROM
SYS.IND$ I, SYS.TAB$ T WHERE I.OBJ# = :B1 AND I.TYPE# != 3 AND I.BO# =
T.OBJ# UNION ALL SELECT /*+ ordered index(i) use_nl_with_index(t)
OPT_PARAM('_parallel_syspls_obey_force' 'false') */ T.TRIGFLAG
FROM SYS.IND$ I, SYS.TAB$ T WHERE I.OBJ# = :B1 AND I.TYPE# = 3 AND I.BO# =
T.BOBJ# )
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 27 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 27 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=9 pr=0 pw=0 time=0 us starts=1)
1 1 1 VIEW (cr=9 pr=0 pw=0 time=0 us starts=1 cost=31 size=39 card=3)
1 1 1 UNION-ALL (cr=9 pr=0 pw=0 time=0 us starts=1)
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=0 us starts=1 cost=3 size=21 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID IND$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=13 card=1)
1 1 1 INDEX UNIQUE SCAN I_IND1 (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 41)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=1 size=8 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 3)
0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=0 us starts=1 cost=28 size=36 card=2)
0 0 0 TABLE ACCESS BY INDEX ROWID IND$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=13 card=1)
1 1 1 INDEX UNIQUE SCAN I_IND1 (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 41)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED TAB$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=26 size=10 card=2)
0 0 0 INDEX RANGE SCAN I_TAB1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=44)(object id 33)
********************************************************************************
SQL ID: 4dj64s4k1ypu1 Plan Hash: 3275028636
SELECT /*+ leading(u o)
OPT_PARAM('_parallel_syspls_obey_force' 'false') */ O.OBJ# POBJN,
NVL(IP.PART#, ICP.PART#) PN, O.SUBNAME PNAME, NVL(IP.ANALYZETIME,
ICP.ANALYZETIME) LAST_ANALYZED, NVL(IP.FLAGS, ICP.FLAGS) FLAGS, :B4 REASON
FROM SYS.USER$ U, SYS.OBJ$ O, SYS.INDPART$ IP, SYS.INDCOMPART$ ICP WHERE
:B3 IS NULL AND U.NAME = :B2 AND O.OWNER# = U.USER# AND O.NAME = :B1 AND
O.NAMESPACE = 4 AND O.REMOTEOWNER IS NULL AND O.LINKNAME IS NULL AND
O.TYPE# = 20 AND O.OBJ# = IP.OBJ#(+) AND O.OBJ# = ICP.OBJ#(+) UNION ALL
SELECT * FROM ( SELECT /*+ leading(u o) */ O.OBJ# POBJN, NVL(IP.PART#,
ICP.PART#) PN, O.SUBNAME PNAME, NVL(IP.ANALYZETIME,ICP.ANALYZETIME)
LAST_ANALYZED, NVL(IP.FLAGS, ICP.FLAGS) FLAGS, :B4 REASON FROM SYS.USER$ U,
SYS.OBJ$ O, SYS.INDPART$ IP, SYS.INDCOMPART$ ICP WHERE U.NAME = :B2 AND
O.OWNER# = U.USER# AND O.NAME = :B1 AND O.NAMESPACE = 4 AND O.REMOTEOWNER
IS NULL AND O.LINKNAME IS NULL AND O.SUBNAME = :B3 AND O.TYPE# = 20 AND
O.OBJ# = IP.OBJ#(+) AND O.OBJ# = ICP.OBJ#(+) UNION ALL SELECT /*+ leading(u
osp isp op) */ OP.OBJ# POBJN, ICP.PART# PN, OP.SUBNAME PNAME,
ICP.ANALYZETIME LAST_ANALYZED, ICP.FLAGS FLAGS, :B4 REASON FROM SYS.USER$ U,
SYS.OBJ$ OSP, SYS.INDSUBPART$ ISP, SYS.OBJ$ OP, SYS.INDCOMPART$ ICP WHERE
U.NAME = :B2 AND OSP.OWNER# = U.USER# AND OSP.NAME = :B1 AND OSP.NAMESPACE =
4 AND OSP.REMOTEOWNER IS NULL AND OSP.LINKNAME IS NULL AND OSP.SUBNAME =
:B3 AND OSP.TYPE# = 35 AND OSP.OBJ# = ISP.OBJ# AND OP.OBJ# = ISP.POBJ# AND
OP.OBJ# = ICP.OBJ# ) WHERE ROWNUM < 2
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 0 27 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 9 0.00 0.00 0 27 0 0
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UNION-ALL (cr=9 pr=0 pw=0 time=0 us starts=1)
0 0 0 FILTER (cr=5 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS OUTER (cr=5 pr=0 pw=0 time=0 us starts=1 cost=4 size=199 card=1)
0 0 0 NESTED LOOPS OUTER (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=177 card=1)
0 0 0 NESTED LOOPS (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=111 card=1)(object id 37)
0 0 0 TABLE ACCESS BY INDEX ROWID INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=48 card=1)
0 0 0 INDEX UNIQUE SCAN I_INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 826)
0 0 0 TABLE ACCESS BY INDEX ROWID INDPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=22 card=1)
0 0 0 INDEX UNIQUE SCAN I_INDPART_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 804)
0 0 0 COUNT STOPKEY (cr=4 pr=0 pw=0 time=0 us starts=1)
0 0 0 VIEW (cr=4 pr=0 pw=0 time=0 us starts=1 cost=6 size=254 card=2)
0 0 0 UNION-ALL (cr=4 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS OUTER (cr=2 pr=0 pw=0 time=0 us starts=1 cost=3 size=199 card=1)
0 0 0 NESTED LOOPS OUTER (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=177 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=1 cost=1 size=111 card=1)(object id 37)
0 0 0 TABLE ACCESS BY INDEX ROWID INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=48 card=1)
0 0 0 INDEX UNIQUE SCAN I_INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 826)
0 0 0 TABLE ACCESS BY INDEX ROWID INDPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=22 card=1)
0 0 0 INDEX UNIQUE SCAN I_INDPART_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 804)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=3 size=210 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=3 size=210 card=1)
0 0 0 HASH JOIN (cr=2 pr=0 pw=0 time=0 us starts=1 cost=3 size=162 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=3 size=162 card=1)
0 0 0 STATISTICS COLLECTOR (cr=2 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=155 card=1)
0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=129 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=18 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 46)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=1 cost=1 size=111 card=1)(object id 37)
0 0 0 TABLE ACCESS BY INDEX ROWID INDSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=26 card=1)
0 0 0 INDEX UNIQUE SCAN I_INDSUBPART_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 816)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=7 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
0 0 0 INDEX FAST FULL SCAN I_OBJ5 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=7 card=1)(object id 40)
0 0 0 INDEX UNIQUE SCAN I_INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 826)
0 0 0 TABLE ACCESS BY INDEX ROWID INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=48 card=1)
********************************************************************************
SQL ID: 76rz8vf4kqjn7 Plan Hash: 4116228867
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ :B2
FROM
DUAL WHERE :B1 IS NULL UNION ALL SELECT TP.OBJ# FROM SYS.TABPART$ TP,
SYS.INDPART$ IP WHERE TP.BO# = :B2 AND IP.PART# = TP.PART# AND IP.OBJ# =
:B1 UNION ALL SELECT TP.OBJ# FROM SYS.TABCOMPART$ TP, SYS.INDCOMPART$ IP
WHERE TP.BO# = :B2 AND IP.PART# = TP.PART# AND IP.OBJ# = :B1 UNION ALL
SELECT TSP.OBJ# FROM SYS.TABSUBPART$ TSP, SYS.TABCOMPART$ TCP,
SYS.INDSUBPART$ ISP, SYS.INDCOMPART$ ICP WHERE TCP.BO# = :B2 AND TSP.POBJ# =
TCP.OBJ# AND ISP.SUBPART# = TSP.SUBPART# AND ICP.PART# = TCP.PART# AND
ISP.POBJ# = ICP.OBJ# AND ISP.OBJ# = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 0 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 0 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 UNION-ALL (cr=0 pr=0 pw=0 time=0 us starts=1)
1 1 1 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us starts=1 cost=2 size=0 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=1 cost=2 size=25 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID INDPART$ (cr=0 pr=0 pw=0 time=0 us starts=1 cost=1 size=10 card=1)
0 0 0 INDEX UNIQUE SCAN I_INDPART_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 804)
0 0 0 TABLE ACCESS BY INDEX ROWID TABPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=15 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABPART_BOPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 798)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=39 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=26 card=1)
0 0 0 INDEX UNIQUE SCAN I_INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 826)
0 0 0 TABLE ACCESS BY INDEX ROWID TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=13 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABCOMPART_BOPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 820)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=1 cost=1 size=91 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=78 card=1)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=65 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID INDSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=39 card=1)
0 0 0 INDEX UNIQUE SCAN I_INDSUBPART_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 816)
0 0 0 TABLE ACCESS BY INDEX ROWID INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=26 card=1)
0 0 0 INDEX UNIQUE SCAN I_INDCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 826)
0 0 0 TABLE ACCESS BY INDEX ROWID TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=13 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABCOMPART_BOPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 820)
0 0 0 TABLE ACCESS BY INDEX ROWID TABSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=13 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABSUBPART_POBJSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 810)
********************************************************************************
SQL ID: 4g6pp0b6fbawm Plan Hash: 1130498780
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ ROWCNT, BLKCNT,
ANALYZETIME
FROM
SYS.TAB$ WHERE OBJ# = :B2 AND BITAND(FLAGS, 16) != 0 AND :B1 = 'n' UNION ALL
SELECT ROWCNT_KXTTST_TS, BLKCNT_KXTTST_TS, ANALYZETIME_KXTTST_TS FROM
SYS.X$KXTTSTETS WHERE OBJ#_KXTTST_TS = :B2 AND :B1 = 'y'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 9 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 9 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 UNION-ALL (cr=3 pr=0 pw=0 time=0 us starts=1)
1 1 1 FILTER (cr=3 pr=0 pw=0 time=0 us starts=1)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=24 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 3)
0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us starts=1)
0 0 0 FIXED TABLE FIXED INDEX X$KXTTSTETS (ind:1) (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=48 card=1)
********************************************************************************
SQL ID: azfvzhkdtsfng Plan Hash: 358207273
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ COUNT(*)
FROM
SYS.FIXED_OBJ$ WHERE OBJ# = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 6 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 6 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=0 us starts=1)
0 0 0 INDEX UNIQUE SCAN I_FIXED_OBJ$_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=7 card=1)(object id 72)
********************************************************************************
SQL ID: b8zju7mj1v0wf Plan Hash: 3704755223
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ T.PROPERTY
FROM
SYS.OBJ$ O, SYS.TAB$ T WHERE O.OBJ# = :B1 AND O.TYPE# = 2 AND O.OBJ# =
T.OBJ#
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 15 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 15 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 MERGE JOIN CARTESIAN (cr=5 pr=0 pw=0 time=0 us starts=1 cost=3 size=21 card=1)
1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=12 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 3)
1 1 1 BUFFER SORT (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=9 card=1)
1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=9 card=1)(object id 36)
********************************************************************************
SQL ID: 54bagkdf5jz06 Plan Hash: 305735784
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SUM(REASON)
FROM
(SELECT OBJ#, CASE WHEN BITAND(FLAGS, 16) != 16 THEN :B3 ELSE :B2 END REASON
FROM SYS.TAB$ WHERE OBJ# = :B1 AND (BITAND(FLAGS,16) != 16 OR SAMPLESIZE <>
ROWCNT) UNION ALL SELECT OBJ#, CASE WHEN BITAND(FLAGS, 2) != 2 THEN :B3
ELSE :B2 END REASON FROM SYS.TABPART$ WHERE OBJ# = :B1 AND (BITAND(FLAGS,2)
!= 2 OR SAMPLESIZE <> ROWCNT) UNION ALL SELECT OBJ#, CASE WHEN BITAND(FLAGS,
2) != 2 THEN :B3 ELSE :B2 END REASON FROM SYS.TABCOMPART$ T WHERE OBJ# =
:B1 AND (BITAND(FLAGS,2) != 2 OR SAMPLESIZE <> ROWCNT) UNION ALL SELECT
OBJ#, CASE WHEN BITAND(FLAGS, 2) != 2 THEN :B3 ELSE :B2 END REASON FROM
SYS.TABSUBPART$ WHERE OBJ# = :B1 AND (BITAND(FLAGS,2) != 2) OR SAMPLESIZE
<> ROWCNT)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 27 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 27 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=9 pr=0 pw=0 time=0 us starts=1)
0 0 0 VIEW (cr=9 pr=0 pw=0 time=0 us starts=1 cost=7 size=52 card=4)
0 0 0 UNION-ALL (cr=9 pr=0 pw=0 time=0 us starts=1)
0 0 0 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=16 card=1)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS BY INDEX ROWID TABPART$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=2 size=16 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABPART_OBJ$ (cr=2 pr=0 pw=0 time=0 us starts=1 cost=1 size=0 card=1)(object id 799)
0 0 0 TABLE ACCESS BY INDEX ROWID TABCOMPART$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=1 size=23 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABCOMPART$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 821)
0 0 0 TABLE ACCESS FULL TABSUBPART$ (cr=3 pr=0 pw=0 time=0 us starts=1 cost=2 size=34 card=1)
********************************************************************************
SQL ID: 0ks4u5nywjbdj Plan Hash: 1017082981
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ COUNT(*)
FROM
MON_MODS_ALL$ M, (SELECT ROWCNT, OBJ# BO# FROM TAB$ WHERE OBJ# = :B1 UNION
ALL SELECT ROWCNT, BO# BO# FROM TABPART$ WHERE OBJ# = :B1 UNION ALL SELECT
ROWCNT, BO# BO# FROM TABCOMPART$ WHERE OBJ# = :B1 UNION ALL SELECT T.ROWCNT,
TCP.BO# BO# FROM TABSUBPART$ T, TABCOMPART$ TCP WHERE T.OBJ# = :B1 AND
T.POBJ# = TCP.OBJ#) V WHERE M.OBJ# = :B1 AND (BITAND(M.FLAGS,:B3 ) = :B3 OR
M.INSERTS+M.UPDATES+M.DELETES > :B2 /100 * NVL(V.ROWCNT, 0) OR
M.DROP_SEGMENTS > 0 )
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.00 0 3 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 3 0 3
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 SORT AGGREGATE (cr=1 pr=0 pw=0 time=0 us starts=1)
0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=0 us starts=1 cost=7 size=34 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID MON_MODS_ALL$ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=1 size=21 card=1)
0 0 0 INDEX UNIQUE SCAN I_MON_MODS_ALL$_OBJ (cr=1 pr=0 pw=0 time=0 us starts=1 cost=0 size=0 card=1)(object id 661)
0 0 0 VIEW (cr=0 pr=0 pw=0 time=0 us starts=0 cost=6 size=13 card=1)
0 0 0 UNION-ALL (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 TABLE ACCESS CLUSTER TAB$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=8 card=1)
0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 3)
0 0 0 TABLE ACCESS BY INDEX ROWID TABPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=9 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABPART_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 799)
0 0 0 TABLE ACCESS BY INDEX ROWID TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=7 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 821)
0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=28 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID TABSUBPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=23 card=1)
0 0 0 INDEX UNIQUE SCAN I_TABSUBPART$_OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 811)
0 0 0 INDEX UNIQUE SCAN I_TABCOMPART$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=5 card=1)(object id 821)
********************************************************************************
SQL ID: 38243c4tqrkxm Plan Hash: 3848648847
select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property,1024),0,
0,1), o.obj#
from
ind$ i,obj$ o,user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#
