| SQL Id | SQL Text |
|---|
| 1421ffggd4x6x |
select * from
(SELECT to_char((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24')as Timestamp,
'DB2UsingCPU' as consumption_type,
SUM(UDAS_USING_CPU_TIME_SUM) "consumption_time"
FROM PW_PWGI_GENERAL_INFORMATION,
PS_INEN_ENVIRONMENT,
PS_INAP_APP_TIER,
PS_INCE_INSTANCE,
PW_UDAS_APPLICATION_STATS_T,
PS_INII_INSTANCE_APPTIER
WHERE UDAS_PWII_INSTANCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INII_INAP_ID = INAP_ID
AND INII_INCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INAP_INEN_ID =INEN_ID
AND ceil(sysdate-to_date(UDAS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
AND INCE_NAME = :1
GROUP BY TO_CHAR((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24')
union all
SELECT to_char((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24') as Timestamp,
'DB2SyncIOWait' as consumption_type,
SUM(UDAS_SYNC_IO_WAIT_TIME_SUM) "consumption_time"
FROM PW_PWGI_GENERAL_INFORMATION,
PS_INEN_ENVIRONMENT,
PS_INAP_APP_TIER,
PS_INCE_INSTANCE,
PW_UDAS_APPLICATION_STATS_T,
PS_INII_INSTANCE_APPTIER
WHERE UDAS_PWII_INSTANCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INII_INAP_ID = INAP_ID
AND INII_INCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INAP_INEN_ID
=INEN_ID
AND ceil(sysdate-to_date(UDAS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
AND INCE_NAME = :2
GROUP BY TO_CHAR((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24')
union all
SELECT to_char((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24') as Timestamp,
'DB2PrefetchWait' as consumption_type,
SUM(UDAS_WAIT_PREFETCH_TIME_SUM) "consumption_time"
FROM PW_PWGI_GENERAL_INFORMATION,
PS_INEN_ENVIRONMENT,
PS_INAP_APP_TIER,
PS_INCE_INSTANCE,
PW_UDAS_APPLICATION_STATS_T,
PS_INII_INSTANCE_APPTIER
WHERE UDAS_PWII_INSTANCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INII_INAP_ID = INAP_ID
AND INII_INCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INAP_INEN_ID =INEN_ID
AND ceil(sysdate-to_date(UDAS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
AND INCE_NAME = :3
GROUP BY TO_CHAR((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24')
union all
SELECT to_char((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24') as Timestamp,
'DB2DirectIOWait' as consumption_type,
SUM(UDAS_DIRECT_IO_WAIT_TIME_SUM) "consumption_time"
FROM PW_PWGI_GENERAL_INFORMATION,
PS_INEN_ENVIRONMENT,
PS_INAP_APP_TIER,
PS_INCE_INSTANCE,
PW_UDAS_APPLICATION_STATS_T,
PS_INII_INSTANCE_APPTIER
WHERE UDAS_PWII_INSTANCE_ID = PS_I
NCE_INSTANCE.INCE_ID
AND INII_INAP_ID = INAP_ID
AND INII_INCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INAP_INEN_ID =INEN_ID
AND ceil(sysdate-to_date(UDAS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
AND INCE_NAME = :4
GROUP BY TO_CHAR((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24')
union all
SELECT to_char((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24') as Timestamp,
'DB2LockWait' as consumption_type,
SUM(UDAS_APPL_LOCK_WAIT_TIME_SUM) "consumption_time"
FROM PW_PWGI_GENERAL_INFORMATION,
PS_INEN_ENVIRONMENT,
PS_INAP_APP_TIER,
PS_INCE_INSTANCE,
PW_UDAS_APPLICATION_STATS_T,
PS_INII_INSTANCE_APPTIER
WHERE UDAS_PWII_INSTANCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INII_INAP_ID = INAP_ID
AND INII_INCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INAP_INEN_ID =INEN_ID
AND ceil(sysdate-to_date(UDAS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
AND INCE_NAME = :5
GROUP BY TO_CHAR((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24')
union all
SELECT to_char((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24') as Timestamp,
'DB2RemoteQueryWait' as consumption_type,
SUM(UDAS_REMOTE_QRY_WAIT_TIME_SUM) "consumption_time&quo
t;
FROM PW_PWGI_GENERAL_INFORMATION,
PS_INEN_ENVIRONMENT,
PS_INAP_APP_TIER,
PS_INCE_INSTANCE,
PW_UDAS_APPLICATION_STATS_T,
PS_INII_INSTANCE_APPTIER
WHERE UDAS_PWII_INSTANCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INII_INAP_ID = INAP_ID
AND INII_INCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INAP_INEN_ID =INEN_ID
AND ceil(sysdate-to_date(UDAS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
AND INCE_NAME = :6
GROUP BY TO_CHAR((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24')
union all
SELECT to_char((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24') as Timestamp,
'DB2UtilityTime' as consumption_type,
SUM(UDAS_UTILITY_ACTIVE_TIME_SUM) "consumption_time"
FROM PW_PWGI_GENERAL_INFORMATION,
PS_INEN_ENVIRONMENT,
PS_INAP_APP_TIER,
PS_INCE_INSTANCE,
PW_UDAS_APPLICATION_STATS_T,
PS_INII_INSTANCE_APPTIER
WHERE UDAS_PWII_INSTANCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INII_INAP_ID = INAP_ID
AND INII_INCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INAP_INEN_ID =INEN_ID
AND ceil(sysdate-to_date(UDAS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
AND INCE_NAME = :7
GROUP BY TO_CH
AR((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24')
union all
SELECT to_char((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24') as Timestamp,
'DB2IOErrorWait' as consumption_type,
SUM(UDAS_IO_ERROR_WAIT_TIME_SUM) "consumption_time"
FROM PW_PWGI_GENERAL_INFORMATION,
PS_INEN_ENVIRONMENT,
PS_INAP_APP_TIER,
PS_INCE_INSTANCE,
PW_UDAS_APPLICATION_STATS_T,
PS_INII_INSTANCE_APPTIER
WHERE UDAS_PWII_INSTANCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INII_INAP_ID = INAP_ID
AND INII_INCE_ID = PS_INCE_INSTANCE.INCE_ID
AND INAP_INEN_ID =INEN_ID
AND ceil(sysdate-to_date(UDAS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
AND INCE_NAME = :8
GROUP BY TO_CHAR((UDAS_TIMESTAMP+8/24), 'YYYY/MM/DD_HH24')
)
order by Timestamp |
| 1bfzmm2bbajqq | UPDATE PW_PWJH_JOB_HISTORY SET PWJH_PWII_ID = :1 , PWJH_END_TIMESTAMP = :2 , PWJH_PROCESSED_OBJECT = :3 , PWJH_SUB_PROCESS = :4 , PWJH_DATA_START_TIMESTAMP = :5 , PWJH_DATA_END_TIMESTAMP = :6 , PWJH_STATUS = :7 , PWJH_ROWS_PROCESSED = :8 , PWJH_ERROR_MESSAGE = :9 , PWJH_FILE_NAME = :10 WHERE PWJH_ID = :11 |
| 1gu8t96d0bdmu | select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) |
| 1jkqtvuahshwr | insert into P$CANTEXTFILE(file_id, file_name, tablespace_name,
file_inc_bytes,
file_avail)
select a.file_id, file_name, a.tablespace_name,
nvl(c.max_free_bytes, 0),
-1
from DBA_DATA_FILES a, P$AUTOEXTTS b, (select file_id, max(bytes) max_free_bytes
from dba_free_space
group by file_id
)c,
SYS.FILEXT$ d
where a.tablespace_name = b.tablespace_name
and a.file_id = c.file_id (+)
and a.file_id = d.file# (+) |
| 1jn1t7wb22nk9 | select 'datapoint: '||count(*) from all_tab_privs
where grantee = 'PATROL' |
| 1y41akzwjytsq | INSERT INTO PS_PWSC_SUMMARY_CONTROLLER (PWSC_PWII_INSTANCE_ID, PWSC_TABLE_NAME, PWSC_DATA_START_TIMESTAMP, PWSC_PROCESS_START_TIMESTAMP) VALUES(:1 , :2 , :3 , :4 ) |
| 1y95zktz71h35 | SELECT PWTR_PWII_ID, PWTR_TABLE_NAME, PWTR_SUMMARY_LEVEL, PWTR_START_TIMESTAMP, PWTR_END_TIMESTAMP FROM PS_PWTR_TABLE_RANGE WHERE PWTR_PWII_ID = :1 AND PWTR_TABLE_NAME = :2 |
| 2anpc942uq2g5 | select owner||'|'||object_name||'|'||object_type||'|'||status from dba_objects where status='INVALID' |
| 2k8rnvzac77sa | select
dbms_lob.substr(udsx_unformatted_text, 4000, 1) as consumer_name,
udss_statement_hv
from pw_udsx_statement_text,
( select * from
( select min(udss_statement_hv) as udss_statement_hv,
min(udss_pwii_instance_id) as udss_pwii_instance_id,
sum(udss_total_indb2_time_sum) as udss_total_indb2_time_sum
from pw_udss_statements_stats_t,
PS_INCE_INSTANCE
where ceil(sysdate-to_date(UDSS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
and
udss_statement_hv != 0 and
INCE_NAME= :1
and ince_id=UDSS_PWII_INSTANCE_ID
and ( 1 = 1 )
group by udss_statement_hv
order by udss_total_indb2_time_sum desc )
where rownum < 21 ) stats
where udsx_statement_hv = stats.udss_statement_hv
order by udss_total_indb2_time_sum desc |
| 2qqznx6a98xv7 | SELECT 1 FROM PW_PWII_INSTANCE_ID WHERE PWII_ID = :1 |
| 2sac8mzhjq5mm |
select /*NORULE */ 'DATA:'||A.FILE#||':'||A.BLOCK#||':' ||
A.MAX_EXT_SIZE||':'||B.MAX_BLOCKS_FREE||':'||A.TS#||':' NOHEAD
from
(SELECT /*NORULE */ TS#, FILE#, BLOCK#, MAX(EXTSIZE) MAX_EXT_SIZE
FROM SYS.SEG$
where TYPE# !=9 GROUP BY TS#, FILE#, BLOCK#) A,
(SELECT /*NORULE */ VB.NAME TABLESPACE_NAME, VB.TS#,
MAX(nvl(VA.BLOCKS, 0)) MAX_BLOCKS_FREE
FROM DBA_FREE_SPACE VA, SYS.TS$ VB
WHERE VB.NAME = VA.TABLESPACE_NAME (+)
AND VB.ONLINE$ != 3
GROUP BY VB.NAME, VB.TS#) B,
(SELECT TS#, FILE#, BLOCK#
FROM P$OBJ_EXCLUSION
WHERE TS# IS NOT NULL
AND FILE# IS NULL
AND BLOCK# IS NULL) C,
(SELECT TS#, FILE#, BLOCK#
FROM P$OBJ_EXCLUSION
WHERE TS# IS NOT NULL
AND FILE# IS NOT NULL
AND BLOCK# IS NOT NULL) S,
(SELECT /*NORULE */ UA.TS# TS#, UA.FILE# FILE#, UA.BLOCK# BLOCK#
FROM SYS.SEG$ UA, P$OBJ_EXCLUSION UB
WHERE UB.USER# IS NOT NULL
AND UA.USER# = UB.USER#) U,
(SELECT A.TS# TS#, NULL FILE#, NULL BLOCK#
FROM SYS.FILE$ A, SYS.FILEXT$ B
WHERE A.FILE# = B.FILE#) D,
( SELECT /*NORULE */ TABLESPACE_NAME
FROM DBA_TABLESPACES
WHERE STATUS = 'ONLINE'
AND CONTENTS = 'PERMANENT'
AND (EXTENT_MANAGEMENT = 'LOCAL' AND ALLOCATION_TYPE IN ('UNIFORM', 'USER') OR EXTENT_MANAGEMENT = 'DICTIONARY')
) E
WHERE A.TS# = B.TS#
AND A.MAX_EXT_SIZE > B.MAX_BLOCKS_FREE
AND B.MAX_BLOCKS_FREE > 0
AND A.TS# = C.TS#(+)
AND C.TS# IS NULL
AND A.TS# = S.TS# (+)
AND A.FILE# = S.FILE# (+)
AND A.BLOCK# = S.BLO
CK# (+)
AND S.TS# IS NULL
AND S.FILE# IS NULL
AND S.BLOCK# IS NULL
AND A.TS# = U.TS# (+)
AND A.FILE# = U.FILE# (+)
AND A.BLOCK# = U.BLOCK# (+)
AND U.TS# IS NULL
AND U.FILE# IS NULL
AND U.BLOCK# IS NULL
AND A.TS# = D.TS#(+)
AND D.TS# IS NULL
AND B.TABLESPACE_NAME = E.TABLESPACE_NAME |
| 307fr7b35zfr9 | UPDATE PS_PWTR_TABLE_RANGE SET PWTR_END_TIMESTAMP = :1 WHERE PWTR_PWII_ID = :2 AND PWTR_TABLE_NAME = :3 AND PWTR_SUMMARY_LEVEL = :4 |
| 350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
| 4pxq205ftyan4 |
select * from
(select min(udss_statement_hv) as udss_statement_hv,
sum(udss_total_indb2_time_sum) as udss_total_indb2_time_sum,
sum(sum(udss_total_indb2_time_sum)) over() as udss_in_db2_time_parent_sum,
sum(udss_executions_stats_sum) as udss_executions_stats_sum,
sum(udss_using_cpu_time_sum) as udss_using_cpu_time_sum,
sum(udss_wait_for_cpu_time_sum) as udss_wait_for_cpu_time_sum,
sum(udss_sync_io_wait_time_sum) as udss_sync_io_wait_time_sum,
sum(udss_direct_io_wait_time_sum) as udss_direct_io_wait_time_sum,
sum(udss_wait_prefetch_time_sum) as udss_wait_prefetch_time_sum,
sum(udss_appl_lock_wait_time_sum) as udss_lock_wait_sum,
sum(udss_io_error_wait_time_sum) as udss_io_error_wait_sum,
sum(udss_remote_qry_wait_time_sum) as udss_remote_qry_wait_sum,
sum(udss_utility_active_time_sum) as udss_utility_active_time_sum
from pw_udss_statements_stats_t,
PS_INCE_INSTANCE
where ceil(sysdate-to_date(UDSS_TIMESTAMP+8/24, 'DD/MON/YY'))=2
and
udss_statement_hv != 0 and
INCE_NAME= :1
and ince_id=UDSS_PWII_INSTANCE_ID
and ( 1 = 1 )
group by udss_statement_hv)
where rownum < 21
order by udss_total_indb2_time_sum desc |
| 4wc07syr5x7wn |
WITH DAILY_STMT_STATS
AS (
SELECT
UDSS_PWII_INSTANCE_ID,
UDSS_STATEMENT_HV,
UDSS_PWHG_ID,
UDSS_CLUSTER_ID,
MAX(TRUNC(UDSS_TIMESTAMP)) AS UDSS_TIMESTAMP,
SUM(UDSS_TOTAL_INDB2_TIME_SUM - UDSS_APPL_LOCK_WAIT_TIME_SUM) AS TOTAL_INDB2_TIME,
SUM(UDSS_SYNC_IO_WAIT_TIME_SUM + UDSS_WAIT_PREFETCH_TIME_SUM + UDSS_DIRECT_IO_WAIT_TIME_SUM) AS TOTAL_IO_WAIT
FROM
PW_UDSS_STATEMENTS_STATS_T
WHERE
UDSS_PWII_INSTANCE_ID = 1107
AND UDSS_TIMESTAMP >= TO_DATE(:1 , 'DD/MM/YYYY')
AND UDSS_TIMESTAMP < TO_DATE(:2 , 'DD/MM/YYYY') + 1
GROUP BY UDSS_PWII_INSTANCE_ID, UDSS_STATEMENT_HV, UDSS_PWHG_ID, UDSS_CLUSTER_ID
)
SELECT /*+ ordered */
UDSS_PWII_INSTANCE_ID AS UDOU_PWII_INSTANCE_ID,
UDSS_TIMESTAMP AS UDOU_TIMESTAMP,
UDSS_PWHG_ID AS UDOU_PWHG_ID,
NVL(UDEJ_BASE_SCHEMA_NAME, UDEJ_SCHEMA_NAME) || '.' || NVL(UDEJ_BASE_TABLE_NAME, UDEJ_OBJECT_NAME) AS UDOU_FULL_BASE_OBJECT_ID,
UDEJ_SCHEMA_NAME || '.' || UDEJ_OBJECT_NAME AS UDOU_FULL_OBJECT_ID,
UDEJ_OBJECT_TYPE AS UDOU_OBJECT_TYPE,
cast(SUM(TOTAL_INDB2_TIME * UDEJ_CONTRIBUTION_RATIO) as number(15, 2)) AS UDOU_TOTAL_INDB2_TIME_SUM,
cast(SUM(
CASE UDEJ_PRE_FETCH
WHEN 'LIST' THEN
TOTAL_IO_WAIT * UDEJ_CONTRIBUTION_RATIO
ELSE
0
END) as number(15, 2)) AS UDOU_PRE_FETCH_LIST_SUM,
cast(SUM(
CASE UDEJ_PRE_FETCH
WHEN 'SEQUENTIAL' THEN
TOTAL_IO_WAIT * UDEJ_CONT
RIBUTION_RATIO
ELSE
0
END) as number(15, 2)) AS UDOU_PRE_FETCH_SEQ_SUM,
cast(SUM(
CASE UDEJ_PRE_FETCH
WHEN 'NONE' THEN
TOTAL_IO_WAIT * UDEJ_CONTRIBUTION_RATIO
ELSE
0
END) as number(15, 2)) AS UDOU_PRE_FETCH_NO_SUM
FROM
DAILY_STMT_STATS,
PW_UDEJ_EXPLAIN_OBJECT
WHERE
UDSS_CLUSTER_ID = UDEJ_CLUSTER_ID
AND UDSS_STATEMENT_HV = UDEJ_STATEMENT_HV
AND UDEJ_LAST_EXPLAIN_IND = 'Y'
GROUP BY
UDSS_PWII_INSTANCE_ID,
UDSS_TIMESTAMP,
UDSS_PWHG_ID,
UDEJ_BASE_SCHEMA_NAME,
UDEJ_BASE_TABLE_NAME,
UDEJ_SCHEMA_NAME,
UDEJ_OBJECT_NAME,
UDEJ_OBJECT_TYPE
|
| 5hzzdtvdtpb1r | insert into P$CANTEXTMAXTBSP
select /*NORULE */ c.tablespace_name,
max(a.extsize * 8192) max_seg_next_extent,
-1 max_free_bytes
from SYS.SEG$ a,
P$AUTOEXTTS c,
SYS.TS$ f
where a.ts# = f.ts# and a.TYPE# !=9
and f.name = c.tablespace_name
and c.allocation_type <> 'SYSTEM'
and not exists(select /*NORULE */ 'X'
from P$OBJ_EXCLUSION g
where ( g.TS# = a.TS#
or g.TS# is NULL )
and ( g.FILE# = a.FILE#
or g.FILE# is NULL )
and ( g.BLOCK# = a.BLOCK#
or g.BLOCK# is NULL)
and ( g.USER# = a.USER#
or g.USER# is NULL))
group by c.tablespace_name |
| 6uvzftsujw5s6 |
select /*NORULE */ 'DATA:'||A.FILE#||':'||A.BLOCK#||':' ||
A.MAX_EXT_SIZE||':'||B.MAX_BLOCKS_FREE||':'||A.TS#||':' NOHEAD
from
(SELECT /*NORULE */ TS#, FILE#, BLOCK#,
MAX(decode(1,
sign(trunc(blocks*8192 / (1048576*1024))), 67108864,
sign(trunc(blocks*8192 / (67108864))), 8388608,
sign(trunc(blocks*8192 / (1048576))), 1048576,
sign(trunc(blocks*8192 / (65536))), 65536))/8192
MAX_EXT_SIZE
FROM SYS.SEG$
GROUP BY TS#, FILE#, BLOCK#) A,
(SELECT /*NORULE */ VB.NAME TABLESPACE_NAME, VB.TS#,
MAX(nvl(VA.BLOCKS, 0)) MAX_BLOCKS_FREE
FROM DBA_FREE_SPACE VA, SYS.TS$ VB
WHERE VB.NAME = VA.TABLESPACE_NAME (+)
AND VB.ONLINE$ != 3
GROUP BY VB.NAME, VB.TS#) B,
(SELECT TS#, FILE#, BLOCK#
FROM P$OBJ_EXCLUSION
WHERE TS# IS NOT NULL
AND FILE# IS NULL
AND BLOCK# IS NULL) C,
(SELECT TS#, FILE#, BLOCK#
FROM P$OBJ_EXCLUSION
WHERE TS# IS NOT NULL
AND FILE# IS NOT NULL
AND BLOCK# IS NOT NULL) S,
(SELECT /*NORULE */ UA.TS# TS#, UA.FILE# FILE#, UA.BLOCK# BLOCK#
FROM SYS.SEG$ UA, P$OBJ_EXCLUSION UB
WHERE UB.USER# IS NOT NULL
AND UA.USER# = UB.USER#) U,
(SELECT A.TS# TS#, NULL FILE#, NULL BLOCK#
FROM SYS.FILE$ A, SYS.FILEXT$ B
WHERE A.FILE# = B.FILE#) D,
(SELECT /*NORULE */ TABLESPACE_NAME
FROM DBA_TABLESPACES
WHERE STATUS = 'ONLINE'
AND CONTENTS = 'PERMANENT'
AND (EXTENT_MANAGEMENT = '
LOCAL' AND ALLOCATION_TYPE = 'SYSTEM')) E
WHERE A.TS# = B.TS#
AND A.MAX_EXT_SIZE > B.MAX_BLOCKS_FREE
AND B.MAX_BLOCKS_FREE > 0
AND A.TS# = C.TS#(+)
AND C.TS# IS NULL
AND A.TS# = S.TS# (+)
AND A.FILE# = S.FILE# (+)
AND A.BLOCK# = S.BLOCK# (+)
AND S.TS# IS NULL
AND S.FILE# IS NULL
AND S.BLOCK# IS NULL
AND A.TS# = U.TS# (+)
AND A.FILE# = U.FILE# (+)
AND A.BLOCK# = U.BLOCK# (+)
AND U.TS# IS NULL
AND U.FILE# IS NULL
AND U.BLOCK# IS NULL
AND A.TS# = D.TS#(+)
AND D.TS# IS NULL
AND B.TABLESPACE_NAME = E.TABLESPACE_NAME |
| 7azwf296swz7q | SELECT UDFN_ID FROM PW_UDFN_OBJECTS_FULL_NAMES_N WHERE UDFN_HASH_VALUE = cast(:1 as decimal (20, 0)) |
| 8mrg623amm8rx |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL
LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
|
| 8n4w5dup2qs91 | select * from
(select * from
(select udfn_string_value as object_name,
udou_object_type as object_type,
udou_pre_fetch_no_sum as no_prefetch_i0,
udou_pre_fetch_seq_sum as sequential_prefetch_io,
udou_pre_fetch_list_sum as list_prefetch_io,
udou_total_indb2_time_sum as in_db2_time
from pw_udou_objects_usage_d,
pw_udfn_objects_full_names_n,
ps_ince_instance
where udou_full_object_id=udfn_id
AND ceil(sysdate-to_date(UDOU_TIMESTAMP+8/24, 'DD/MON/YY'))=2
and ince_name=:1
and ince_id=udou_pwii_instance_id)
where rownum <= 20
order by in_db2_time desc)
order by in_db2_time desc |
| 9babjv8yq8ru3 | BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END; |
| 9ccf9ygspmv2v | INSERT INTO PW_PWJH_JOB_HISTORY (PWJH_ID, PWJH_PWJG_ID, PWJH_PWII_ID, PWJH_BEGIN_TIMESTAMP, PWJH_PROCESSED_OBJECT, PWJH_DATA_START_TIMESTAMP, PWJH_DATA_END_TIMESTAMP, PWJH_END_TIMESTAMP, PWJH_STATUS, PWJH_ROWS_PROCESSED, PWJH_SUB_PROCESS, PWJH_PWSE_ID) VALUES (:1 , :2 , :3 , :4 , :5 , NULL, NULL, NULL, :6 , 0, :7 , :8 ) |
| aax60m72xjsnh |
SELECT
DISTINCT TO_CHAR(TRUNC(UDSS_TIMESTAMP), 'DD/MM/YYYY') AS DIFF_TIMESTAMP
FROM PW_UDSS_STATEMENTS_STATS_T
WHERE UDSS_PWII_INSTANCE_ID = 1107
AND UDSS_TIMESTAMP > sysdate - 30
AND UDSS_TIMESTAMP < TRUNC(SYSDATE)
AND NOT EXISTS
( SELECT 1
FROM PW_UDOU_OBJECTS_USAGE_D
WHERE UDOU_PWII_INSTANCE_ID = UDSS_PWII_INSTANCE_ID
AND TRUNC(UDSS_TIMESTAMP) = TRUNC(UDOU_TIMESTAMP)
)
ORDER BY 1 DESC
|
| bunvx480ynf57 | SELECT 1 FROM DUAL |
| c8s7zc64avpm8 |
WITH DAILY_STMT_STATS
AS (
SELECT
UDSS_PWII_INSTANCE_ID,
UDSS_STATEMENT_HV,
UDSS_PWHG_ID,
UDSS_CLUSTER_ID,
MAX(TRUNC(UDSS_TIMESTAMP)) AS UDSS_TIMESTAMP,
SUM(UDSS_TOTAL_INDB2_TIME_SUM - UDSS_APPL_LOCK_WAIT_TIME_SUM) AS TOTAL_INDB2_TIME,
SUM(UDSS_SYNC_IO_WAIT_TIME_SUM + UDSS_WAIT_PREFETCH_TIME_SUM + UDSS_DIRECT_IO_WAIT_TIME_SUM) AS TOTAL_IO_WAIT
FROM
PW_UDSS_STATEMENTS_STATS_T
WHERE
UDSS_PWII_INSTANCE_ID = 1309
AND UDSS_TIMESTAMP >= TO_DATE(:1 , 'DD/MM/YYYY')
AND UDSS_TIMESTAMP < TO_DATE(:2 , 'DD/MM/YYYY') + 1
GROUP BY UDSS_PWII_INSTANCE_ID, UDSS_STATEMENT_HV, UDSS_PWHG_ID, UDSS_CLUSTER_ID
)
SELECT /*+ ordered */
UDSS_PWII_INSTANCE_ID AS UDOU_PWII_INSTANCE_ID,
UDSS_TIMESTAMP AS UDOU_TIMESTAMP,
UDSS_PWHG_ID AS UDOU_PWHG_ID,
NVL(UDEJ_BASE_SCHEMA_NAME, UDEJ_SCHEMA_NAME) || '.' || NVL(UDEJ_BASE_TABLE_NAME, UDEJ_OBJECT_NAME) AS UDOU_FULL_BASE_OBJECT_ID,
UDEJ_SCHEMA_NAME || '.' || UDEJ_OBJECT_NAME AS UDOU_FULL_OBJECT_ID,
UDEJ_OBJECT_TYPE AS UDOU_OBJECT_TYPE,
cast(SUM(TOTAL_INDB2_TIME * UDEJ_CONTRIBUTION_RATIO) as number(15, 2)) AS UDOU_TOTAL_INDB2_TIME_SUM,
cast(SUM(
CASE UDEJ_PRE_FETCH
WHEN 'LIST' THEN
TOTAL_IO_WAIT * UDEJ_CONTRIBUTION_RATIO
ELSE
0
END) as number(15, 2)) AS UDOU_PRE_FETCH_LIST_SUM,
cast(SUM(
CASE UDEJ_PRE_FETCH
WHEN 'SEQUENTIAL' THEN
TOTAL_IO_WAIT * UDEJ_CONT
RIBUTION_RATIO
ELSE
0
END) as number(15, 2)) AS UDOU_PRE_FETCH_SEQ_SUM,
cast(SUM(
CASE UDEJ_PRE_FETCH
WHEN 'NONE' THEN
TOTAL_IO_WAIT * UDEJ_CONTRIBUTION_RATIO
ELSE
0
END) as number(15, 2)) AS UDOU_PRE_FETCH_NO_SUM
FROM
DAILY_STMT_STATS,
PW_UDEJ_EXPLAIN_OBJECT
WHERE
UDSS_CLUSTER_ID = UDEJ_CLUSTER_ID
AND UDSS_STATEMENT_HV = UDEJ_STATEMENT_HV
AND UDEJ_LAST_EXPLAIN_IND = 'Y'
GROUP BY
UDSS_PWII_INSTANCE_ID,
UDSS_TIMESTAMP,
UDSS_PWHG_ID,
UDEJ_BASE_SCHEMA_NAME,
UDEJ_BASE_TABLE_NAME,
UDEJ_SCHEMA_NAME,
UDEJ_OBJECT_NAME,
UDEJ_OBJECT_TYPE
|
| cc9dwckq9z07u |
select * from
(select UDSM_PARSING_USER, UDSX_STATEMENT_TEXT, UDSM_ACCESS_PATH_HV, UDSM_TOTAL_ESTIMATED_COST, UDSM_EXPLAIN_ERROR_MSG
from PW_UDSM_STATEMENTS,
PW_UDSX_STATEMENT_TEXT
where UDSM_CLUSTER_ID = :1
and UDSM_STATEMENT_HV = :2
and UDSM_STATEMENT_HV = UDSX_STATEMENT_HV
)
where rownum < 2
|
| ccqdwj3nn4zsj |
select UDSM_STATEMENT_HV from
(
select
UDSM_STATEMENT_HV,
sum(UDSS_TOTAL_INDB2_TIME_SUM)
from PW_UDSS_STATEMENTS_STATS_T inner join PW_UDSM_STATEMENTS
on UDSM_CLUSTER_ID = UDSS_CLUSTER_ID
and UDSS_PWII_INSTANCE_ID = UDSM_PWII_INSTANCE_ID
and UDSM_STATEMENT_HV = UDSS_STATEMENT_HV
and UDSM_DO_NOT_EXPLAIN = 'N'
and UDSM_SOURCE = 'C'
and UDSM_LAST_EXPLAINED is null
where UDSS_CLUSTER_ID = :1
and UDSS_TIMESTAMP >= :2 - (:3 /1440)
group by UDSM_STATEMENT_HV
order by sum(UDSS_TOTAL_INDB2_TIME_SUM) desc
)
where rownum < :4
|
| d564m67yc8p28 |
select * from
(
select UDSM_STATEMENT_HV,
UDSM_PARSING_USER,
UDSM_ACCESS_PATH_HV,
current_timestamp,
max(( to_char(current_timestamp, 'dd') - coalesce(to_char(UDSM_LAST_EXPLAINED, 'dd'),
to_char(current_timestamp-:1 , 'dd')))*samp.total_indb2_time)
from (select * from (select max(s.UDSS_PWII_INSTANCE_ID) as UDSS_PWII_INSTANCE_ID,
s.UDSS_STATEMENT_HV,
sum(cast(s.UDSS_TOTAL_INDB2_TIME_SUM as number(9))) total_indb2_time
from PW_UDSS_STATEMENTS_STATS_T s
left outer join (
select coalesce(max(g.pwjg_begin_timestamp), current_timestamp - cast (:2 as numeric)) as last_explain_time
from PW_PWJG_JOB_GROUP g,
PW_PWJH_JOB_HISTORY h,
PS_UDDA_ACT_INS_DATA i
where g.PWJG_ID = h.PWJH_PWJG_ID
and g.PWJG_PWSE_ID=61
and g.PWJG_STATUS = 'OK'
and i.UDDA_INSTANCE_ID = h.pwjh_pwii_id
and i.UDDA_INCL_ID = :3
) a on (1=1)
where s.UDSS_CLUSTER_ID = :4
and s.UDSS_TIMESTAMP >= last_explain_time
and s.UDSS_STATEMENT_HV <> 0
group by s.UDSS_STATEMENT_HV) where rownum < :5 *3
) samp
inner join
PW_UDSM_STATEMENTS on
UDSM_CLUSTER_ID = :6
and UDSM_PWII_INSTANCE_ID = samp.UDSS_PWII_INSTANCE_ID
and UDSM_STATEMENT_HV = samp.UDSS_STATEMENT_HV
where coalesce (UDSM_LAST_EXPLAINED, to_date('1900-01-01', 'yyyy-mm-dd')) < current_timestamp - cast ( :7 as numeric)
and
UDSM_DO_NOT_EXPLAIN = 'N'
and UDSM_SOURCE = 'C'
group by UDSM_STATEMENT_HV , UDSM_PARSING_USER , UDSM_ACCESS_PATH_HV
order by max( to_char(current_timestamp, 'dd') -
coalesce(to_char(UDSM_LAST_EXPLAINED, 'dd'), to_char(current_timestamp-:8 , 'dd'))*samp.total_indb2_time) desc
)
where rownum < :9
|
| d5gr0tpsjj13a |
INSERT INTO PW_UDEO_EXPLAIN_OPER
( UDEO_CLUSTER_ID, UDEO_STATEMENT_HV, UDEO_EXPLAIN_TIME, UDEO_OPERATOR_ID, UDEO_OPERATOR_TYPE, UDEO_OPTIONS, UDEO_PRE_FETCH,
UDEO_EXECUTION_ORDER, UDEO_TREE_LEVEL, UDEO_ARGUMENTS_LIST, UDEO_REMOTE_QUERY_HV, UDEO_OBJECT_SCHEMA_NAME, UDEO_OBJECT_NAME,
UDEO_OBJECT_TYPE, UDEO_BASE_SCHEMA_NAME, UDEO_BASE_TABLE_NAME, UDEO_TOTAL_ESTIMATED_COST, UDEO_FIRST_ROW_COST,
UDEO_ESTIMATED_IO_COST, UDEO_ESTIMATED_CPU_COST, UDEO_ESTIMATED_COMM_COST, UDEO_CONTRIBUTION_RATIO, UDEO_PARENT_OP_ID,
UDEO_FILTER_FACTOR, UDEO_MAX_ROWS, UDEO_MAX_PAGES, UDEO_PART_NUM, UDEO_LAST_EXPLAIN_IND, UDEO_MAX_EXECUTION_ORDER, UDEO_HAS_CHILD, UDEO_SONS_LIST, UDEO_TOTAL_COST_PERCENT)
VALUES
(:1 , :2 , :3 , :4 , :5 , :6 , :7 ,
:8 , :9 , :10 , :11 , :12 , :13 ,
:14 , :15 , :16 , :17 , :18 ,
:19 , :20 , :21 , :22 , :23 ,
:24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 )
|
| f54d62ubt511v |
declare
error boolean;
st_syn_detected EXCEPTION;
PRAGMA EXCEPTION_INIT(st_syn_detected, -995);
BEGIN
if((sys.dbms_standard.dictionary_obj_type != 'SYNONYM')or(sys.dbms_standard.dictionary_obj_owner != 'PUBLIC'))
then
return;
end if;
error :=
CASE sys.dbms_standard.dictionary_obj_name
WHEN 'ST_GEOMETRY' THEN TRUE
WHEN 'ST_SURFACE' THEN TRUE
WHEN 'ST_POLYGON' THEN TRUE
WHEN 'ST_POINT' THEN TRUE
WHEN 'ST_MULTISURFACE' THEN TRUE
WHEN 'ST_MULTIPOINT' THEN TRUE
WHEN 'ST_MULTILINESTRING' THEN TRUE
WHEN 'ST_MULTICURVE' THEN TRUE
WHEN 'ST_LINESTRING' THEN TRUE
WHEN 'ST_GEOMCOLLECTION' THEN TRUE
WHEN 'ST_CURVE' THEN TRUE
WHEN 'ST_CURVEPOLYGON' THEN TRUE
WHEN 'ST_COMPOUNDCURVE' THEN TRUE
WHEN 'ST_CIRCULARSTRING' THEN TRUE
WHEN 'ST_INTERSECTS' THEN TRUE
WHEN 'ST_RELATE' THEN TRUE
WHEN 'ST_TOUCH' THEN TRUE
WHEN 'ST_CONTAINS' THEN TRUE
WHEN 'ST_COVERS' THEN TRUE
WHEN 'ST_COVEREDBY' THEN TRUE
WHEN 'ST_INSIDE' THEN TRUE
WHEN 'ST_OVERLAP' THEN TRUE
WHEN 'ST_OVERLAPS' THEN TRUE
WHEN 'ST_EQUAL' THEN TRUE
WHEN 'ST_OVERLAPBDYDISJOINT' THEN TRUE
WHEN 'ST_OVERLAPBDYINTERSECT' THEN TRUE
WHEN 'ST_GEOMETRY_ARRAY' THEN TRUE
WHEN 'ST_POINT_ARRAY' THEN TRUE
WHEN 'ST_CURVE_ARRAY' THEN TRUE
WHEN 'ST_SURFACE_A
RRAY' THEN TRUE
WHEN 'ST_LINESTRING_ARRAY' THEN TRUE
WHEN 'ST_POLYGON_ARRAY' THEN TRUE
ELSE FALSE
END;
if(error) then
raise st_syn_detected;
end if;
END; |
| g00cj285jmgsw | update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn |
| g4nyrfxtg1pg1 | INSERT INTO PW_UDSX_STATEMENT_TEXT(UDSX_STATEMENT_HV, UDSX_CONSISTENT_HV, UDSX_STATEMENT_TEXT, UDSX_UNFORMATTED_TEXT) VALUES (:1 , :2 , :3 , :4 ) |
| Statistic | Total | per Second | per Trans |
|---|
| CPU used by this session | 37,621 | 3.50 | 1.51 |
| CPU used when call started | 36,228 | 3.37 | 1.45 |
| CR blocks created | 1,368 | 0.13 | 0.05 |
| Cached Commit SCN referenced | 0 | 0.00 | 0.00 |
| Commit SCN cached | 0 | 0.00 | 0.00 |
| DB time | 95,298 | 8.86 | 3.82 |
| DBWR checkpoint buffers written | 68,406 | 6.36 | 2.74 |
| DBWR checkpoints | 50 | 0.00 | 0.00 |
| DBWR object drop buffers written | 384 | 0.04 | 0.02 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 269 | 0.02 | 0.01 |
| DBWR undo block writes | 7,448 | 0.69 | 0.30 |
| IMU CR rollbacks | 15 | 0.00 | 0.00 |
| IMU Flushes | 4,698 | 0.44 | 0.19 |
| IMU Redo allocation size | 8,162,612 | 758.48 | 326.99 |
| IMU commits | 15,190 | 1.41 | 0.61 |
| IMU contention | 461 | 0.04 | 0.02 |
| IMU ktichg flush | 3,357 | 0.31 | 0.13 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 27 | 0.00 | 0.00 |
| IMU undo allocation size | 59,274,560 | 5,507.88 | 2,374.50 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| Misses for writing mapping | 0 | 0.00 | 0.00 |
| PX local messages recv'd | 0 | 0.00 | 0.00 |
| PX local messages sent | 0 | 0.00 | 0.00 |
| RowCR - row contention | 1 | 0.00 | 0.00 |
| RowCR attempts | 251 | 0.02 | 0.01 |
| RowCR hits | 248 | 0.02 | 0.01 |
| SMON posted for undo segment shrink | 3 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 143,091 | 13.30 | 5.73 |
| active txn count during cleanout | 5,272 | 0.49 | 0.21 |
| application wait time | 149 | 0.01 | 0.01 |
| background checkpoints completed | 0 | 0.00 | 0.00 |
| background checkpoints started | 0 | 0.00 | 0.00 |
| background timeouts | 34,650 | 3.22 | 1.39 |
| branch node splits | 1 | 0.00 | 0.00 |
| buffer is not pinned count | 638,447 | 59.33 | 25.58 |
| buffer is pinned count | 8,143,156 | 756.67 | 326.21 |
| bytes received via SQL*Net from client | 91,913,417 | 8,540.73 | 3,681.99 |
| bytes sent via SQL*Net to client | 33,752,698 | 3,136.35 | 1,352.11 |
| calls to get snapshot scn: kcmgss | 6,401,539 | 594.84 | 256.44 |
| calls to kcmgas | 36,624 | 3.40 | 1.47 |
| calls to kcmgcs | 4,957 | 0.46 | 0.20 |
| change write time | 272 | 0.03 | 0.01 |
| cleanout - number of ktugct calls | 7,102 | 0.66 | 0.28 |
| cleanouts and rollbacks - consistent read gets | 37 | 0.00 | 0.00 |
| cleanouts only - consistent read gets | 313 | 0.03 | 0.01 |
| cluster key scan block gets | 52,446 | 4.87 | 2.10 |
| cluster key scans | 35,302 | 3.28 | 1.41 |
| commit batch/immediate performed | 80 | 0.01 | 0.00 |
| commit batch/immediate requested | 80 | 0.01 | 0.00 |
| commit cleanout failures: block lost | 4,210 | 0.39 | 0.17 |
| commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 416 | 0.04 | 0.02 |
| commit cleanout failures: cannot pin | 743 | 0.07 | 0.03 |
| commit cleanouts | 123,940 | 11.52 | 4.96 |
| commit cleanouts successfully completed | 118,571 | 11.02 | 4.75 |
| commit immediate performed | 80 | 0.01 | 0.00 |
| commit immediate requested | 80 | 0.01 | 0.00 |
| commit txn count during cleanout | 3,992 | 0.37 | 0.16 |
| concurrency wait time | 104 | 0.01 | 0.00 |
| consistent changes | 29,660 | 2.76 | 1.19 |
| consistent gets | 8,878,943 | 825.04 | 355.68 |
| consistent gets - examination | 695,965 | 64.67 | 27.88 |
| consistent gets direct | 967 | 0.09 | 0.04 |
| consistent gets from cache | 8,877,976 | 824.95 | 355.65 |
| current blocks converted for CR | 0 | 0.00 | 0.00 |
| cursor authentications | 30 | 0.00 | 0.00 |
| data blocks consistent reads - undo records applied | 870 | 0.08 | 0.03 |
| db block changes | 505,823 | 47.00 | 20.26 |
| db block gets | 552,682 | 51.36 | 22.14 |
| db block gets direct | 695 | 0.06 | 0.03 |
| db block gets from cache | 551,987 | 51.29 | 22.11 |
| deferred (CURRENT) block cleanout applications | 61,502 | 5.71 | 2.46 |
| dirty buffers inspected | 1,009 | 0.09 | 0.04 |
| enqueue conversions | 2,418 | 0.22 | 0.10 |
| enqueue deadlocks | 0 | 0.00 | 0.00 |
| enqueue releases | 183,726 | 17.07 | 7.36 |
| enqueue requests | 183,726 | 17.07 | 7.36 |
| enqueue timeouts | 0 | 0.00 | 0.00 |
| enqueue waits | 79 | 0.01 | 0.00 |
| exchange deadlocks | 28 | 0.00 | 0.00 |
| execute count | 142,893 | 13.28 | 5.72 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| free buffer inspected | 182,328 | 16.94 | 7.30 |
| free buffer requested | 179,655 | 16.69 | 7.20 |
| heap block compress | 512 | 0.05 | 0.02 |
| hot buffers moved to head of LRU | 76,488 | 7.11 | 3.06 |
| immediate (CR) block cleanout applications | 350 | 0.03 | 0.01 |
| immediate (CURRENT) block cleanout applications | 15,352 | 1.43 | 0.61 |
| index crx upgrade (found) | 31 | 0.00 | 0.00 |
| index crx upgrade (positioned) | 37,960 | 3.53 | 1.52 |
| index fast full scans (full) | 46 | 0.00 | 0.00 |
| index fetch by key | 1,466,406 | 136.26 | 58.74 |
| index scans kdiixs1 | 271,907 | 25.27 | 10.89 |
| leaf node 90-10 splits | 626 | 0.06 | 0.03 |
| leaf node splits | 1,863 | 0.17 | 0.07 |
| lob reads | 242 | 0.02 | 0.01 |
| lob writes | 1,151 | 0.11 | 0.05 |
| lob writes unaligned | 565 | 0.05 | 0.02 |
| logons cumulative | 187 | 0.02 | 0.01 |
| messages received | 54,922 | 5.10 | 2.20 |
| messages sent | 54,922 | 5.10 | 2.20 |
| no buffer to keep pinned count | 435,787 | 40.49 | 17.46 |
| no work - consistent read gets | 1,868,162 | 173.59 | 74.84 |
| opened cursors cumulative | 133,886 | 12.44 | 5.36 |
| parse count (failures) | 0 | 0.00 | 0.00 |
| parse count (hard) | 3,659 | 0.34 | 0.15 |
| parse count (total) | 136,742 | 12.71 | 5.48 |
| parse time cpu | 622 | 0.06 | 0.02 |
| parse time elapsed | 1,118 | 0.10 | 0.04 |
| physical read IO requests | 128,876 | 11.98 | 5.16 |
| physical read bytes | 1,332,191,232 | 123,789.10 | 53,366.63 |
| physical read total IO requests | 153,568 | 14.27 | 6.15 |
| physical read total bytes | 1,736,474,624 | 161,355.69 | 69,561.94 |
| physical read total multi block requests | 3,333 | 0.31 | 0.13 |
| physical reads | 162,621 | 15.11 | 6.51 |
| physical reads cache | 161,519 | 15.01 | 6.47 |
| physical reads cache prefetch | 33,423 | 3.11 | 1.34 |
| physical reads direct | 1,102 | 0.10 | 0.04 |
| physical reads direct (lob) | 622 | 0.06 | 0.02 |
| physical reads direct temporary tablespace | 255 | 0.02 | 0.01 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 39,385 | 3.66 | 1.58 |
| physical write bytes | 584,515,584 | 54,314.02 | 23,415.28 |
| physical write total IO requests | 68,971 | 6.41 | 2.76 |
| physical write total bytes | 933,662,208 | 86,757.22 | 37,401.84 |
| physical write total multi block requests | 26,147 | 2.43 | 1.05 |
| physical writes | 71,352 | 6.63 | 2.86 |
| physical writes direct | 950 | 0.09 | 0.04 |
| physical writes direct (lob) | 695 | 0.06 | 0.03 |
| physical writes direct temporary tablespace | 255 | 0.02 | 0.01 |
| physical writes from cache | 70,402 | 6.54 | 2.82 |
| physical writes non checkpoint | 18,678 | 1.74 | 0.75 |
| pinned buffers inspected | 0 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
| process last non-idle time | 10,931 | 1.02 | 0.44 |
| recursive calls | 321,598 | 29.88 | 12.88 |
| recursive cpu usage | 919 | 0.09 | 0.04 |
| redo blocks written | 286,599 | 26.63 | 11.48 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 233,936 | 21.74 | 9.37 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 7,330 | 0.68 | 0.29 |
| redo size | 137,450,092 | 12,772.06 | 5,506.15 |
| redo subscn max counts | 20,023 | 1.86 | 0.80 |
| redo synch time | 18,191 | 1.69 | 0.73 |
| redo synch writes | 19,965 | 1.86 | 0.80 |
| redo wastage | 4,592,124 | 426.71 | 183.96 |
| redo write time | 7,854 | 0.73 | 0.31 |
| redo writer latching time | 1 | 0.00 | 0.00 |
| redo writes | 16,445 | 1.53 | 0.66 |
| rollback changes - undo records applied | 113 | 0.01 | 0.00 |
| rollbacks only - consistent read gets | 829 | 0.08 | 0.03 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 61,755 | 5.74 | 2.47 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 99,417 | 9.24 | 3.98 |
| session logical reads | 9,431,625 | 876.40 | 377.82 |
| shared hash latch upgrades - no wait | 43,929 | 4.08 | 1.76 |
| shared hash latch upgrades - wait | 32 | 0.00 | 0.00 |
| sorts (memory) | 34,987 | 3.25 | 1.40 |
| sorts (rows) | 6,209,497 | 577.00 | 248.75 |
| sql area evicted | 206 | 0.02 | 0.01 |
| sql area purged | 3,413 | 0.32 | 0.14 |
| summed dirty queue length | 3,697 | 0.34 | 0.15 |
| switch current to new buffer | 212 | 0.02 | 0.01 |
| table fetch by rowid | 2,729,607 | 253.64 | 109.35 |
| table fetch continued row | 1,517 | 0.14 | 0.06 |
| table scan blocks gotten | 1,015,344 | 94.35 | 40.67 |
| table scan rows gotten | 47,252,097 | 4,390.73 | 1,892.89 |
| table scans (cache partitions) | 0 | 0.00 | 0.00 |
| table scans (long tables) | 114 | 0.01 | 0.00 |
| table scans (short tables) | 2,148,847 | 199.67 | 86.08 |
| total number of times SMON posted | 3 | 0.00 | 0.00 |
| transaction rollbacks | 80 | 0.01 | 0.00 |
| transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
| undo change vector size | 43,617,068 | 4,052.96 | 1,747.27 |
| user I/O wait time | 3,119 | 0.29 | 0.12 |
| user calls | 251,900 | 23.41 | 10.09 |
| user commits | 19,819 | 1.84 | 0.79 |
| user rollbacks | 5,144 | 0.48 | 0.21 |
| workarea executions - onepass | 2 | 0.00 | 0.00 |
| workarea executions - optimal | 29,904 | 2.78 | 1.20 |
| write clones created in background | 192 | 0.02 | 0.01 |
| write clones created in foreground | 4 | 0.00 | 0.00 |