WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
SIH	640188827	sih	1	19-Jan-13 14:01	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
server4.shifa.com.pk	Linux x86 64-bit	80	40	4	251.89

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	209	21-Jan-13 09:00:58	57	2.7
End Snap:	210	21-Jan-13 10:01:00	57	2.6
Elapsed:		60.04 (mins)
DB Time:		1.12 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	8,832M	8,832M	Std Block Size:	8K
Shared Pool Size:	4,608M	4,608M	Log Buffer:	156,956K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.0	0.1	0.00	0.01
DB CPU(s):	0.0	0.1	0.00	0.01
Redo size:	168,148.3	456,159.6
Logical reads:	1,326.8	3,599.3
Block changes:	1,464.7	3,973.5
Physical reads:	0.0	0.0
Physical writes:	10.8	29.2
User calls:	2.9	7.8
Parses:	1.5	4.0
Hard parses:	0.0	0.0
W/A MB processed:	0.2	0.4
Logons:	0.1	0.3
Executes:	9.9	26.8
Rollbacks:	0.0	0.0
Transactions:	0.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.82	Soft Parse %:	99.04
Execute to Parse %:	85.08	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	79.73	% Non-Parse CPU:	99.04

Shared Pool Statistics

	Begin	End
Memory Usage %:	41.24	41.26
% SQL with executions>1:	97.86	97.68
% Memory for SQL w/exec>1:	95.84	94.59

Top 5 Timed Foreground Events

