Nothing moved beyond its normal range.

Parsing schema

SYS

Module

sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

5636665338160656674

SQL profile

—

Text length

39 chars

update chaos.locks set v=v+1 where id=2

Parsing schema

SYS

Module

sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

5636665338160656674

SQL profile

—

Text length

39 chars

update chaos.locks set v=v+1 where id=1

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

—

SQL profile

—

Text length

147 chars

BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class,                                              :rep_id, :suc); END;

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

9931397711087819739

SQL profile

—

Text length

67 chars

SELECT XMLTYPE(DBMS_REPORT.GET_REPORT_WITH_SUMMARY(:B1 )) FROM DUAL

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

3827900917462555511

SQL profile

—

Text length

92,634 chars

WITH MONITOR_DATA AS (SELECT * FROM TABLE(GV$(CURSOR( SELECT USERENV('instance') AS INST_ID, KEY, NVL2(PX_QCSID, NULL, STATUS) STATUS, FIRST_REFRESH_TIME, LAST_REFRESH_TIME, REFRESH_COUNT, PROCESS_NAME, SID, SQL_ID, SQL_EXEC_START, SQL_EXEC_ID, DBOP_NAME, DBOP_EXEC_ID, SQL_PLAN_HASH_VALUE, SQL_FULL_PLAN_HASH_VALUE, SESSION_SERIAL#, SQL_TEXT, PX_SERVER#, PX_SERVER_GROUP, PX_SERVER_SET, PX_QCINST_ID, PX_QCSID, CASE WHEN ELAPSED_TIME < (CPU_TIME+ APPLICATION_WAIT_TIME+ CONCURRENCY_WAIT_TIME+ CLUSTER_WAIT_TIME+ USER_IO_WAIT_TIME+ QUEUING_TIME) THEN (CPU_TIME+ APPLICATION_WAIT_TIME+ CONCURRENCY_WAIT_TIME+ CLUSTER_WAIT_TIME+ USER_IO_WAIT_TIME+ QUEUING_TIME) ELSE ELAPSED_TIME END ELAPSED_TIME, QUEUING_TIME, CPU_TIME, APPLICATION_WAIT_TIME, CONCURRENCY_WAIT_TIME, CLUSTER_WAIT_TIME, USER_IO_WAIT_TIME, CASE WHEN ELAPSED_TIME < (CPU_TIME+ APPLICATION_WAIT_TIME+ CONCURRENCY_WAIT_TIME+ CLUSTER_WAIT_TIME+ USER_IO_WAIT_TIME+ QUEUING_TIME) THEN 0 ELSE ELAPSED_TIME - (CPU_TIME+ APPLICATION_WAIT_TIME+ CONCURRENCY_WAIT_TIME+ CLUSTER_WAIT_TIME+ USER_IO_WAIT_TIME+ QUEUING_TIME) END OTHER_WAIT_TIME, PLSQL_EXEC_TIME, JAVA_EXEC_TIME, FETCHES, BUFFER_GETS, IO_INTERCONNECT_BYTES IO_INTER_BYTES, PHYSICAL_READ_REQUESTS READ_REQS, PHYSICAL_READ_BYTES READ_BYTES, PHYSICAL_WRITE_REQUESTS WRITE_REQS, PHYSICAL_WRITE_BYTES WRITE_BYTES, NVL(PHYSICAL_READ_BYTES, 0) + NVL(PHYSICAL_WRITE_BYTES, 0) IO_BYTES, NVL(PHYSICAL_READ_REQUESTS, 0) + NVL(PHYSICAL_WRITE_REQUESTS, 0) IO_REQS, IO_CELL_UNCOMPRESSED_BYTES IO_UNC_BYTES, IO_CELL_OFFLOAD_ELIGIBLE_BYTES IO_ELIG_BYTES, IO_CELL_OFFLOAD_RETURNED_BYTES IO_RET_BYTES, USER# USERID, USERNAME, MODULE, ACTION, SERVICE_NAME, CLIENT_IDENTIFIER, CLIENT_INFO, PROGRAM, PLSQL_OBJECT_ID PL_OID, PLSQL_SUBPROGRAM_ID PL_PROGID, PLSQL_ENTRY_OBJECT_ID PL_ENTRY_OID, PLSQL_ENTRY_SUBPROGRAM_ID PL_ENTRY_PROGID, PX_MAXDOP MAX_DOP, PX_IS_CROSS_INSTANCE, PX_MAXDOP_INSTANCES MAX_DOP_INSTANCES, PX_SERVERS_REQUESTED SERVERS_REQUESTED, PX_SERVERS_ALLOCATED SERVERS_ALLOCATED, ERROR_NUMBER, ERROR_FACILITY, ERROR_MESSAGE, NVL2(OTHER_XML, 'Y', NULL) HAS_OTHER_XML, NVL2(BINDS_XML, 'Y', NULL) HAS_BINDS_XML, NVL2(RM_CONSUMER_GROUP, NVL2(RM_LAST_ACTION_TIME, TO_CHAR(RM_LAST_ACTION_TIME, :B12 ), '00/00/0000 00:00:01') || XMLELEMENT( "rminfo", XMLATTRIBUTES( RM_LAST_ACTION AS "rmlastact", RM_LAST_ACTION_REASON AS "rmlastreason", TO_CHAR(RM_LAST_ACTION_TIME, :B12 ) AS "rmlasttime", RM_CONSUMER_GROUP AS "rmcg")).GETSTRINGVAL(), '00/00/0000 00:00:00') RM_INFO, CON_NAME, CON_ID FROM V$ALL_SQL_MONITOR MO1 WHERE USERENV('INSTANCE') BETWEEN :B11 AND :B10 AND MO1.SQL_ID = NVL(:B9 , MO1.SQL_ID) AND MO1.SQL_EXEC_START = NVL(:B8 , MO1.SQL_EXEC_START) AND MO1.SQL_EXEC_ID = NVL(:B7 , MO1.SQL_EXEC_ID) OR (MO1.DBOP_NAME = NVL(:B6 , MO1.DBOP_NAME) AND MO1.DBOP_EXEC_ID = NVL(:B5 , MO1.DBOP_EXEC_ID)) AND ((:B4 = 1 AND MO1.PX_QCSID IS NULL) OR (MO1.PX_SERVER_GROUP = NVL(:B3 , MO1.PX_SERVER_GROUP) AND MO1.PX_SERVER_SET = NVL(:B2 , MO1.PX_SERVER_SET) AND MO1.PX_SERVER# = NVL(:B1 , MO1.PX_SERVER#))) ))) ), MONITOR_AGG AS (SELECT MAX_PX_QCSID, MAX_KEY, MAX_INST_ID, MAX_SESSION_ID, MAX_SESSION_SERIAL, MAX_PX_DOP, MAX_PX_DOP_INSTANCES, MAX_PX_IS_CROSS_INSTANCE, SUM_SERVERS_REQUESTED, SUM_SERVERS_ALLOCATED, DIST_INST_COUNT, DIST_PX_GROUP_COUNT, DIST_PX_SET_COUNT, MAX_PLAN_HASH_VALUE, MAX_FULL_PLAN_HASH_VALUE, MAX_USERID, MAX_PROGRAM, MAX_USERNAME, MAX_MODULE, MAX_ACTION, MAX_SERVICE_NAME, MAX_CLIENT_ID, MAX_CLIENT_INFO, MAX_ERROR_NUMBER, MAX_ERROR_FACILITY, MAX_ERROR_MESSAGE, QC_HAS_OTHER_XML, QC_HAS_BINDS_XML, MAX_PL_OID, MAX_PL_PROGID, MAX_PL_ENTRY_OID, MAX_PL_ENTRY_PROGID, MAX_SQL_ID, MAX_SQL_EXEC_START, MAX_SQL_EXEC_ID, MAX_LAST_REFRESH_TIME, MAX_DBOP_NAME, MAX_DBOP_EXEC_ID, CASE WHEN MAX_PL_OID IS NOT NULL THEN NVL((SELECT P.OWNER || '.' || P.OBJECT_NAME || DECODE(P.PROCEDURE_NAME, NULL, '', '.' || P.PROCEDURE_NAME) FROM ALL_PROCEDURES P WHERE P.OBJECT_ID = MAX_PL_OID AND P.SUBPROGRAM_ID = MAX_PL_PROGID AND ROWNUM = 1), 'Unavailable') END MAX_PL_NAME, CASE WHEN MAX_PL_ENTRY_OID IS NOT NULL THEN NVL((SELECT P.OWNER || '.' || P.OBJECT_NAME || DECODE(P.PROCEDURE_NAME, NULL, '', '.' || P.PROCEDURE_NAME) FROM ALL_PROCEDURES P WHERE P.OBJECT_ID = MAX_PL_ENTRY_OID AND P.SUBPROGRAM_ID = MAX_PL_ENTRY_PROGID AND ROWNUM = 1), 'Unavailable') END MAX_PL_ENTRY_NAME, MAX_STATUS, SUM_REFRESH_COUNT, MIN_FIRST_REFRESH_TIME, SQLMON_TEXT, SUM_ELAPSED_TIME, MAX_ELAPSED_TIME, MAX_QUEUING_TIME, SUM_CPU_TIME, SUM_USER_IO_WAIT_TIME, SUM_APPLICATION_WAIT_TIME, SUM_CONCURRENCY_WAIT_TIME, SUM_CLUSTER_WAIT_TIME, SUM_PLSQL_EXEC_TIME, SUM_JAVA_EXEC_TIME, SUM_OTHER_WAIT_TIME, SUM_FETCHES, SUM_BUFFER_GETS, SUM_READ_REQS, SUM_READ_BYTES, SUM_WRITE_REQS, SUM_WRITE_BYTES, SUM_IO_BYTES, SUM_IO_INTER_BYTES, SUM_IO_UNC_BYTES, SUM_IO_ELIG_BYTES, SUM_IO_RET_BYTES, DECODE(:B14 , 1, 'db_name', SYS_CONTEXT('userenv', 'db_unique_name')) DB_UNIQUE_NAME, DECODE(:B14 , 1, 'platform_name', SYS.DBMS_UTILITY.PORT_STRING) PLATFORM_NAME, DECODE(:B14 , 1, 'host_name', SYS_CONTEXT('userenv', 'server_host')) HOST_NAME, AGG_RM_INFO MAX_RM_INFO, MAX_CON_NAME, DECODE(MAX_CON_ID, 0, NULL, MAX_CON_ID) MAX_CON_ID FROM (SELECT MAX(PX_QCSID) MAX_PX_QCSID, MAX(CASE WHEN PX_QCSID IS NULL THEN KEY ELSE NULL END) MAX_KEY, MAX(CASE WHEN PX_QCSID IS NULL THEN INST_ID ELSE NULL END) MAX_INST_ID, MAX(CASE WHEN PX_QCSID IS NULL THEN SID ELSE NULL END) MAX_SESSION_ID, MAX(CASE WHEN PX_QCSID IS NULL THEN SESSION_SERIAL# ELSE NULL END) MAX_SESSION_SERIAL, MAX(MAX_DOP) MAX_PX_DOP, MAX(MAX_DOP_INSTANCES) MAX_PX_DOP_INSTANCES, MAX(PX_IS_CROSS_INSTANCE) MAX_PX_IS_CROSS_INSTANCE, SUM(SERVERS_REQUESTED) SUM_SERVERS_REQUESTED, SUM(SERVERS_ALLOCATED) SUM_SERVERS_ALLOCATED, COUNT(DISTINCT INST_ID) DIST_INST_COUNT, COUNT(DISTINCT PX_SERVER_GROUP) DIST_PX_GROUP_COUNT, COUNT(DISTINCT PX_SERVER_SET) DIST_PX_SET_COUNT, MAX(SQL_PLAN_HASH_VALUE) MAX_PLAN_HASH_VALUE, MAX(SQL_FULL_PLAN_HASH_VALUE) MAX_FULL_PLAN_HASH_VALUE, MAX(USERID) MAX_USERID, MAX(PROGRAM) MAX_PROGRAM, MAX(USERNAME) MAX_USERNAME, MAX(MODULE) MAX_MODULE, MAX(ACTION) MAX_ACTION, MAX(SERVICE_NAME) MAX_SERVICE_NAME, MAX(CLIENT_IDENTIFIER) MAX_CLIENT_ID, MAX(CLIENT_INFO) MAX_CLIENT_INFO, MAX(ERROR_NUMBER) MAX_ERROR_NUMBER, MAX(ERROR_FACILITY) MAX_ERROR_FACILITY, MAX(ERROR_MESSAGE) MAX_ERROR_MESSAGE, MAX(NVL2(PX_QCSID, HAS_OTHER_XML, NULL)) QC_HAS_OTHER_XML, MAX(HAS_BINDS_XML) QC_HAS_BINDS_XML, MAX(PL_OID) MAX_PL_OID, MAX(PL_PROGID) MAX_PL_PROGID, MAX(PL_ENTRY_OID) MAX_PL_ENTRY_OID, MAX(PL_ENTRY_PROGID) MAX_PL_ENTRY_PROGID, MAX(SQL_ID) MAX_SQL_ID, MAX(SQL_EXEC_START) MAX_SQL_EXEC_START, MAX(SQL_EXEC_ID) MAX_SQL_EXEC_ID, MAX(LAST_REFRESH_TIME) MAX_LAST_REFRESH_TIME, MAX(STATUS) MAX_STATUS, SUM(REFRESH_COUNT) SUM_REFRESH_COUNT, MIN(FIRST_REFRESH_TIME) MIN_FIRST_REFRESH_TIME, MAX(DBOP_NAME) MAX_DBOP_NAME, MAX(DBOP_EXEC_ID) MAX_DBOP_EXEC_ID, CASE WHEN :B13 = 0 THEN NULL ELSE MAX(SQL_TEXT) END SQLMON_TEXT, SUM(ELAPSED_TIME) SUM_ELAPSED_TIME, MAX(ELAPSED_TIME) MAX_ELAPSED_TIME, MAX(QUEUING_TIME) MAX_QUEUING_TIME, SUM(CPU_TIME) SUM_CPU_TIME, SUM(USER_IO_WAIT_TIME) SUM_USER_IO_WAIT_TIME, SUM(APPLICATION_WAIT_TIME) SUM_APPLICATION_WAIT_TIME, SUM(CONCURRENCY_WAIT_TIME) SUM_CONCURRENCY_WAIT_TIME, SUM(CLUSTER_WAIT_TIME) SUM_CLUSTER_WAIT_TIME, SUM(PLSQL_EXEC_TIME) SUM_PLSQL_EXEC_TIME, SUM(JAVA_EXEC_TIME) SUM_JAVA_EXEC_TIME, SUM(OTHER_WAIT_TIME) SUM_OTHER_WAIT_TIME, SUM(FETCHES) SUM_FETCHES, SUM(BUFFER_GETS) SUM_BUFFER_GETS, SUM(READ_REQS) SUM_READ_REQS, SUM(READ_BYTES) SUM_READ_BYTES, SUM(WRITE_REQS) SUM_WRITE_REQS, SUM(WRITE_BYTES) SUM_WRITE_BYTES, NVL(SUM(READ_BYTES), 0) + NVL(SUM(WRITE_BYTES), 0) SUM_IO_BYTES, SUM(IO_INTER_BYTES) SUM_IO_INTER_BYTES, SUM(IO_UNC_BYTES) SUM_IO_UNC_BYTES, SUM(IO_ELIG_BYTES) SUM_IO_ELIG_BYTES, SUM(IO_RET_BYTES) SUM_IO_RET_BYTES, MAX(RM_INFO) AGG_RM_INFO, MAX(CON_NAME) MAX_CON_NAME, MAX(CON_ID) MAX_CON_ID FROM MONITOR_DATA) MD), ASH_DATA AS (SELECT AD0.INST_ID, AD0.SESSION_ID, AD0.PLAN_LINE_ID, AD0.PLSQL_OBJECT_ID, AD0.PLSQL_SUBPROGRAM_ID, AD0.ACTIVITY_BUCKET_NUM, AD0.PLAN_ACTIVITY_BUCKET_NUM, AD0.SQL, AD0.TOP_
... (truncated, 92634 chars total)

Parsing schema

SYS

Module

dgmgrl@ol9-19-dg3.localdomain (TNS V1-V3)

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

3292330648709112879

SQL profile

—

Text length

48 chars

BEGIN dbms_drs.do_observe(:indoc, :outdoc); END;

Parsing schema

SYS

Module

emagent_SQL_oracle_database

Action

cdbjob_status

Optimizer mode

ALL_ROWS

Force-match sig

13562461939718721680

SQL profile

—

Text length

3,039 chars

WITH cdb_last_failed_jobs AS
(
SELECT CON_ID,
OWNER,
JOB_NAME,
MAX(ACTUAL_START_DATE) AS START_DATE
FROM CDB_SCHEDULER_JOB_RUN_DETAILS
WHERE STATUS = 'FAILED'
GROUP BY CON_ID, OWNER, JOB_NAME
)
,
cdb_last_succeeded_jobs AS
(
SELECT CON_ID,
OWNER,
JOB_NAME,
MAX(ACTUAL_START_DATE) AS START_DATE
FROM CDB_SCHEDULER_JOB_RUN_DETAILS
WHERE STATUS = 'SUCCEEDED'
GROUP BY CON_ID, OWNER, JOB_NAME
)
,
cdb_last_failed_jobs_with_earlier_success AS
(
SELECT cdb_last_failed_jobs.CON_ID,
cdb_last_failed_jobs.OWNER,
cdb_last_failed_jobs.JOB_NAME,
cdb_last_failed_jobs.START_DATE
FROM cdb_last_failed_jobs,
cdb_last_succeeded_jobs
WHERE cdb_last_failed_jobs.CON_ID = cdb_last_succeeded_jobs.CON_ID
AND cdb_last_failed_jobs.OWNER = cdb_last_succeeded_jobs.OWNER
AND cdb_last_failed_jobs.JOB_NAME = cdb_last_succeeded_jobs.JOB_NAME
AND cdb_last_failed_jobs.START_DATE < cdb_last_succeeded_jobs.START_DATE
)
,
cdb_last_failed_jobs_without_earlier_success AS
(
SELECT UNIQUE cdb_last_failed_jobs.CON_ID,
cdb_last_failed_jobs.OWNER,
cdb_last_failed_jobs.JOB_NAME,
cdb_last_failed_jobs.START_DATE
FROM cdb_last_failed_jobs, cdb_last_succeeded_jobs
WHERE (cdb_last_failed_jobs.CON_ID != cdb_last_succeeded_jobs.CON_ID)
OR (cdb_last_failed_jobs.OWNER != cdb_last_succeeded_jobs.OWNER)
OR (cdb_last_failed_jobs.JOB_NAME != cdb_last_succeeded_jobs.JOB_NAME)
)
,
cdb_latest_run_failed_jobs AS
(
SELECT CON_ID,
OWNER,
JOB_NAME,
START_DATE
FROM cdb_last_failed_jobs_without_earlier_success
UNION
SELECT CON_ID,
OWNER,
JOB_NAME,
START_DATE
FROM cdb_last_failed_jobs_with_earlier_success
),
cdb_final_latest_run_failed_jobs_set AS
(
SELECT CON_ID,
OWNER,
JOB_NAME,
START_DATE
FROM cdb_latest_run_failed_jobs
WHERE JOB_NAME NOT IN (SELECT JOB_NAME FROM CDB_SCHEDULER_JOBS WHERE STATE IN ('BROKEN', 'DISABLED'))
)
,
cdb_failed_count_job_set AS (
SELECT CON_ID, SUM(sub_fail_count) AS failed_count
FROM (
SELECT CON_ID, count(1) AS sub_fail_count
FROM cdb_final_latest_run_failed_jobs_set
GROUP BY CON_ID

UNION ALL

SELECT CON_ID, count(1) AS sub_fail_count
FROM CDB_JOBS WHERE (broken != 'Y' AND NVL(failures,0) > 0)
GROUP BY CON_ID
)
GROUP BY CON_ID
)
,
cdb_broken_count_job_set AS (
SELECT CON_ID, SUM(sub_broken_count) AS broken_count
FROM (
SELECT CON_ID, count(1) AS sub_broken_count
FROM CDB_SCHEDULER_JOBS
WHERE STATE = 'BROKEN'
GROUP BY CON_ID
UNION ALL
SELECT CON_ID, count(1) AS sub_broken_count
FROM CDB_JOBS
WHERE BROKEN = 'Y'
GROUP BY CON_ID
)
GROUP BY CON_ID
)
,
cdb_final_count_details AS (
SELECT F.CON_ID AS CON_ID,
NVL(F.failed_count,0) AS FAILED,
NVL(B.broken_count,0) AS BROKEN
FROM cdb_failed_count_job_set F LEFT JOIN cdb_broken_count_job_set B
ON F.CON_ID = B.CON_ID
UNION
SELECT B.CON_ID,
NVL(F.failed_count,0) AS FAILED,
NVL(B.broken_count,0) AS BROKEN
FROM cdb_broken_count_job_set B LEFT JOIN cdb_failed_count_job_set F
ON B.CON_ID = F.CON_ID
)
SELECT c.name AS pdb_name,
cdb_final_count_details.broken,
cdb_final_count_details.failed
FROM cdb_final_count_details, v$containers c
WHERE cdb_final_count_details.con_id = TO_NUMBER(c.con_id)

Parsing schema

SYS

Module

emagent_SQL_oracle_database

Action

ha_backup_sbt

Optimizer mode

ALL_ROWS

Force-match sig

4105016950430450626

SQL profile

—

Text length

146 chars

SELECT COUNT(*) FROM X$KSPPI A, X$KSPPCV2 B WHERE A.INDX + 1 = KSPFTCTXPN AND KSPPINM = '_deferred_log_dest_is_valid' AND UPPER(KSPFTCTXVL)='TRUE'

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

17358924003873928378

SQL profile

—

Text length

194 chars

delete /* QOSH:PURGE_OLD_STS *//*+ dynamic_sampling(4) */  from sys.wri$_optstat_histgrm_history      where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0'   and rownum <=  :2   

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

—

SQL profile

—

Text length

53 chars

      begin
         dbms_rcvman.resetAll;
      end;

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

11693190177341983400

SQL profile

—

Text length

131 chars

select /*+ index(idl_ub1$ i_idl_ub11) */ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

Parsing schema

SYS

Module

emagent_SQL_oracle_database

Action

cdb_dbNInstanceInfo

Optimizer mode

ALL_ROWS

Force-match sig

15305793011113631743

SQL profile

—

Text length

2,604 chars

with pdbview AS
(select con_id, name from v$containers where con_id != 2)
SELECT  pdb.name,
a.name "DB Name",
e.property_value "Global Name",
replace(b.banner, c.version, c.version_full) "DB Version",
c.host_name "Host Name",
c.instance_name "Instance Name" ,
to_char(c.startup_time,'YYYY-MM-DD HH24:MI:SS') "Instance Start Time",
decode(c.logins,'RESTRICTED','YES','NO') "Restricted Mode",
a.log_mode  "Archive Log Mode" ,
case when pdb.con_id=0
then
decode(a.open_mode,'READ ONLY','YES','NO')
else
decode(vpb.OPEN_MODE,'READ ONLY','YES','NO')
end
"Read Only Mode",
nlsp1.value,
nlsp2.value,
p.property_value,
to_char(a.created,'YYYY-MM-DD HH24:MI:SS') created,
substr(banner,instr(banner,'Oracle Database '),19) release,
nvl(trim(substr(banner,instr(banner,'Oracle Database ')+19,instr(banner,' Release') - instr(banner,'Oracle Database  ') - 19)),decode(instr(banner,'Personal'),0,'','Personal')) edition,
c.version_full dbversion,
DECODE(addr.word_len, 64, '1', '0')  is64bit,
substr(substr(banner, instr(banner, '-') + 2),
instr(substr(banner, instr(banner, '-') + 2),' ')+1)
rel_status,
a.supplemental_log_data_min  as sup_log_data_min,
case when  (select count(*) from cdb_users u where u.username ='DVSYS' and u.user_id = 1279990 and u.con_id = pdb.con_id)  > 0
then
case when (select value from v$option o where o.parameter ='Oracle Database Vault' and (o.con_id = pdb.con_id or o.con_id = 0)) ='TRUE'
then
1 -- Enabled
else
0 --Disabled
end
when (select count(*) from cdb_users u where u.username ='DVSYS' and u.user_id = 1279990 and u.con_id = pdb.con_id) = 0
then
case when (select value from v$option o where parameter ='Oracle Database Vault'  and (o.con_id = pdb.con_id or o.con_id = 0)) = 'TRUE'
then
-1 -- Not Configured
else
-2 -- Not Installed
end
end
dv_status_code
FROM    v$database a,
v$version b,
v$instance c,
CDB_PROPERTIES e,
v$nls_parameters nlsp1,
v$nls_parameters nlsp2,
CDB_PROPERTIES p,
(select length(addr)*4 word_len from v$process where rownum=1) addr,
pdbview pdb,
V$PDBS vpb
WHERE   b.banner LIKE '%Oracle%'
AND   nlsp1.parameter = 'NLS_CHARACTERSET'
AND   nlsp2.parameter = 'NLS_NCHAR_CHARACTERSET'
AND   e.property_name = 'GLOBAL_DB_NAME'
AND   p.property_name = 'DEFAULT_TEMP_TABLESPACE'
AND   (a.con_id = pdb.con_id OR a.con_id = 0)
AND   (b.con_id = pdb.con_id OR b.con_id = 0)
AND   (c.con_id = pdb.con_id OR c.con_id = 0)
AND   (nlsp1.con_id = pdb.con_id OR nlsp1.con_id = 0 OR nlsp1.con_id = 1)
AND   (nlsp2.con_id = pdb.con_id OR nlsp2.con_id = 0 OR nlsp2.con_id = 1)
AND   e.con_id = pdb.con_id
AND   p.con_id = pdb.con_id
AND   vpb.con_id(+) = pdb.con_id

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

—

SQL profile

—

Text length

848 chars

      declare
         agedFileRec   dbms_rcvman.agedFileRec_t;
         first         boolean := FALSE; 
         alldest       number  := dbms_rcvman.FALSE#; 
         policy        varchar2(512); 
      begin
         if (:first > 0) then
            first := TRUE;
            if (:alldest > 0) then 
               alldest := dbms_rcvman.TRUE#; 
            end if; 
            dbms_rcvman.setRecoveryDestFile(TRUE); 
            dbms_rcvman.getRedoLogDeletionPolicy(policy  => policy); 
            dbms_rcvman.setRedoLogDeletionPolicy(policy  => policy, 
                                                 alldest => alldest); 
         end if; 
         dbms_rcvman.getAppliedAl(first => first,
                                  agedFileRec => agedFileRec);
         :type  := agedFileRec.type;
         :key   := agedFileRec.key;
      end;

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

7169017389194603904

SQL profile

—

Text length

2,772 chars

  UPDATE  wrh$_seg_stat_obj  ob      SET (snap_id, owner, object_name, subobject_name, tablespace_name,         object_type, partition_type, index_type, base_obj#, base_object_name,           base_object_owner) =       (SELECT snap_id + 1,               nvl(ownername_kewrseg, owner),               nvl(objname_kewrseg, object_name),               nvl(subobjname_kewrseg, subobject_name),               nvl(tsname_kewrseg, tablespace_name),               decode(objtype_kewrseg, 0, object_type,               sys.dbms_swrf_internal.awr_decode_object_type(objtype_kewrseg, 18)),              decode(ptype_kewrseg, 0, partition_type,                      decode(ptype_kewrseg, 0, 'NONE', 1, 'RANGE', 2, 'HASH',                           3, 'SYSTEM', 4, 'LIST',  NULL, 'NONE', 'UNKNOWN')),               decode(indtype_kewrseg, 0, index_type,                   decode(indtype_kewrseg,                       1, 'NORMAL'||                          decode(bitand(iprop_kewrseg, 4), 0, '', 4, '/REV'),                       2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP',                       5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI',                       8, 'LOB', 9, 'DOMAIN')),               coalesce(nullif(bobjn_kewrseg,0), so.base_obj#),               case bobjname_kewrseg                 when NULL then so.base_object_name                 else case length(bobjname_kewrseg)                        when 0 then so.base_object_name                        else bobjname_kewrseg                      end                end,               case bowname_kewrseg                 when NULL then so.base_object_owner                 else case length(bowname_kewrseg)                        when 0 then so.base_object_owner                        else bowname_kewrseg                      end                end               FROM  wrh$_seg_stat_obj                      so JOIN  (select * from x$kewrtsegstat  where con_id = :con_id_01 or (   (:con_id_02 = 1        and con_id = 0)  or (:con_id_03 = 0        and con_id = 1))  )  io ON               (dbid = :dbid and con_dbid = con_dbid_kewrseg                and ts# = tsn_kewrseg and obj# = objn_kewrseg                and dataobj# = objd_kewrseg)          WHERE ob.dbid = so.dbid            AND ob.con_dbid = so.con_dbid            AND ob.ts#  = so.ts#            AND ob.obj# = so.obj#            AND ob.dataobj# = so.dataobj#)    WHERE dbid = :dbid      AND object_name NOT LIKE '%MISSING%'      AND object_name NOT LIKE '%TRANSIENT%'      AND (ts#, obj#, dataobj#, con_dbid) in           (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg, con_dbid_kewrseg              FROM  (select * from x$kewrtsegstat  where con_id = :con_id_04 or (   (:con_id_05 = 1        and con_id = 0)  or (:con_id_06 = 0        and con_id = 1))  ) ) 

Parsing schema

SYS

Module

sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

935332091860047417

SQL profile

—

Text length

648 chars

select json_object(
  'collected_at' value to_char(sys_extract_utc(systimestamp), 'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"'),
  'log_type' value 'oracle_metrics',
  'event' value json_object('outcome' value 'success'),
  'oracle' value json_object(
    'metric' value json_object('type' value 'tablespace'),
    'database' value json_object('name' value sys_context('USERENV', 'DB_UNIQUE_NAME')),
    'tablespace' value json_object(
      'name' value tablespace_name,
      'used_pct' value round(used_percent, 2),
      'used_blocks' value used_space,
      'total_blocks' value tablespace_size
    )
  ) returning clob
) from dba_tablespace_usage_metrics

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

—

SQL profile

—

Text length

69 chars

      begin
         dbms_output.get_line(:line, :status);
      end;

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

—

SQL profile

—

Text length

825 chars

      declare
         policy        varchar2(512);
         alldest       number  := dbms_rcvman.FALSE#;
         rlgscn        number; 
      begin
         if (:alldest > 0) then
            alldest := dbms_rcvman.TRUE#;
         end if;
         dbms_rcvman.setRecoveryDestFile(TRUE); 
         dbms_rcvman.getRedoLogDeletionPolicy(policy  => policy);
         dbms_rcvman.setRedoLogDeletionPolicy(policy  =>  policy,
                                              alldest =>  alldest);
         if ((policy like '%APPLIED%' OR 
              policy like '%SHIPPED%') AND 
             policy not like '%BACKED UP%') then
            dbms_rcvman.getSCNForAppliedPolicy(
               minscn     => :applied_scn
              ,rlgscn     => rlgscn);
         else
            :applied_scn := 0;
         end if;
      end;

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

9312034333491264047

SQL profile

—

Text length

361 chars

insert into  WRH$_MUTEX_SLEEP  (dbid, per_pdb, con_dbid, snap_id, instance_number,     mutex_type, location, sleeps, wait_time) select  :dbid,  mslp.con_id, con_id_to_dbid(mslp.con_id)  con_dbid,  :snap_id, :instance_number,     mutex_type, location, sleeps, wait_time   FROM v$mutex_sleep    mslp  WHERE  (1 = 1)  AND ( mslp.con_id < 4099  )  and    sleeps > 0

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

14894371175163409544

SQL profile

—

Text length

417 chars

insert into  WRH$_EVENT_HISTOGRAM  (dbid, per_pdb, con_dbid, snap_id, instance_number,     event_id, wait_time_milli, wait_count ) select  :dbid,  s.con_id, con_id_to_dbid(s.con_id)  con_dbid,  :snap_id, :instance_number,        d.ksledhash, s.kslsesmaxdur/1024,        s.kslsesval   FROM x$kslseshist_micro   s, x$ksled   d  WHERE  (1 = 1)  AND ( s.con_id < 4099  )   and s.kslsesenum = d.indx   and s.kslsesval > 0 

Parsing schema

SYS

Module

emagent_SQL_oracle_database

Action

db_autotask_client

Optimizer mode

ALL_ROWS

Force-match sig

16105372920694538533

SQL profile

—

Text length

54 chars

select client_name, status from DBA_AUTOTASK_CLIENT

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

7187657109694262111

SQL profile

—

Text length

2,323 chars

merge /* KSXM:OPTIM_DML_INF */  into sys.mon_mods_all$ m                   using dual                                                                 on (m.obj# = :objn and                                                         (:pobjn = 0 or                                                              m.obj# = :pobjn or                                                         m.obj# in (select obj#                                                                from tabpart$                                                              where bo# = :pobjn and obj# = :objn                                        union all                                                                  select obj#                                                                from tabcompart$                                                           where bo# = :pobjn and obj# = :objn                                        union all                                                                  select tsp.obj#                                                            from tabsubpart$ tsp, tabcompart$ tcp                                      where tsp.pobj# = tcp.obj#                                                   and (tcp.bo# = :pobjn or tcp.obj# = :pobjn)                                and tsp.obj# = :objn)))                                  when matched then                                                            update                                                                     set inserts = decode(:reset, 1, 0, inserts) + :ins,                            updates = decode(:reset, 1, 0, updates) + :upd,                            deletes = decode(:reset, 1, 0, deletes) + :del,                            flags =  decode(:reset, 1, 0, flags - bitand(flags, :flag)) + :flag,       drop_segments = decode(:reset, 1, 0, drop_segments) + :dropseg,            timestamp = :time                                                    when NOT matched then                                                        insert (obj#, inserts, updates, deletes,                                           timestamp, flags, drop_segments)                                   values (:objn, :ins, :upd, :del, :time, :flag, :dropseg)                   where :ins != 0 or :upd != 0 or :del != 0 or :flag != 0 or :dropseg !=0

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

15478463079253557468

SQL profile

—

Text length

195 chars

delete /* QOSH:PURGE_OLD_STS *//*+ dynamic_sampling(4) */   from sys.wri$_optstat_histhead_history     where savtime < :1 and savtime > timestamp '1900-01-01 00:00:00 -0:0'   and rownum <=  :2   

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

15265304128816016130

SQL profile

—

Text length

108 chars

select T.*  from table(dbms_xplan.get_plan_rows(:tab_name, :stmt_id, :plan_id, :format, :fpreds, 1, null)) T

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

16955708195488272379

SQL profile

—

Text length

191 chars

select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,flags,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

Parsing schema

SYS

Module

sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)

Action

—

Optimizer mode

CHOOSE

Force-match sig

15923375254844418634

SQL profile

—

Text length

226 chars

select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand(nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

Parsing schema

SYS

Module

DBMS_SCHEDULER

Action

PMO_DEFERRED_GIDX_MAINT_JOB

Optimizer mode

ALL_ROWS

Force-match sig

—

SQL profile

—

Text length

41 chars

call dbms_part.cleanup_gidx_job ( :0,:1 )

Parsing schema

SYS

Module

emagent_SQL_oracle_database

Action

db_options

Optimizer mode

ALL_ROWS

Force-match sig

226190071430424382

SQL profile

—

Text length

2,239 chars

select 'INTER_MEDIA' as name, decode((select username from dba_users where username='ORDSYS'), 'ORDSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'SPATIAL' as name, decode((select username from dba_users where username='MDSYS'), 'MDSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'ORACLE_TEXT' as name, decode((select username from dba_users where username='CTXSYS'), 'CTXSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'ULTRA_SEARCH' as name, decode((select username from dba_users where username='WKSYS'), 'WKSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'LABEL_SECURITY' as name, decode((select username from dba_users where username='LBACSYS'), 'LBACSYS', 'TRUE', 'FALSE') as selected
from dual
union
select 'SAMPLE_SCHEMA' as name, decode((select count(*) from dba_users where username IN('HR','PM','QS','SH','OE')), 0, 'FALSE', 'TRUE') as selected
from dual
union
select 'JSERVER' as name, decode((select count(*) from sys."_CURRENT_EDITION_OBJ" where type#=29), 0, 'FALSE', 'TRUE') as selected
from dual
union
select 'ORACLE_DATA_MINING' as name, decode((select status from dba_registry where comp_id='ODM'), 'VALID', 'TRUE', 'FALSE') as selected
from dual
union
select 'XDB' as name, decode((select username from dba_users where username='XDB'), 'XDB', 'TRUE', 'FALSE') as selected
from dual
union
select 'EM_REPOSITORY' as name, decode((select username from dba_users where username='SYSMAN'), 'SYSMAN', 'TRUE', 'FALSE') as selected
from dual
UNION
select 'Database Vault' as name, decode((SELECT 1 from (Select count(*) CNT
from dba_users where UPPER(username) in ('DVSYS','DVF') ) where CNT = 2),1,'TRUE','FALSE') as selected from dual
UNION
select 'Audit Vault' as name, decode((SELECT 1 from dba_users where UPPER(username) = 'AVSYS' and rownum = 1), 1, 'TRUE', 'FALSE') as selected
from dual
UNION
select 'Content Database' as name, decode((SELECT 1 from dba_users where UPPER(username) = 'CONTENT' and rownum = 1),1,'TRUE','FALSE') as selected
from dual
UNION
select 'Records Database' as name, decode((SELECT 1 from dba_users where UPPER(username) = 'CONTENT' and rownum = 1),1,'TRUE','FALSE') as selected
from dual
UNION
select parameter as name,value as selected from v$option

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

5206426832808080579

SQL profile

—

Text length

56 chars

select nvl(sum(space),0) from recyclebin$ where ts# = :1

Parsing schema

SYS

Module

DBMS_SCHEDULER

Action

PURGE_LOG

Optimizer mode

ALL_ROWS

Force-match sig

—

SQL profile

—

Text length

318 chars

select cons.consumer_name 
        from sys.dba_queue_subscribers cons
        left join sys.user$ us
          on replace(cons.consumer_name,'SCHED$_AGT2$_')=us.user#
        where
          cons.queue_name='SCHEDULER$_EVENT_QUEUE' and
          cons.consumer_name like 'SCHED$_AGT2$_%' and
          us.user# is null

Parsing schema

AUDSYS

Module

Oracle Enterprise Manager.Metric Engine

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

5149218935331065413

SQL profile

—

Text length

339 chars

SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE SHELFLIFE=30) */ "DBUSERNAME","EVENT_TIMESTAMP","ACTION_NAME","RETURN_CODE" FROM "AUDSYS"."UNIFIED_AUDIT_TRAIL" "K" WHERE "K"."ACTION_NAME"='LOGON' AND "K"."RETURN_CODE"<>0 AND SYS_EXTRACT_UTC("K"."EVENT_TIMESTAMP")>=SYS_EXTRACT_UTC(CURRENT_TIMESTAMP(6)-TO_DSINTERVAL('0 0:30:00'))

Parsing schema

SYS

Module

Oracle Enterprise Manager.Metric Engine

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

15582271173586173236

SQL profile

—

Text length

1,011 chars

SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD')  AS curr_timestamp, SUM(failed_count) AS failed_count ,   TO_CHAR(MIN(first_occur_time), 'yyyy-mm-dd hh24:mi:ss') AS first_occur_time,    TO_CHAR(MAX(last_occur_time), 'yyyy-mm-dd hh24:mi:ss') AS last_occur_time,  name FROM (SELECT COUNT(DBUSERNAME) AS failed_count,  MIN(event_timestamp) AS first_occur_time, MAX(event_timestamp) AS last_occur_time, c.name  FROM cdb_unified_audit_trail a,  v$containers c  WHERE a.ACTION_NAME='LOGON' and a.return_code <> 0  AND a.event_timestamp >= current_timestamp - TO_DSINTERVAL('0 0:30:00')  AND a.con_id = c.con_id  GROUP BY c.name  UNION  SELECT COUNT(username) AS failed_count,  MIN(timestamp) AS first_occur_time,  MAX(timestamp) AS last_occur_time, c.name  FROM  sys.cdb_audit_session a, v$containers c  WHERE a.returncode != 0  AND  a.ACTION_NAME = 'LOGON'  AND a.timestamp >= current_timestamp - TO_DSINTERVAL('0 0:30:00')  AND a.con_id = c.con_id  GROUP BY c.name ) GROUP BY name 

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

8202132710599047039

SQL profile

—

Text length

468 chars

insert into  wrh$_mvparameter  (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, ordinal, value, isdefault, ismodified)  select  :dbid,  sv.con_id, con_id_to_dbid(sv.con_id)  con_dbid,  :snap_id, :instance_number, sv.hash, sv.ordinal, substr(sv.value, 1, 512), sv.isdefault, sv.ismodified  from v$system_parameter2    sv  where exists (select 1 from v$system_parameter4    i  where i.num = sv.num                    and bitand(i.param_flag,32) = 32) 

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

15482066450771861019

SQL profile

—

Text length

116 chars

SELECT 1 from "SYS"."AQ$SCHEDULER$_EVENT_QTAB" qtview  WHERE (queue = 'AQ$_SCHEDULER$_EVENT_QTAB_E' ) AND rownum < 2

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

734444955242386636

SQL profile

—

Text length

56 chars

select order#,columns,types from access$ where d_obj#=:1

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

17935924578192521696

SQL profile

—

Text length

303 chars

insert into  wrh$_parameter  (dbid, per_pdb, con_dbid, snap_id, instance_number, parameter_hash, value, isdefault, ismodified)  select  :dbid,  sp.con_id, con_id_to_dbid(sp.con_id)  con_dbid,  :snap_id, :instance_number, hash, substr(value, 1, 512), isdefault, ismodified  from v$system_parameter    sp 

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

—

SQL profile

—

Text length

174 chars

select /* QOSH:ANLYZ_TIME */     from_tz(      cast ((max(analyzetime) - 1) as timestamp),      to_char(systimestamp, 'TZH:TZM'))  from sys.tab$ where analyzetime is not null

Parsing schema

SYS

Module

emagent

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

10806876778680223460

SQL profile

—

Text length

57 chars

begin dbms_application_info.set_module(:1  , :2  ); end;

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

—

SQL profile

—

Text length

229 chars

BEGIN
              sys.prvt_hdm.auto_execute(
                db_id => :bind_dbid,
                inst_id => :bind_inst,
                end_snap => :bind_snap,
                time_left_in_secs => :bind_time);
            END;

Parsing schema

SYS

Module

—

Action

—

Optimizer mode

CHOOSE

Force-match sig

17748462609813920007

SQL profile

—

Text length

1,006 chars

insert /* KSXM:TAKE_SNPSHOT */ into sys.optstat_snapshot$ (obj#, inserts, updates, deletes, timestamp, flags) (select m.obj#, m.inserts, m.updates, m.deletes, systimestamp,  dbms_stats_advisor.compute_volatile_flag(    m.obj#, m.flags, :flags, m.inserts, m.updates, m.deletes,    s.inserts, s.updates, s.deletes, null,    nvl(to_number(p.valchar), :global_stale_pcnt), s.gather) flags from sys.mon_mods_all$ m, (select si.obj#, max(si.inserts) inserts, max(si.updates) updates,    max(si.deletes) deletes, decode(bitand(max(si.flags), :gather_flag), 0,                               'NO_GATHER', 'GATHER') gather,    max(si.timestamp) timestamp  from sys.optstat_snapshot$ si,  (select obj#, max(timestamp) ts from sys.optstat_snapshot$   group by obj#) sm  where si.obj# = sm.obj# and si.timestamp = sm.ts  group by si.obj#) s, sys.optstat_user_prefs$ p where m.obj# = s.obj#(+)  and m.obj# = p.obj#(+) and pname(+) = 'STALE_PERCENT'  and dbms_stats_advisor.check_mmon_policy_violation(rownum, 6, 2) = 0) 

Parsing schema

SYS

Module

sqlplus@ol9-19-dg1.localdomain (TNS V1-V3)

Action

—

Optimizer mode

ALL_ROWS

Force-match sig

1169769593972080845

SQL profile

—

Text length

2,455 chars

select json_object(
  'collected_at' value to_char(sys_extract_utc(systimestamp), 'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"'),
  'log_type' value 'oracle_metrics',
  'event' value json_object('outcome' value 'success'),
  'log' value json_object('level' value 'INFO'),
  'oracle' value json_object(
    'metric' value json_object('type' value 'health'),
    'database' value json_object(
      'name' value d.db_unique_name,
      'role' value d.database_role,
      'open_mode' value d.open_mode,
      'protection_mode' value d.protection_mode,
      'switchover_status' value d.switchover_status
    ),
    'instance' value json_object(
      'name' value i.instance_name,
      'status' value i.status,
      'database_status' value i.database_status,
      'version' value i.version,
      'startup_time' value to_char(i.startup_time, 'YYYY-MM-DD"T"HH24:MI:SS'),
      'available' value case when i.status = 'OPEN' then 'true' else 'false' end format json
    ),
    'metrics' value json_object(
      'sessions' value json_object(
        'current' value (select current_utilization from v$resource_limit where resource_name = 'sessions'),
        'limit' value (select case when regexp_like(trim(limit_value), '^[0-9]+$') then to_number(trim(limit_value)) end from v$resource_limit where resource_name = 'sessions'),
        'utilization_pct' value (select round(100 * current_utilization / nullif(case when regexp_like(trim(limit_value), '^[0-9]+$') then to_number(trim(limit_value)) end, 0), 2) from v$resource_limit where resource_name = 'sessions')
      ),
      'processes' value json_object(
        'current' value (select current_utilization from v$resource_limit where resource_name = 'processes'),
        'limit' value (select case when regexp_like(trim(limit_value), '^[0-9]+$') then to_number(trim(limit_value)) end from v$resource_limit where resource_name = 'processes'),
        'utilization_pct' value (select round(100 * current_utilization / nullif(case when regexp_like(trim(limit_value), '^[0-9]+$') then to_number(trim(limit_value)) end, 0), 2) from v$resource_limit where resource_name = 'processes')
      ),
      'blocking_sessions' value (select count(*) from v$session where blocking_session is not null),
      'failed_jobs_24h' value (select count(*) from dba_scheduler_job_run_details where status = 'FAILED' and log_date >= systimestamp - interval '1' day)
    )
  ) returning clob
) from v$instance i cross join v$database d