Database Reference
In-Depth Information
---- DISK_READS=12, DISK_READS_PER_EX=0, BUFFER_GETS=70693, BUFFER_GETS_PER_EX=7
---- DIRECT_WRITES=0, DIRECT_WRITES_PER_EX=0
---- PARSE_CALLS=1262, EXECUTIONS=10083, ROWS_PROCESSED=10083
---- CPU/Elapsed Time (sec.) total=1.9500/1.7199, per ex.=0.0002/0.0002
---- PL/SQL Exec Time (sec.) total=0.0000, per ex.=0.0000
---- JAVA Exec Time (sec.) total=0.0000, per ex.=0.0000
---- Application Wait Time (sec.) total=0.0000, per ex.=0.0000
---- Concurrency Wait Time (sec.) total=0.0000, per ex.=0.0000
---- Cluster Wait Time (sec.) total=0.0000, per ex.=0.0000
---- User IO Wait Time (sec.) total=0.0296, per ex.=0.00 00
---- Exact Signature = 9606234597766529887, Force Signature = 9606234597766529887
---- Service : xxxxx
---- Module : java@xxxxx (TNS V1-V3)
---- SQL Source: obj#=60922, line#=1114
---- USER="XXXXX", SCHEMA="XXXXX", OPTIMIZER_MODE=ALL_ROWS,
OPTIMIZER_ENV_HASH_VALUE=1214627050, USERS_OPEN=1, USERS_EXEC=0
---- SQL_ID=>3vub60vyq1ash<, ADDRESS=>0000000F4FE851F8<, HASH_VALUE=>4250970896<,
OLD_HASH_VALUE=>654808699<, CHILD_NUMBER=>0<
SELECT WERT FROM XXXXX.EINSTELLUNGEN WHERE UPPER(EINTRAG) = UPPER(:B1 )
---- Execution Plan (Plan Hash Value : 1130876695) :
0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=3)
1 0 TABLE ACCESS (FULL) OF EINSTELLUNGEN (Cost=3 Card=1 Bytes=29 CPU_Cost=69227
IO_Cost=3 Time=1)
Non-Default SQL Optimizer Environment:
--------------------------------------
_optimizer_extend_jppd_view_types = false
_pga_max_size = 2097152 KB
_smm_px_max_size = 19529728 KB
Reason(s) for no sharing the existing cursor:
---------------------------------------------
OPTIMIZER_MISMATCH: The optimizer environment does not match the existing child cursor
---- DISK_READS=0, DISK_READS_PER_EX=0, BUFFER_GETS=635837, BUFFER_GETS_PER_EX=7
---- DIRECT_WRITES=0, DIRECT_WRITES_PER_EX=0
---- PARSE_CALLS=619, EXECUTIONS=90818, ROWS_PROCESSED=90818
---- CPU/Elapsed Time (sec.) total=13.0600/11.6729, per ex.=0.0001/0.0001
---- PL/SQL Exec Time (sec.) total=0.0000, per ex.=0.0000
---- JAVA Exec Time (sec.) total=0.0000, per ex.=0.0000
---- Application Wait Time (sec.) total=0.0000, per ex.=0.0000
---- Concurrency Wait Time (sec.) total=0.0000, per ex.=0.0000
---- Cluster Wait Time (sec.) total=0.0000, per ex.=0.0000
---- User IO Wait Time (sec.) total=0.0000, per ex.=0.0000
---- Exact Signature = 9606234597766529887, Force Signature = 9606234597766529887
---- Service : xxxxx
---- Module : java@xxxxx (TNS V1-V3)
---- SQL Source: obj#=60922, line#=1114
---- USER="XXXXX", SCHEMA="XXXXX", OPTIMIZER_MODE=ALL_ROWS,
OPTIMIZER_ENV_HASH_VALUE=2221107520, USERS_OPEN=40, USERS_EXEC=0
---- SQL_ID=>3vub60vyq1ash<, ADDRESS=>0000000F4FE851F8<, HASH_VALUE=>4250970896<,
OLD_HASH_VALUE=>654808699<, CHILD_NUMBER=>1<
SELECT WERT FROM XXXXX.EINSTELLUNGEN WHERE UPPER(EINTRAG) = UPPER(:B1 )
---- Execution Plan (Plan Hash Value : 1130876695) :
0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=3)
1 0 TABLE ACCESS (FULL) OF EINSTELLUNGEN (Cost=3 Card=1 Bytes=29 CPU_Cost=69227
IO_Cost=3 Time=1)
Non-Default SQL Optimizer Environment:
--------------------------------------
_optimizer_extend_jppd_view_types = false
_pga_max_size = 2097152 KB
_smm_px_max_size = 19660800 KB
Reason(s) for no sharing the existing cursor:
---------------------------------------------
OPTIMIZER_MISMATCH: The optimizer environment does not match the existing child cursor
Search WWH ::




Custom Search