Host CPU (CPUs: 80 Cores: 40 Sockets: 4)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.16	0.06	0.1	0.0	0.0	99.9

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.0	37.3	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	257,932.3	257,932.3
SGA use (MB):	15,360.0	15,360.0
PGA use (MB):	384.8	380.5
% Host Mem used for SGA+PGA:	6.10	6.10

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 67.2s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 105.2% of Total DB time 67.18 (s)
• Total FG Wait Time: 9.04 (s) DB CPU time: 61.66 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 71.9% of Total DB Time (s): 67
• Captured PL/SQL account for 21.1% of Total DB Time (s): 67

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 77.3% of Total CPU Time (s): 62
• Captured PL/SQL account for 22.9% of Total CPU Time (s): 62

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 4.7% of Total User I/O Wait Time (s): 1
• Captured PL/SQL account for 3.8% of Total User I/O Wait Time (s): 1

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 4,779,868
• Captured SQL account for 96.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 18
• Captured SQL account for 88.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 7
• Captured SQL account for 0.0% of Total
• Total UnOptimized Read Requests: 7
• Captured SQL account for 0.0% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 35,533
• Captured SQL account for 56.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 5,301
• Captured SQL account for 47.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
056h3v0pfcjc5	INSERT INTO REGISTRATION.TRANSACTIONS_SUMMARY_PREV (TRANDATE, DAY, CONSULTATION_OPD, CONSULTATION_IPD, CLINIC_OPD, CLINIC_IPD, MO_FEE, RADIOLOGY_OPD, RADIOLOGY_IPD, LABORATORY_OPD, LABORATORY_IPD, MISC_OPD, MISC_IPD, PHARMACY_OPD, PHARMACY_IPD, DISCOUNT_OPD, DISCOUNT_IPD, SURGERY_EQUIPMENT, NURSING_CARE, IPD_ROOMS, SUPPLIES, SURGERIES, CASH, PANEL, TOTAL_OPD, TOTAL_IPD, GRAND_TOTAL) (SELECT TRANDATE, DAY, CONSULTATION_OPD, CONSULTATION_IPD, CLINIC_OPD, CLINIC_IPD, MO_FEE, RADIOLOGY_OPD, RADIOLOGY_IPD, LABORATORY_OPD, LABORATORY_IPD, MISC_OPD, MISC_IPD, PHARMACY_OPD, PHARMACY_IPD, DISCOUNT_OPD, DISCOUNT_IPD, SURGERY_EQUIPMENT, NURSING_CARE, IPD_ROOMS, SUPPLIES, SURGERIES, CASH, PANEL, TOTAL_OPD, TOTAL_IPD, GRAND_TOTAL FROM TRANSACTION_SUMMARY_PREV )
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08vznc16ycuag	SELECT SYS_GUID() FROM SYS.DUAL
0j96697f7strb	DELETE FROM REGISTRATION.TRAN_MISC_ADM A WHERE TRUNC(A.TRANDATE) = TRUNC(SYSDATE)
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
1kz16yhs993h2	insert into sys.scheduler$_event_log (log_id, log_date, type#, name, owner, operation, status, user_name, client_id, guid, dbid, additional_info, destination, credential, class_id, flags) values (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7, :8, :9, NULL, :10, :11, :12, :13, :14)
1nx2zrzv898cx	UPDATE REGISTRATION.TRAN_MISC_ADM SET (TRANDATE, TOTAL_DISCHARGES) = (SELECT X.TRANDATE, X.TOTAL_DISCHARGES FROM ( SELECT SYSDATE TRANDATE, COUNT(*) TOTAL_DISCHARGES FROM TBL_ADMISSION T WHERE T.DISCHARGE_DATE IS NOT NULL AND TRIM(T.DISCHARGE_DATE) = TRIM(SYSDATE) )X )
1qhza1uh1xcf9	/* OracleOEM */ DECLARE l_log_mode VARCHAR2(32); l_flashback_on VARCHAR2(32); l_flash_recovery_area VARCHAR2(512); l_flash_recovery_size NUMBER; l_usable_area NUMBER; l_space_used NUMBER; l_reclaimable_area NUMBER; l_nonreclaimable_area NUMBER; l_oldest_flashback_time VARCHAR2(512); TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_102 CONSTANT VARCHAR2(10) := '10.2.0.0.0'; BEGIN -- Database version SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; -- Log Mode, Flashback On SELECT log_mode, flashback_on INTO l_log_mode, l_flashback_on FROM v$database; -- Flash Recovery Area/Size SELECT value INTO l_flash_recovery_area FROM v$parameter WHERE name='db_recovery_file_dest'; SELECT value INTO l_flash_recovery_size FROM v$parameter WHERE name='db_recovery_file_dest_size'; -- Usable Flash Recovery Area (10gR2) -- Reclaimable Flash Recovery Area (10gR2) -- Nonreclaimable Flash Recovery Area l_usable_area := NULL; l_reclaimable_area := NULL; l_nonreclaimable_area := NULL; l_space_used := NULL; IF (v_db_version >= db_version_102) THEN IF (length(l_flash_recovery_area) > 0) THEN EXECUTE IMMEDIATE 'SELECT (CASE WHEN PERCENT_USED> 100 THEN 0 ELSE (100-PERCENT_USED) END) PERCENT_FREE FROM (SELECT (SUM(PERCENT_SPACE_USED)-SUM(PERCENT_SPACE_RECLAIMABLE)) PERCENT_USED FROM V$FLASH_RECOVERY_AREA_USAGE)' INTO l_usable_area; EXECUTE IMMEDIATE 'SELECT SUM(PERCENT_SPACE_USED), SUM(PERCENT_SPACE_RECLAIMABLE) from v$flash_recovery_area_usage' INTO l_space_used, l_reclaimable_area; l_nonreclaimable_area := l_space_used - l_reclaimable_area; END IF; END IF; -- Oldest Flashback Time BEGIN SELECT to_char(oldest_flashback_time, 'YYYY-MM-DD HH24:MI:SS') INTO l_oldest_flashback_time FROM v$flashback_database_log; EXCEPTION WHEN OTHERS THEN l_oldest_flashback_time := ''; END; OPEN data_cursor FOR SELECT l_log_mode, l_flash_recovery_area, l_usable_area, l_reclaimable_area, l_nonreclaimable_area, l_flashback_on, l_oldest_flashback_time, l_flash_recovery_size from dual; :1 := data_cursor; END;
1u2bghv5wuz45	UPDATE REGISTRATION.TRAN_MISC_ADM ADM SET (TRANDATE, TOTAL_DISCHARGES) = (SELECT X.TRANDATE, X.TOTAL_DISCHARGES FROM ( SELECT SYSDATE TRANDATE, COUNT(*) TOTAL_DISCHARGES FROM TBL_ADMISSION T WHERE T.DISCHARGE_DATE IS NOT NULL AND TRIM(T.DISCHARGE_DATE) = TRIM(SYSDATE) AND T.SITE_ID = 1 )X ) WHERE ADM.SITE_ID = 1
20vv6ttajyjzq	delete from access$ where d_obj#=:1
24dkx03u3rj6k	SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
27290wux8f7n2	UPDATE REGISTRATION.TRAN_MISC_ER SET (TRANDATE, ER_STATUS, SITE_ID) = (SELECT X.TRANDATE, X.ER_STATUS, SITE_ FROM ( SELECT SYSDATE TRANDATE, SITE_ID, COUNT(*) ER_STATUS, '1' SITE_ FROM EMERGENCY T WHERE T.IN_OUT_STATUS ='I' AND T.SITE_ID = '1' GROUP BY SITE_ID ) X )
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2d93bytu1xg1d	INSERT INTO MGMT_JOB_HISTORY(JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, STEP_STATUS_CODE, NUM_CHILDREN, NUM_CHILDREN_COMPLETED, OUTPUT_ID, ERROR_ID, START_TIME, END_TIME, TIMEZONE_REGION, SEQUENCE_NUMBER, DISPATCHER_ID) VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 )
2h0gb24h6zpnu	insert into access$(d_obj#, order#, columns, types) values (:1, :2, :3, :4)
2mvwatpussbqx	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN missing_mr#_in_tbl_locations; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2mysbczfp729x	SELECT /*+ INDEX(ping mgmt_emd_ping_idx_01) */ TGT.TARGET_GUID, TGT.EMD_URL, PING.STATUS FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC, MGMT_TARGETS TGT, MGMT_CURRENT_AVAILABILITY CAVAIL WHERE PING.TARGET_GUID = TGT.TARGET_GUID AND PING.TARGET_GUID = CAVAIL.TARGET_GUID AND PING.TARGET_GUID = PINGC.TARGET_GUID AND TGT.TARGET_TYPE = :B4 AND PING.MAX_INACTIVE_TIME > 0 AND CAVAIL.CURRENT_STATUS != :B3 AND PING.STATUS = :B2 AND PING.PING_JOB_NAME IS NULL AND ( (:B1 -PING.LAST_HEARTBEAT_UTC)*24*60*60 > PING.MAX_INACTIVE_TIME) AND ( (:B1 -PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) ORDER BY TGT.EMD_URL
34rks4d5suuxz	SELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP < :B1 /(24*60*60)
39c8q6w3s3r8y	UPDATE MGMT_EMD_PING_CHECK SET LAST_CHECKED_UTC = :B1 WHERE TARGET_GUID IN (SELECT PING.TARGET_GUID FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC WHERE PING.TARGET_GUID = PINGC.TARGET_GUID AND PING.MAX_INACTIVE_TIME > 0 AND ( (PING.STATUS = :B3 ) OR (PING.STATUS = :B2 ) ) AND (:B1 - PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2)
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
47a50dvdgnxc2	update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
4yyb4104skrwj	update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
5fk0v8km2f811	select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance
5u0puyrxwtv3s	UPDATE STORE.STORE_BALANCES SB SET SB.BALANCE_QTY = :B5 , SB.BALANCE_AMT = SB.BALANCE_AMT, SB.LAST_UPDATED_AT = SYSDATE WHERE TRAN_DATE = :B4 AND STORETYPE = :B3 AND STORE_ID = :B2 AND SITE_ID = :B1 AND VERIFIED = 'Y'
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6k5agh28pr3wp	select propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name
6v7n0y2bq89n8	BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get_scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END;
730vdzhng6m6g	update sys.scheduler$_job set next_run_date = :1, last_end_date = :2, retry_count = :3, run_count = :4, running_instance = :5, running_slave = :6, job_status = :7 where obj# = :8
7d92gmwphtza8	SELECT OWNER, JOB_NAME, COMMENTS FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'EM_IDX_STAT_JOB%' AND UPPER(OWNER) = 'DBSNMP'
7wt7phk4xns75	select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status
81ky0n97v4zsg	/* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select sid from v$mystat where rownum=1)
8t43xdhf4d9x2	SELECT CONTEXT_TYPE_ID, CONTEXT_TYPE, TRACE_LEVEL, NULL, NULL FROM EMDW_TRACE_CONFIG WHERE CONTEXT_TYPE = UPPER(:B1 )
8vwv6hx92ymmm	UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
95t91kqrwtswr	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN declare -- Local variables here i integer; b varchar2(14); begin -- Test statements here Delete from registration.tran_misc_today_new a; --- Dental Starts insert into registration.tran_misc_today_new (trandate, sum_number, sum_amount, area) (select x.trandate, x.sum_number, x.sum_amount, 'Dental' from ( select a.trandate, count(a.service_id) as Sum_Number, nvl(Sum(a.amount), 0) as Sum_Amount from registration.tran_detail_opd_today a where a.minor_id in ('0232', '0233', '0231', '0230', '0236', '0237', '0224', '0235', '0229', '0234') group by trandate )x ); Commit; -- Dental Ends --- OPD Consultations insert into registration.tran_misc_today_new (trandate, sum_number, sum_amount, area) select x.trandate, x.sum_number, x.sum_amount, 'OPD Consultations' From ( select a.trandate, count(a.service_id) as Sum_Number, Sum(a.amount) as Sum_Amount from registration.tran_detail_opd a where a.minor_id in ('0247', '0262', '0263') and trunc(a.trandate) = trunc(sysdate) group by trandate ) x; Commit; -- Ends --- IPD Consultations insert into registration.tran_misc_today_new (trandate, sum_number, sum_amount, area) select x.trandate, x.sum_number, x.sum_amount, 'IPD Consultations' From ( select a.trandate, count(a.service_id) as Sum_Number, Sum(a.amount) as Sum_Amount from registration.tran_detail_ipd a where a.minor_id in ('0267', '0266', '0264', '0248', '0265') and trunc(a.trandate) = trunc(sysdate) group by trandate ) x; Commit; -- Ends --- Cardiology insert into registration.tran_misc_today_new (trandate, sum_number, sum_amount, area) (select x.trandate, x.sum_number, x.sum_amount, 'Cardiology' from ( select a.trandate, count(a.service_id) as Sum_Number, nvl(Sum(a.amount), 0) as Sum_Amount from registration.tran_detail_opd_today a where a.minor_id in ('0010') group by trandate )x ); Commit; -- Ends --- Rehab insert into registration.tran_misc_today_new (trandate, sum_number, sum_amount, area) (select x.trandate, x.sum_number, x.sum_amount, 'Rehab' from ( select a.trandate, count(a.service_id) as Sum_Number, nvl(Sum(a.amount), 0) as Sum_Amount from registration.tran_detail_opd_today a where a.minor_id in ('0245', '0138', '0193', '0244') group by trandate )x ); Commit; -- Ends --- GCC Total insert into registration.tran_misc_today_new (trandate, sum_number, sum_amount, area) (select x.trandate, x.sum_number, x.sum_amount, 'GCC Total' from ( select a.trandate, count(distinct(a.mr#)) as Sum_Number, nvl(Sum(a.amount), 0) as Sum_Amount from registration.tran_detail_opd_today a where substr(a.location, 1, 3) = 'GCC' group by trandate )x ); Commit; -- Ends --- GCC insert into registration.tran_misc_today_new (trandate, sum_number, sum_amount, area) (select x.trandate, x.sum_number, x.sum_amount, 'GCC' from ( select a.trandate, count(distinct(a.mr#)) as Sum_Number, nvl(Sum(a.amount), 0) as Sum_Amount from registration.tran_detail_opd_today a where substr(a.location, 1, 3) = 'GCC' and substr(mr#, 1, 2) in ('GA', 'GB', 'GD', 'GE', 'GF') group by trandate )x ); Commit; -- Ends --- GCC Vaccine insert into registration.tran_misc_today_new (trandate, sum_number, sum_amount, area) (select x.trandate, x.sum_number, x.sum_amount, 'GCC Vaccine' from ( select a.trandate, count(disti nct(a.mr#)) as Sum_Number, nvl(Sum(a.amount), 0) as Sum_Amount from registration.tran_detail_opd_today a where substr(a.location, 1, 3) = 'GCC' and mr# like 'VA%' group by trandate )x ); Commit; -- Ends --- GCC Employee insert into registration.tran_misc_today_new (trandate, sum_number, sum_amount, area) (select x.trandate, x.sum_number, x.sum_amount, 'GCC Employee' from ( select a.trandate, count(distinct(a.mr#)) as Sum_Number, nvl(Sum(a.amount), 0) as Sum_Amount from registration.tran_detail_opd_today a where substr(a.location, 1, 3) = 'GCC' --and mr# not like 'GA%' and mr# not like 'VA%' and substr(mr#, 1, 2) not in ('GA', 'GB', 'GD', 'GE', 'GF') group by trandate )x ); Commit; -- Ends end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
96k8q4jvz7z55	INSERT INTO REGISTRATION.TRAN_MISC_TODAY_NEW (TRANDATE, SUM_NUMBER, SUM_AMOUNT, AREA) SELECT X.TRANDATE, X.SUM_NUMBER, X.SUM_AMOUNT, 'IPD Consultations' FROM ( SELECT A.TRANDATE, COUNT(A.SERVICE_ID) AS SUM_NUMBER, SUM(A.AMOUNT) AS SUM_AMOUNT FROM REGISTRATION.TRAN_DETAIL_IPD A WHERE A.MINOR_ID IN ('0267', '0266', '0264', '0248', '0265') AND TRUNC(A.TRANDATE) = TRUNC(SYSDATE) GROUP BY TRANDATE ) X
9dhn1b8d88dpf	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, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), 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, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 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.instance_id is null 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))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) 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 <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, 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 <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), 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.owner# = 0 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, 4, 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 j.owner# = 0 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 and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
9juw6s4yy5pzp	/* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )
a5pyncg7v0bw3	/* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
a8j39qb13tqkr	SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_FINDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
b2u9kspucpqwy	SELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL
ba3vdy0n303fd	INSERT INTO REGISTRATION.TRAN_MISC_TODAY_NEW (TRANDATE, SUM_NUMBER, SUM_AMOUNT, AREA) (SELECT X.TRANDATE, X.SUM_NUMBER, X.SUM_AMOUNT, 'GCC Vaccine' FROM ( SELECT A.TRANDATE, COUNT(DISTINCT(A.MR#)) AS SUM_NUMBER, NVL(SUM(A.AMOUNT), 0) AS SUM_AMOUNT FROM REGISTRATION.TRAN_DETAIL_OPD_TODAY A WHERE SUBSTR(A.LOCATION, 1, 3) = 'GCC' AND MR# LIKE 'VA%' GROUP BY TRANDATE )X )
ba7pu9hqg25kt	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN Pr_Cr_tr_sm_adm_dis; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
bfujkg8dw1aax	SELECT UPPER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), 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, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
btwkwwx56w4z6	SELECT target_guid FROM mgmt_metric_dependency WHERE can_calculate = 1 AND event_metric = 1 AND disabled = 0 AND rs_metric = 1 ORDER BY eval_order
c6yw86dnkbhxz	INSERT INTO REGISTRATION.TRAN_MISC_PAT (TRANDATE, PATIENTS) (SELECT X.TRANDATE, X.PATIENTS FROM ( SELECT SYSDATE TRANDATE, COUNT(P.MR#) PATIENTS FROM PATIENTS P WHERE TRUNC(P.SYS_DATE) = TRUNC(SYSDATE) )X )
c8h3jdwaa532q	SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cumjq42201t37	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
cxjqbfn0d3yqq	SELECT COUNT(*) FROM SYS.DBA_PROPAGATION
duxupnsvb98r5	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN declare BEGIN NULL; begin pharmacy_shifa.pharmacybalances; EXCEPTION WHEN OTHERS THEN NULL; end; BEGIN store.udp_ins_store_balances; EXCEPTION WHEN OTHERS THEN NULL; end; BEGIN purchase.udp_ins_dc_balances; EXCEPTION WHEN OTHERS THEN NULL; end; BEGIN mmstore.udp_ins_mmstore_balances; EXCEPTION WHEN OTHERS THEN NULL; end; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
dwssdqx28tzf5	select sysdate + 1 / (24 * 60) from dual
dyqadjsac09bf	UPDATE REGISTRATION.TRAN_MISC_ER E SET (TRANDATE, ER_DISCHARGES) = (SELECT X.TRANDATE, X.ER_DISCHARGES FROM ( SELECT SYSDATE TRANDATE, COUNT(*) ER_DISCHARGES FROM EMERGENCY T WHERE T.IN_OUT_STATUS ='O' AND TRUNC(T.DATE_IN) = TRUNC(SYSDATE) AND T.SITE_ID = '1' )X ) WHERE TRUNC(E.TRANDATE) = TRUNC(SYSDATE) AND E.SITE_ID = '1'
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
g4gp07gt2z920	update sys.scheduler$_job set last_start_date = :1, running_instance = :2, running_slave = :3, job_status = :4 where obj# = :5
gbm2nfy9husn2	UPDATE REGISTRATION.TRAN_MISC_ER E SET (TRANDATE, ER_ADMISSIONS) = (SELECT X.TRANDATE, X.ER_ADMISSIONS FROM ( SELECT SYSDATE TRANDATE, COUNT(*) ER_ADMISSIONS FROM EMERGENCY T WHERE T.IN_OUT_STATUS ='I' AND TRUNC(T.DATE_IN) = TRUNC(SYSDATE) AND T.SITE_ID = '1' )X ) WHERE TRUNC(E.TRANDATE) = TRUNC(SYSDATE) AND E.SITE_ID = '1'
gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Buffer Pool Statistics
• Checkpoint Activity

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 38,716

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin Snapshot, E: End Snapshot

Back to Advisory Statistics
Back to Top

MTTR Advisory

• Only rows at end snap are displayed
• Estimated Writes and I/Os are in thousands

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

• B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

• only enqueues with waits are shown
• Enqueue stats gathered prior to 10g should not be compared with 10g data
• ordered by Wait Time desc, Waits desc

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

• Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
• STO - Snapshot Too Old count, OOS - Out of Space count
• Undo segment block stats:
• uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
• eS - expired Stolen, eR - expired Released, eU - expired reUsed

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

Back to Undo Statistics
Back to Top

Latch Statistics

• Latch Activity
• Latch Sleep Breakdown
• Latch Miss Sources
• Mutex Sleep Summary
• Parent Latch Statistics
• Child Latch Statistics

Latch Activity

• "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
• "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
• "Pct Misses" for both should be very close to 0.0