| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Spatial Insert Performance
Some additional info...
I've attached below the top portion of a trace file (event 10046 level 8) from a 5000 row insert test. Seems like a portion of time is spent accessing SDO views (10.73s) and maintaining the index table (4.53s).
But that still leaves quite a bit of time unaccounted for (37.96s) out of the total 53.22s elapsed time...
--Peter
TKPROF: Release 9.2.0.3.0 - Production on Fri Jul 9 13:21:18 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Trace file: dbdev_ora_2180.trc
Sort options: exeela
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 ********************************************************************************
insert into test2 (id, location)
values
(testseq.nextval, MDSYS.SDO_GEOMETRY(2001,8307,MDSYS.SDO_POINT_TYPE(:1,:2,
NULL),null,null))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0 Execute 100 53.04 53.22 1 49600 22641 5000 Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 101 53.04 53.22 1 49600 22641 5000
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ log file sync 100 0.14 0.52 SQL*Net message to client 100 0.00 0.00 SQL*Net message from client 100 0.06 0.66 ********************************************************************************
SELECT info
from
PETERS.MDRT_B755$ where rowid = :rid for update
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5000 0.25 0.26 0 0 0 0 Execute 10092 1.17 0.93 0 10109 10092 0 Fetch 10092 0.12 0.25 0 10631 0 10092
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 25184 1.54 1.46 0 20740 10092 10092
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
2 FOR UPDATE (cr=4 r=0 w=0 time=144 us)
4 TABLE ACCESS BY USER ROWID MDRT_B755$ (cr=6 r=0 w=0 time=189 us)
********************************************************************************
SELECT diminfo, nvl(srid,-1)
FROM
ALL_SDO_GEOM_METADATA WHERE OWNER = 'PETERS' AND TABLE_NAME =
NLS_UPPER('TEST2') AND '"'||COLUMN_NAME||'"' = '"LOCATION"'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5000 0.39 0.44 0 0 0 0 Execute 5000 0.92 0.90 0 0 0 0 Fetch 5000 2.26 2.25 0 85000 0 5000
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 15000 3.57 3.60 0 85000 0 5000
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID SDO_GEOM_METADATA_TABLE (cr=17 r=0 w=0 time=275 us)
1 INDEX RANGE SCAN SDO_GEOM_IDX (cr=16 r=0 w=0 time=259 us)(object id 26041)
1 UNION-ALL (cr=15 r=0 w=0 time=200 us)
1 FILTER (cr=15 r=0 w=0 time=195 us)
1 NESTED LOOPS OUTER (cr=15 r=0 w=0 time=190 us)
1 NESTED LOOPS OUTER (cr=15 r=0 w=0 time=182 us)
1 NESTED LOOPS OUTER (cr=13 r=0 w=0 time=166 us)
1 NESTED LOOPS OUTER (cr=13 r=0 w=0 time=159 us)
1 NESTED LOOPS (cr=10 r=0 w=0 time=129 us)
1 NESTED LOOPS (cr=8 r=0 w=0 time=111 us)
1 NESTED LOOPS (cr=5 r=0 w=0 time=68 us)
1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 r=0 w=0 time=26 us)
1 INDEX UNIQUE SCAN I_USER1 (cr=1 r=0 w=0 time=9 us)(object id 44)
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 r=0 w=0 time=33 us)
1 INDEX RANGE SCAN I_OBJ2 (cr=2 r=0 w=0 time=14 us)(object id 37)
1 TABLE ACCESS CLUSTER TAB$ (cr=3 r=0 w=0 time=37 us)
1 INDEX UNIQUE SCAN I_OBJ# (cr=2 r=0 w=0 time=10 us)(object id 3)
1 TABLE ACCESS CLUSTER TS$ (cr=2 r=0 w=0 time=13 us)
1 INDEX UNIQUE SCAN I_TS# (cr=1 r=0 w=0 time=5 us)(object id 7)
1 TABLE ACCESS CLUSTER SEG$ (cr=3 r=0 w=0 time=20 us)
1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 r=0 w=0 time=10 us)(object id 9)
0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0 w=0 time=0 us)(object id 36)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=2 r=0 w=0 time=12 us)
0 INDEX UNIQUE SCAN I_OBJ1 (cr=2 r=0 w=0 time=9 us)(object id 36)
0 TABLE ACCESS CLUSTER USER$ (cr=0 r=0 w=0 time=2 us)
0 INDEX UNIQUE SCAN I_USER# (cr=0 r=0 w=0 time=0 us)(object id 11)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 r=0 w=0 time=0 us)(object id 108)
0 FIXED TABLE FULL X$KZSRO (cr=0 r=0 w=0 time=0 us)
0 FIXED TABLE FULL X$KZSPR (cr=0 r=0 w=0 time=0 us)
0 FILTER (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS OUTER (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS OUTER (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS OUTER (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS OUTER (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS OUTER (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS OUTER (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID USER$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER1 (cr=0 r=0 w=0 time=0 us)(object id 44)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 r=0 w=0 time=0 us)
0 INDEX RANGE SCAN I_OBJ2 (cr=0 r=0 w=0 time=0 us)(object id 37)
0 TABLE ACCESS CLUSTER TAB$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_OBJ# (cr=0 r=0 w=0 time=0 us)(object id 3)
0 TABLE ACCESS CLUSTER COL$ (cr=0 r=0 w=0 time=0 us)
0 TABLE ACCESS CLUSTER TS$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_TS# (cr=0 r=0 w=0 time=0 us)(object id 7)
0 TABLE ACCESS CLUSTER COLTYPE$ (cr=0 r=0 w=0 time=0 us)
0 TABLE ACCESS CLUSTER SEG$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=0 r=0 w=0 time=0 us)(object id 9)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 r=0 w=0 time=0 us)
0 INDEX RANGE SCAN I_OBJ3 (cr=0 r=0 w=0 time=0 us)(object id 38)
0 TABLE ACCESS CLUSTER USER$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER# (cr=0 r=0 w=0 time=0 us)(object id 11)
0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0 w=0 time=0 us)(object id 36)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0 w=0 time=0 us)(object id 36)
0 TABLE ACCESS CLUSTER USER$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER# (cr=0 r=0 w=0 time=0 us)(object id 11)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0 w=0 time=0 us)(object id 36)
0 TABLE ACCESS CLUSTER USER$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER# (cr=0 r=0 w=0 time=0 us)(object id 11)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 r=0 w=0 time=0 us)(object id 108)
0 FIXED TABLE FULL X$KZSRO (cr=0 r=0 w=0 time=0 us)
0 FIXED TABLE FULL X$KZSPR (cr=0 r=0 w=0 time=0 us)
0 FILTER (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS OUTER (cr=0 r=0 w=0 time=0 us)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 TABLE ACCESS BY INDEX ROWID USER$ (cr=0 r=0 w=0 time=0 us)
0 INDEX UNIQUE SCAN I_USER1 (cr=0 r=0 w=0 time=0 us)(object id 44)
0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 r=0 w=0 time=0 us)
0 INDEX RANGE SCAN I_OBJ2 (cr=0 r=0 w=0 time=0 us)(object id 37)
0 INDEX UNIQUE SCAN I_TYPED_VIEW1 (cr=0 r=0 w=0 time=0 us)(object id 105)
0 INDEX UNIQUE SCAN I_VIEW1 (cr=0 r=0 w=0 time=0 us)(object id 104)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 r=0 w=0 time=0 us)(object id 108)
0 FIXED TABLE FULL X$KZSRO (cr=0 r=0 w=0 time=0 us)
0 FIXED TABLE FULL X$KZSPR (cr=0 r=0 w=0 time=0 us)
********************************************************************************
UPDATE PETERS.MDRT_B755$ set node_id = :1
where
rowid = :2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5186 0.26 0.25 0 0 0 0 Execute 5186 0.75 0.85 0 5186 5186 5186 Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 10372 1.01 1.11 0 5186 5186 5186
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 UPDATE (cr=1 r=0 w=0 time=125 us)
1 TABLE ACCESS BY USER ROWID MDRT_B755$ (cr=1 r=0 w=0 time=20 us)
********************************************************************************
SELECT nvl(sdo_level,0), nvl(sdo_numtiles,0), nvl(sdo_maxlevel, 0),
nvl(sdo_index_table, 'DEFAULT'), sdo_index_primary, sdo_index_type, nvl(sdo_rtree_height, 0), nvl(sdo_rtree_num_nodes, 0), nvl(sdo_rtree_dimensionality, 0), nvl(sdo_rtree_fanout, 0), nvl(sdo_rtree_root, 'EMPTY'), nvl(sdo_rtree_seq_name, 'DEFAULT'),sdo_index_partition, nvl(sdo_partitioned, 0), nvl(sdo_layer_gtype, 'DEFAULT'), nvl(sdo_index_dims, 0), nvl(sdo_rtree_pctfree, 10), nvl(sdo_rtree_quality, 1), nvl(sdo_index_version, 0), nvl(sdo_tablespace, 'DEFAULT'), nvl(sdo_index_geodetic, 'FALSE'), sdo_index_status FROM
Parse 5000 0.31 0.34 0 0 0 0 Execute 5000 0.68 0.64 0 0 0 0 Fetch 10000 2.28 2.22 0 120000 0 5000
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 20000 3.28 3.22 0 120000 0 5000
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT ORDER BY (cr=24 r=0 w=0 time=471 us)
1 FILTER (cr=24 r=0 w=0 time=371 us)
1 TABLE ACCESS BY INDEX ROWID SDO_INDEX_METADATA_TABLE (cr=2 r=0 w=0 time=72 us)
1 INDEX RANGE SCAN SDO_IDX_MDATA_IDX (cr=1 r=0 w=0 time=39 us)(object id 26161)
1 FILTER (cr=22 r=0 w=0 time=231 us)
1 NESTED LOOPS OUTER (cr=22 r=0 w=0 time=226 us)
1 NESTED LOOPS OUTER (cr=20 r=0 w=0 time=206 us)
1 NESTED LOOPS (cr=17 r=0 w=0 time=185 us)
1 NESTED LOOPS (cr=15 r=0 w=0 time=165 us)
1 NESTED LOOPS OUTER (cr=12 r=0 w=0 time=146 us)
1 NESTED LOOPS OUTER (cr=10 r=0 w=0 time=128 us)
1 NESTED LOOPS (cr=8 r=0 w=0 time=98 us)
1 NESTED LOOPS (cr=5 r=0 w=0 time=65 us)
1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 r=0 w=0 time=33 us)
1 INDEX UNIQUE SCAN I_USER1 (cr=1 r=0 w=0 time=14 us)(object id 44)
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 r=0 w=0 time=24 us)
1 INDEX RANGE SCAN I_OBJ2 (cr=2 r=0 w=0 time=15 us)(object id 37)
1 TABLE ACCESS BY INDEX ROWID IND$ (cr=3 r=0 w=0 time=28 us)
1 INDEX UNIQUE SCAN I_IND1 (cr=2 r=0 w=0 time=9 us)(object id 39)
1 TABLE ACCESS CLUSTER TS$ (cr=2 r=0 w=0 time=24 us)
1 INDEX UNIQUE SCAN I_TS# (cr=1 r=0 w=0 time=5 us)(object id 7)
0 TABLE ACCESS CLUSTER SEG$ (cr=2 r=0 w=0 time=11 us)
0 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 r=0 w=0 time=8 us)(object id 9)
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 r=0 w=0 time=14 us)
1 INDEX UNIQUE SCAN I_OBJ1 (cr=2 r=0 w=0 time=9 us)(object id 36)
1 TABLE ACCESS CLUSTER USER$ (cr=2 r=0 w=0 time=15 us)
1 INDEX UNIQUE SCAN I_USER# (cr=1 r=0 w=0 time=5 us)(object id 11)
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 r=0 w=0 time=15 us)
1 INDEX UNIQUE SCAN I_OBJ1 (cr=2 r=0 w=0 time=9 us)(object id 36)
1 TABLE ACCESS CLUSTER USER$ (cr=2 r=0 w=0 time=12 us)
1 INDEX UNIQUE SCAN I_USER# (cr=1 r=0 w=0 time=4 us)(object id 11)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 r=0 w=0 time=0 us)(object id 108)
0 FIXED TABLE FULL X$KZSRO (cr=0 r=0 w=0 time=0 us)
0 FIXED TABLE FULL X$KZSPR (cr=0 r=0 w=0 time=0 us)
********************************************************************************
SELECT nvl(sdo_index_table, 'DEFAULT'), sdo_index_status,
nvl(sdo_index_dims, 2)
FROM
all_sdo_index_metadata WHERE sdo_index_owner = 'PETERS' and sdo_index_name =
'TEST2_SPATIAL_IDX' AND SDO_INDEX_PRIMARY=1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5000 0.40 0.48 0 0 0 0 Execute 5000 0.46 0.55 0 0 0 0 Fetch 10000 1.71 1.79 0 120000 0 5000
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 20000 2.59 2.83 0 120000 0 5000
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 FILTER (cr=24 r=0 w=0 time=388 us)
1 TABLE ACCESS BY INDEX ROWID SDO_INDEX_METADATA_TABLE (cr=2 r=0 w=0 time=82 us)
1 INDEX RANGE SCAN SDO_IDX_MDATA_IDX (cr=1 r=0 w=0 time=42 us)(object id 26161)
1 FILTER (cr=22 r=0 w=0 time=246 us)
1 NESTED LOOPS OUTER (cr=22 r=0 w=0 time=240 us)
1 NESTED LOOPS OUTER (cr=20 r=0 w=0 time=220 us)
1 NESTED LOOPS (cr=17 r=0 w=0 time=197 us)
1 NESTED LOOPS (cr=15 r=0 w=0 time=176 us)
1 NESTED LOOPS OUTER (cr=12 r=0 w=0 time=155 us)
1 NESTED LOOPS OUTER (cr=10 r=0 w=0 time=138 us)
1 NESTED LOOPS (cr=8 r=0 w=0 time=104 us)
1 NESTED LOOPS (cr=5 r=0 w=0 time=68 us)
1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 r=0 w=0 time=31 us)
1 INDEX UNIQUE SCAN I_USER1 (cr=1 r=0 w=0 time=14 us)(object id 44)
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 r=0 w=0 time=26 us)
1 INDEX RANGE SCAN I_OBJ2 (cr=2 r=0 w=0 time=16 us)(object id 37)
1 TABLE ACCESS BY INDEX ROWID IND$ (cr=3 r=0 w=0 time=29 us)
1 INDEX UNIQUE SCAN I_IND1 (cr=2 r=0 w=0 time=9 us)(object id 39)
1 TABLE ACCESS CLUSTER TS$ (cr=2 r=0 w=0 time=26 us)
1 INDEX UNIQUE SCAN I_TS# (cr=1 r=0 w=0 time=6 us)(object id 7)
0 TABLE ACCESS CLUSTER SEG$ (cr=2 r=0 w=0 time=10 us)
0 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 r=0 w=0 time=8 us)(object id 9)
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 r=0 w=0 time=15 us)
1 INDEX UNIQUE SCAN I_OBJ1 (cr=2 r=0 w=0 time=9 us)(object id 36)
1 TABLE ACCESS CLUSTER USER$ (cr=2 r=0 w=0 time=15 us)
1 INDEX UNIQUE SCAN I_USER# (cr=1 r=0 w=0 time=5 us)(object id 11)
1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 r=0 w=0 time=16 us)
1 INDEX UNIQUE SCAN I_OBJ1 (cr=2 r=0 w=0 time=9 us)(object id 36)
1 TABLE ACCESS CLUSTER USER$ (cr=2 r=0 w=0 time=14 us)
1 INDEX UNIQUE SCAN I_USER# (cr=1 r=0 w=0 time=5 us)(object id 11)
0 NESTED LOOPS (cr=0 r=0 w=0 time=0 us)
0 INDEX RANGE SCAN I_OBJAUTH1 (cr=0 r=0 w=0 time=0 us)(object id 108)
0 FIXED TABLE FULL X$KZSRO (cr=0 r=0 w=0 time=0 us)
0 FIXED TABLE FULL X$KZSPR (cr=0 r=0 w=0 time=0 us)
********************************************************************************
SELECT info
from
PETERS.MDRT_B755$ where rowid = :rid
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5000 0.15 0.23 0 0 0 0 Execute 15000 0.42 0.52 0 0 0 0 Fetch 15000 0.46 0.51 0 15002 0 15000
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 35000 1.04 1.27 0 15002 0 15000
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
3 TABLE ACCESS BY USER ROWID MDRT_B755$ (cr=3 r=0 w=0 time=72 us)
select count(*)
from
mdsys.geodetic_srids where srid = 8307
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5000 0.40 0.36 0 0 0 0 Execute 5000 0.25 0.38 0 0 0 0 Fetch 5000 0.31 0.33 0 15000 0 5000
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 15000 0.96 1.08 0 15000 0 5000
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=3 r=0 w=0 time=55 us)
1 TABLE ACCESS BY INDEX ROWID CS_SRS (cr=3 r=0 w=0 time=45 us)
1 INDEX UNIQUE SCAN SYS_C001699 (cr=2 r=0 w=0 time=22 us)(object id 27667)
********************************************************************************
SELECT info
from
PETERS.MDRT_B755$ where rowid = :1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5186 0.31 0.24 0 0 0 0 Execute 5186 0.28 0.19 0 0 0 0 Fetch 5186 0.23 0.17 0 5186 0 5186
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 15558 0.82 0.61 0 5186 0 5186
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY USER ROWID MDRT_B755$ (cr=1 r=0 w=0 time=22 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 log file switch completion 2 0.17 0.19 ********************************************************************************
select wktext, srid
from
mdsys.cs_srs where srid = 8307
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5000 0.15 0.19 0 0 0 0 Execute 5000 0.14 0.15 0 0 0 0 Fetch 5000 0.14 0.13 0 15000 0 5000
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 15000 0.43 0.48 0 15000 0 5000
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 213 (recursive depth: 1)
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID CS_SRS (cr=3 r=0 w=0 time=19 us)
1 INDEX UNIQUE SCAN SYS_C001699 (cr=2 r=0 w=0 time=12 us)(object id 27667)
********************************************************************************
... rest of items had elapsed time < 0.1 ... Received on Fri Jul 09 2004 - 13:03:13 CDT
 |
 |