WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
YCRAC	815225530	YCRAC1	1	29-Dec-12 23:12	11.2.0.3.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
YCNODE1.YCDEMO	Linux x86 64-bit	24	12	2	94.54

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	176	05-Jan-13 08:00:03	69	3.5
End Snap:	186	05-Jan-13 18:00:04	82	3.3
Elapsed:		600.01 (mins)
DB Time:		147.10 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	8,960M	8,960M	Std Block Size:	8K
Shared Pool Size:	4,224M	4,224M	Log Buffer:	82,648K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.3	0.8	0.01	0.01
DB CPU(s):	0.1	0.4	0.01	0.00
Redo size:	4,263.7	13,353.4
Logical reads:	3,176.8	9,949.1
Block changes:	22.0	68.8
Physical reads:	2,749.9	8,612.1
Physical writes:	1.4	4.3
User calls:	35.1	109.9
Parses:	4.2	13.0
Hard parses:	0.4	1.2
W/A MB processed:	0.2	0.7
Logons:	0.9	2.7
Executes:	23.8	74.6
Rollbacks:	0.0	0.0
Transactions:	0.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	99.87
Buffer Hit %:	99.55	In-memory Sort %:	100.00
Library Hit %:	96.37	Soft Parse %:	91.15
Execute to Parse %:	82.53	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	84.85	% Non-Parse CPU:	99.24

Shared Pool Statistics

	Begin	End
Memory Usage %:	66.63	66.08
% SQL with executions>1:	97.93	94.83
% Memory for SQL w/exec>1:	93.48	89.98

Top 5 Timed Foreground Events

Host CPU (CPUs: 24 Cores: 12 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.07	0.14	0.9	0.3	0.1	98.8

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	96,810.6	96,810.6
SGA use (MB):	13,952.0	13,952.0
PGA use (MB):	496.6	526.2
% Host Mem used for SGA+PGA:	14.92	14.96

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	2.94	9.19
Global Cache blocks served:	2.44	7.65
GCS/GES messages received:	10.58	33.13
GCS/GES messages sent:	11.16	34.95
DBWR Fusion writes:	0.17	0.53
Estd Interconnect traffic (KB)	47.26

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	98.87
Buffer access - remote cache %:	0.68
Buffer access - disk %:	0.45

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.3
Avg global cache current block receive time (ms):	0.4
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	0.6
Avg global cache cr block flush time (ms):	1.2
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.3
Avg global cache current block flush time (ms):	1.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.2
Avg message received queue time (ms):	1.5
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	75.87
% of indirect sent messages:	24.02
% of flow controlled messages:	0.10

Cluster Interconnect

• if IP/Public/Source at End snap is different a '*' is displayed

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

More RAC Statistics

• RAC Report Summary
• Global Messaging Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats
• Interconnect Stats
• Dynamic Remastering Statistics

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): 8825.9s
• 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 100.7% of Total DB time 8,825.89 (s)
• Total FG Wait Time: 4,054.43 (s) DB CPU time: 4,830.05 (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
• SQL ordered by Cluster Wait Time
• 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 101.4% of Total DB Time (s): 8,826
• Captured PL/SQL account for 25.2% of Total DB Time (s): 8,826

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 102.2% of Total CPU Time (s): 4,830
• Captured PL/SQL account for 42.9% of Total CPU Time (s): 4,830

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 118.3% of Total User I/O Wait Time (s): 355
• Captured PL/SQL account for 34.8% of Total User I/O Wait Time (s): 355

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: 114,365,159
• Captured SQL account for 108.8% 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: 98,996,470
• Captured SQL account for 123.6% 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: 839,363
• Captured SQL account for 88.6% of Total
• Total UnOptimized Read Requests: 839,363
• Captured SQL account for 88.6% 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: 857,969
• Captured SQL account for 17.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 149,872
• Captured SQL account for 27.8% 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

SQL ordered by Cluster Wait Time

• %Total - Cluster Time as a percentage of Total Cluster Wait Time
• %Clu - Cluster Time as a percentage of Elapsed Time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 21
• Captured SQL account for 24.2% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
01tvu1q03x8wv	SELECT event#, inst_id, sql_id, max(sql_plan_hash_value), max(sql_opcode), session_id, p1, current_obj#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), COUNT(*), SUM(time_waited), service_hash FROM gv$active_session_history WHERE sample_time > :1 AND sample_time <= :2 GROUP BY event#, inst_id, sql_id, session_id, p1, current_obj#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), service_hash
03yx8sa0v4m3t	SELECT CODEID, EMUNID, EMUN_VALUE_ID, EMUN_VALUE_EN, EMUN_VALUE_ZH, EMUN_VALUE_ZF, ORDERVALUE, IS_DEFAULTVALUE, FIELD_KZ_ONE, FIELD_KZ_TWO, FIELD_KZ_THREE, FIELD_KZ_FOUR, FIELD_KZ_FIVE FROM DICT_EMUN_SUB WHERE EMUNID=:1 ORDER BY CODEID
06jh3w7fcsw89	SELECT * FROM YCCS_TABLE_YCSCP020 WHERE FSOURCE_ID = :B1
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
0jqvwyy00ubs8	INSERT INTO YCSFW040 (CURRENTROLESYS, CURRENTUSERGORUPSYS, CURRENTDEPARTMENTSYS, ISSTARTRECYCLE, SHAREROLESYS, SHAREUSERSYS, SHAREDEPARTMENTSYS, SHAREUSERGROUP, SALES_ORG, DISTR_CHAN, DIVISION, SALES_OFFICE, SALES_GROUP, SALES_AREA, IS_DELETESYS, UPDATE_DATESYS, FBUSD_NO, FPRODUCT, FPRODUCT_SERIAL, FCODEID, FBUSD_TYPE, FPRODUCT_COMPANYNO, FCOST_ROWNO, FCOST_ITEMNO, FCOST_ITEMNAME, FNUMBER, FMEASURE_UNIT, FSUMMARY_LABEL, FFEE_LABEL, FNOTES, IS_INUSE, CREATER, CREATEDATE, CHANGER, CHANGEDATE, FCLIENT, FBAK01, FBAK02, FBAK03, FBAK04, FBAK05, FBAK06, FBAK07, FBAK08, FBAK09, FBAK010, FBAK011, FBAK012, FBAK013, FBAK014, FBAK015, FBAK016, FBAK017, FBAK018, FBAK019, FBAK020, ISLOCKSTATUSSYS, CURRENTUSERSYS) 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, to_date(:33, 'YYYY-MM-DD hh24:mi:ss'), :34, to_date(:35, 'YYYY-MM-DD hh24:mi:ss'), :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58)
0njp59jttu2z9	DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1
0sfgqjz5cs52w	select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info, sender_name, sender_address, sender_protocol from "SYS"."ALERT_QT" where msgid = :1
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
1kun9u6vs1jnm	SELECT YCSFW020.FSERV_TYPE, YCSCP020.FFOLLOW_MAINT_STATE FROM YCSFW020 LEFT JOIN YCSCP020 ON YCSFW020.FPRODUCT=YCSCP020.FPRODUCT_SERIAL_EX WHERE FSERV_LIST=:1
1uyp1pq4w60h7	SELECT wc.inst_id, wc.begin_time begin_time, en.wait_class class, wc.time_waited_fg fg, wc.time_waited bg, 0 dbtime, wc.intsize_csec FROM gv$waitclassmetric wc, (SELECT UNIQUE wait_class, wait_class# FROM v$event_name) en WHERE wc.wait_class# = en.wait_class# UNION ALL SELECT fg.inst_id, fg.begin_time, 'CPU Usage Per Sec', fg.value, bg.value, dbtime.value, 100 FROM gv$sysmetric fg, gv$sysmetric bg, gv$sysmetric dbtime WHERE fg.metric_name='CPU Usage Per Sec' and bg.metric_name='Background CPU Usage Per Sec' and dbtime.metric_name = 'Average Active Sessions' and fg.group_id = 2 and bg.group_id = 2 and dbtime.group_id = 2 and bg.begin_time = fg.begin_time and fg.begin_time = dbtime.begin_time ORDER BY class
1yq3fhjkbdzw9	SELECT FPRODUCT_SERIAL, FPRODUCT_COMPANYNO, to_char(FBUY_DATE, 'YYYY-MM-DD') as FBUY_DATE FROM YCSCP020 WHERE FPRODUCT_SERIAL_EX=:1
21chj89kfsgqw	SELECT ROLE_ID, ROLE_NAME, ROLE_ALIAS, CORPORATION_ID, IS_SYS FROM PUB_ROLES WHERE ROLE_ID=:1
2cj1kzu6mru6g	select begin_time, inst_id, sum(DBTIMEPERSEC)/100 from GV$SERVICEMETRIC where intsize_csec > 5900 group by begin_time, inst_id order by begin_time, inst_id
2tmtyujy4d1vx	SELECT CODEID, CURRYID, CURRYNAME, OBJ_ID, OBJ_NAME, COMMANDNAME, COMMANDURL, FIELD_KZ_ONE, FIELD_KZ_TWO, FIELD_KZ_THREE, FIELD_KZ_FOUR, FIELD_KZ_FIVE FROM DICT_HELPMAIN WHERE CURRYID=:1
2xb7w7dfyfp9h	SELECT FUSE1 FROM MDMBMD040 WHERE FMATR_NO = (SELECT FMATR_NO FROM YCSCP020 WHERE FPRODUCT_SERIAL_EX=:1)
2ymn0wktdd5dy	SELECT FMATR_NO, FMATR_TXT FROM MDMBMD091
30mutv46s3x61	SELECT FUSE2 FROM MDMBMD040 WHERE FMATR_NO = (SELECT FMATR_NO FROM YCSCP020 WHERE FPRODUCT_SERIAL_EX=:1)
36wa90u69djd9	SELECT SOURCE_ITEM FROM TSASM501 WHERE S_ENGN = :B1
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3jvj0zbkak9h6	select inst_id, begin_time, value, intsize_csec from gv$sysmetric where intsize_csec > 5900 and metric_name =:1
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3mzmha5pxaf9j	SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, STEP_STATUS, COMMAND_TYPE, TIMEZONE_REGION FROM ( SELECT :B3 JOB_ID, :B3 EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, STEP_STATUS, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE = :B2 AND STEP_STATUS != :B1 UNION SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, STEP_STATUS, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 ) AND COMMAND_TYPE = :B5 AND START_TIME <= :B4 ) WHERE ROWNUM <= :B8
45uv9q75nammy	SELECT SESSION_ID, USER_ID, USER_NAME, CORPORATION_ID, CORPORATION_NAME, LOGIN_TIME, LOGOFF_TIME, REMOTEADDR, REMOTEHOST, REMOTEPORT, EXTEND FROM PUB_ONLINE WHERE USER_ID=:1
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
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :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, :33, :34, :35, :36)
4y1y43113gv8f	delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
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
5g4z8t63zwqnc	INSERT INTO PUB_ONLINE (SESSION_ID, USER_ID, USER_NAME, CORPORATION_ID, CORPORATION_NAME, LOGIN_TIME, LOGOFF_TIME, REMOTEADDR, REMOTEHOST, REMOTEPORT, EXTEND) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
5jvf84zg4c49n	select s.synonym_name as object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
5sqx4hm5dbsdg	SELECT FMATR_NO FROM YCSCP020 WHERE FPRODUCT_SERIAL=:1
5uy533jsc8hyh	DELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1
5vhur6trud54g	SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'TABLE' , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG FROM SYS.KU$_HTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, 8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.SCHEMA_OBJ.NAME IN('YCSBA060') AND (BITAND(KU$.FLAGS, 536870912)=0)
634t0vyxzcr1n	SELECT FBUS_SECTION FROM MDMBMD040 WHERE FMATR_NO=(SELECT FMATR_NO FROM YCSCP020 WHERE FPRODUCT_SERIAL_EX=:1)
63n9pwutt8yzw	MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 5 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 + CASE WHEN ((BITAND(T.FLAGS, 16) = 16 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 16) != 16) THEN 0 ELSE 128 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND BITAND(T.PROPERTY, 4294967296) != 4294967296 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME IN ('SUMDELTA$', 'SNAP_XCMT$')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND B ITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL, 'TRUE') * :B6 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B8 ) <> 0 ) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, SYS.OPTSTAT_USER_PREFS$ P, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(CM.BOBJ#, :B10 ) IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 6 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 + CASE WHEN ((BITAND(T.FLAGS, 16) = 16 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 16) != 16) THEN 0 ELSE 128 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND I.TYPE# = 4 AND I.BO# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(TP.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT)) OR BITAND(TP.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OPTSTAT_USER_PREFS$ P WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND T.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B2 ) <> 0) AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.PART# PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B7 ) <> 0) AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.SUBPART# PART#, I.POBJ# BO#, NULL LOC_STALE_PCT FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE ( DBMS_STATS_INTERNAL.GATHER_INDEX(IND.BO#, :B10 ) IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLAGS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B5 , :B4 , NEW.PART#, NEW.BO#)
6jsh461kzf7qn	select snap_id , wait_class , p_tmfg/10000/ela fg , p_tmbg/10000/ela bg , -1 from (select snap_id , ela , wait_class , sum(p_tmbg) p_tmbg , sum(p_tmfg) p_tmfg from ( select s.snap_id, (case when (CAST(s.end_interval_time AS DATE) - CAST(s.begin_interval_time AS DATE))*24*3600 > 0 then (CAST(s.end_interval_time AS DATE) - CAST(s.begin_interval_time AS DATE))*24*3600 else 1000 end) ela , wait_class , e.event_name , case when s.begin_interval_time = s.startup_time then e.time_waited_micro_fg else e.time_waited_micro_fg - lag(time_waited_micro_fg) over (partition by event_id , e.dbid , e.instance_number , s.startup_time order by e.snap_id) end p_tmfg , case when s.begin_interval_time = s.startup_time then e.time_waited_micro else e.time_waited_micro - lag(time_waited_micro) over (partition by event_id , e.dbid , e.instance_number , s.startup_time order by e.snap_id) end p_tmbg from dba_hist_snapshot s , dba_hist_system_event e where s.dbid = e.dbid and s.dbid = :1 and s.instance_number = e.instance_number and s.snap_id = e.snap_id and s.snap_id <= :2 and s.snap_id >= :3 and e.wait_class != 'Idle') group by snap_id, ela, wait_class order by snap_id, wait_class) union all select bg.snap_id, 'CPU Used', sum(fg.average), sum(bg.average), sum(dbtime.average) from dba_hist_sysmetric_summary bg, dba_hist_sysmetric_summary fg, dba_hist_sysmetric_summary dbtime where bg.metric_name = 'Background CPU Usage Per Sec' and bg.group_id = 2 and fg.metric_name = 'CPU Usage Per Sec' and fg.group_id = 2 and dbtime.metric_name = 'Average Active Sessions' and dbtime.group_id = 2 and bg.end_time = fg.end_time and fg.end_time = dbtime.end_time and bg.dbid = :4 and bg.dbid = fg.dbid and fg.dbid = dbtime.dbid and bg.instance_number = fg.instance_number and fg.instance_number = dbtime.instance_number and bg.snap_id <= :5 and bg.snap_id >= :6 group by bg.snap_id order by snap_id, wait_class
6pw8uk8k0dv0q	select inst_id, begin_time, metric_name, value, intsize_csec from gv$sysmetric where intsize_csec > 5900 and metric_name in ('Global Cache Average CR Get Time', 'Global Cache Average Current Get Time', 'GC CR Block Received Per Second', 'GC Current Block Received Per Second', 'Logical Reads Per Sec', 'Physical Reads Per Sec') order by metric_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;
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
7jp26jkhjmuxk	SELECT FPROD_SUB_SERIES FROM MDMBMD040 WHERE FMATR_NO = (SELECT FMATR_NO FROM YCSCP020 WHERE FPRODUCT_SERIAL_EX=:1)
7s3k793z3vt49	INSERT INTO PUB_SECURITY_LOG (LOG_ID, SESSION_ID, USER_ID, USER_NAME, USER_LEVEL, CORPORATION_ID, CORPORATION_NAME, LOG_TIME, REMOTEADDR, REMOTEHOST, REMOTEPORT, LOCALADDR, LOCALHOST, LOCALPORT, RESOURCE_ID, RESOURCE_ALIAS, SECURITY_LEVEL, LOG_TYPE, LOG_TYPE_NAME, LOG_CONTENT) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20)
7sx5p1ug5ag12	SELECT SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1
8gdcv9faabrtc	SELECT S_NCMP FROM TSASM501 WHERE S_ENGN = :B1
8p8us1yt73r8a	SELECT FMAINT_DUTY_SERNO FROM YCSCP020 WHERE FPRODUCT_SERIAL_EX=:1
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
91u594s6at5ku	SELECT FFUEL_SYSTEM FROM MDMBMD040 WHERE FMATR_NO=(SELECT FMATR_NO FROM YCSCP020 WHERE FPRODUCT_SERIAL_EX =:1)
93wbjjcf6364s	SELECT PUB_STRU.STRU_ID, PUB_STRU.ORGAN_ID , PUB_STRU.ORGAN_ALIAS, PUB_STRU.STRU_TYPE, PUB_STRU.PARENT_ID, PUB_STRU.PRINCIPAL_ID, PUB_STRU.CORPORATION_ID, PUB_STRU.STRU_LEVEL, PUB_STRU.STRU_PATH, PUB_STRU.STRU_ORDER, PUB_STRU.GLOBAL_ORDER, PUB_STRU.BEGIN_DATE, PUB_STRU.END_DATE, PUB_STRU.SCN, PUB_STRU.IS_LEAF, PUB_STRU.IN_USE , PUB_STRU.DEPARTMENT_ID , PUB_STRU.PERMISSION_STRU_ID FROM PUB_STRU, PUB_ORGAN WHERE PUB_STRU.ORGAN_ID=PUB_ORGAN.ORGAN_ID AND PUB_STRU.STRU_PATH LIKE :1 AND PUB_ORGAN.ORGAN_TYPE LIKE :2 AND PUB_STRU.CORPORATION_ID LIKE :3 AND PUB_STRU.IN_USE='1' ORDER BY PUB_STRU.STRU_PATH
9fcd2ncztztat	SELECT PUB_ROLES.ROLE_ID, PUB_ROLES.ROLE_NAME, PUB_ROLES.ROLE_ALIAS, PUB_ROLES.CORPORATION_ID, PUB_ROLES.IS_SYS FROM PUB_ROLES, PUB_USER_ROLE WHERE PUB_ROLES.ROLE_ID=PUB_USER_ROLE.GRANTED_ROLE AND PUB_USER_ROLE.USER_ID=:1
9suf95guvwvjg	select inst_id, begin_time, FUNCTION_NAME, SMALL_READ_MBPS, SMALL_WRITE_MBPS, LARGE_READ_MBPS, LARGE_WRITE_MBPS, SMALL_READ_IOPS, SMALL_WRITE_IOPS, LARGE_READ_IOPS, LARGE_WRITE_IOPS, AVG_WAIT_TIME from GV$IOFUNCMETRIC where intsize_csec > 5900 order by begin_time, function_name
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
adfpkwrb7pn7f	select inst_id, instance_name, host_name from gv$instance order by inst_id
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
arx2rgss6k33m	SELECT s.inst_id, s.name, i.instance_name FROM gv$active_services s, gv$instance i WHERE s.name = :p1 AND s.inst_id = i.inst_id
b0320g1xasbx7	SELECT TIMEZONE_REGION FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
b6typvzxv82u7	SELECT FPROD_MODEL, FBUS_SECTION, FUSE1 FROM MDMBMD040 WHERE FMATR_NO=(SELECT FMATR_NO FROM YCSCP020 WHERE FPRODUCT_SERIAL=:1)
b6usrg82hwsa3	call dbms_stats.gather_database_stats_job_proc ( )
br7sy4byxwzs1	SELECT IO_TIME.SNAP_ID, IO_TIME.SECONDS, DB.SECONDS, CPU.SECONDS FROM (SELECT SNAP_ID, DBID, INSTANCE_NUMBER, SUM(TIME_WAITED_MICRO)/1000000 SECONDS FROM DBA_HIST_SYSTEM_EVENT WHERE DBID = :B3 AND SNAP_ID >= :B2 AND SNAP_ID <= :B1 AND WAIT_CLASS = 'User I/O' GROUP BY SNAP_ID, DBID, INSTANCE_NUMBER) IO_TIME, (SELECT SNAP_ID, DBID, INSTANCE_NUMBER, VALUE/1000000 SECONDS FROM DBA_HIST_SYS_TIME_MODEL WHERE STAT_ID = 3649082374 AND SNAP_ID >= :B2 AND SNAP_ID <= :B1 ) DB, (SELECT SNAP_ID, DBID, INSTANCE_NUMBER, VALUE/1000000 SECONDS FROM DBA_HIST_SYS_TIME_MODEL WHERE STAT_ID = 2748282437 AND SNAP_ID >= :B2 AND SNAP_ID <= :B1 ) CPU WHERE IO_TIME.SNAP_ID = DB.SNAP_ID AND IO_TIME.DBID = DB.DBID AND IO_TIME.INSTANCE_NUMBER = DB.INSTANCE_NUMBER AND DB.SNAP_ID = CPU.SNAP_ID AND DB.DBID = CPU.DBID AND DB.INSTANCE_NUMBER = CPU.INSTANCE_NUMBER ORDER BY IO_TIME.SNAP_ID
by796z90k4gmj	select inst_id, begin_time, SERVICE_NAME, DBTIMEPERSEC/100 from GV$SERVICEMETRIC where intsize_csec > 5900 order by begin_time, SERVICE_NAME
c3hhngpbpvvmk	SELECT MARKER_TIMESTAMP FROM MGMT_AVAILABILITY_MARKER WHERE TARGET_GUID = :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
cn39cg7kr98v6	SELECT P.VALCHAR FROM SYS.OPTSTAT_USER_PREFS$ P WHERE P.OBJ#=:B2 AND P.PNAME=:B1
cydnuss99swtd	BEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;
d0xmnp08rhfbg	insert into sys.wri$_optstat_histhead_history (obj#, intcol#, savtime, flags, null_cnt, minimum, maximum, distcnt, density, lowval, hival, avgcln, sample_distcnt, sample_size, timestamp#, colname) select h.obj#, h.intcol#, :3, bitand(h.spare2, 7) + 8 + decode(h.cache_cnt, 0, 0, 64), h.null_cnt, h.minimum, h.maximum, h.distcnt, h.density, h.lowval, h.hival, h.avgcln, h.spare1, h.sample_size, h.timestamp#, :4 from sys.hist_head$ h where h.obj# = :1 and h.intcol# = :2
df0894f07zwr8	begin -- Call the procedure data_processing.ycscp020_up(p_date1 => :p_date1, p_date2 => :p_date2); end;
f1y8kbhh6v9sv	select inst_id, begin_time, metric_name, value from gv$sysmetric where intsize_csec > 5900 and metric_name in ('Logons Per Sec', 'Logons Per Txn', 'Physical Reads Per Sec', 'Physical Reads Per Txn', 'Redo Generated Per Sec', 'Redo Generated Per Txn', 'User Transaction Per Sec') order by metric_name
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
g5tjrzum1c1ky	UPDATE YCSFW030 SET FSERV_LIST=:1 , FROWNO=:2 , FPRODUCT=:3 , FPRODUCT_SERIAL=:4 , FMATR_NO=:5 , FCUSMATR_NO=:6 , FSUP_NO=:7 , FSUPFAC_CODE=:8 , FSUPMATR_NO=:9 , FPARTNO=:10 , FPARTS_PRODUCTIONDATE=to_date(:11, 'YYYY-MM-DD') , FPART_IDCODE=:12 , FBUG_BAS_CODE=:13 , FBUG_CODE=:14 , FS_MODE=:15 , FS_DPHC=:16 , FS_DCAC=:17 , FFAULT_CONDITION=:18 , FFAULT_ANALYSIS1=:19 , FFAULT_ANALYSIS2=:20 , FFAULT_LIABILITY=:21 , FS_PMET=:22 , FS_DTYC=:23 , FNOTES=:24 , IS_INUSE=:25 , CHANGER=:26 , CHANGEDATE=to_date(:27, 'YYYY-MM-DD hh24:mi:ss') , FCLIENT=:28 , FBAK01=:29 , FBAK02=:30 , FBAK03=:31 , FBAK04=:32 , FBAK05=:33 , FBAK06=:34 , FBAK07=:35 , FBAK08=:36 , FBAK09=:37 , FBAK10=:38 , ISLOCKSTATUSSYS=:39 , CURRENTROLESYS=:40 , CURRENTUSERGORUPSYS=:41 , ISSTARTRECYCLE=:42 , SHAREROLESYS=:43 , SHAREUSERSYS=:44 , SHAREDEPARTMENTSYS=:45 , SHAREUSERGROUP=:46 , SALES_ORG=:47 , DISTR_CHAN=:48 , DIVISION=:49 , SALES_OFFICE=:50 , SALES_GROUP=:51 , SALES_AREA=:52 , IS_DELETESYS=:53 , UPDATE_DATESYS=:54 , FBAK11=:55 , FPRODUCT_COMPANYNO=:56 WHERE FCODEID=:57
ga9v6nn3u1b2r	select inst_id, begin_time, metric_id, value from gv$sysmetric where intsize_csec > 5900 and group_id = 2 and metric_id in (2148, 2149, 2137, 2138, 2141, 2140, 2139, 2091, 2090, 2089, 2088, 2087, 2142, 2144) order by begin_time, metric_id
gduq3af4cj1cr	SELECT a.FBUY_DATE FROM YCSCP020 a WHERE a.FPRODUCT_SERIAL='J1BL5C01127'
gdx3yf4txx68t	SELECT * FROM ( SELECT ROW_.*, ROWNUM ROWNUM_ FROM ( SELECT YCSFW020.FCODEID, YCSFW020.FSERV_LIST, YCSFW020.FSERV_TYPE, YCSFW020.FFILE_LIST, YCSFW020.FSERV_STATIONNO, YCSFW020.FSERVICE_AGENTNO, YCSFW020.FOFFICE_NO, YCSFW020.FSURVEYOR_NO, YCSFW020.FMESSENGER_NO, YCSFW020.FPROD_TYPE, YCSFW020.FPRODUCT, YCSFW020.FPRODUCT_SERIAL, YCSFW020.FPRODUCT_COMPANYNO, YCSFW020.FMILEAGE, YCSFW020.FMILEAGE_UNIT, YCSFW020.FUSE, YCSFW020.FUSE_UNIT, to_char(YCSFW020.FCALL_TIME, 'YYYY-MM-DD hh24:mi') as FCALL_TIME, to_char(YCSFW020.FCOMPLETION_TIME, 'YYYY-MM-DD hh24:mi') as FCOMPLETION_TIME, to_char(YCSFW020.FARRIVAL_TIME, 'YYYY-MM-DD hh24:mi') as FARRIVAL_TIME, to_char(YCSFW020.FTRAILER_TIME, 'YYYY-MM-DD hh24:mi') as FTRAILER_TIME, to_char(YCSFW020.FPART_TIME, 'YYYY-MM-DD hh24:mi') as FPART_TIME, YCSFW020.FTROUBLE_SITES, YCSFW020.FUSER_SATISFACTION, YCSFW020.FNOTES, YCSFW020.FOWNERSHIP_UNITS, YCSFW020.FACCEPT_LIST, YCSFW020.FACCEPT_TYPE, YCSFW020.FCALL_TYPE, YCSFW020.FCALL_UNIT, YCSFW020.FSOURCE_LIST, YCSFW020.FCALL, YCSFW020.FCALLER, YCSFW020.FCUSTOMER, YCSFW020.FCUSTOMER_CALL1, YCSFW020.FCUSTOMER_CALL2, YCSFW020.FCUS_FEEDBACK, YCSFW020.FSEND_ADDRESS, YCSFW020.FWORK_CONTENT, YCSFW020.FCHARGE_PERSON, YCSFW020.FCHARGE_ORG, YCSFW020.FPERFORM_ORG, YCSFW020.FLIST_STATE, YCSFW020.FBILLING_STATUS, YCSFW020.FCLAIM_STATUS, YCSFW020.IS_INUSE, YCSFW020.CREATER, to_char(YCSFW020.CREATEDATE, 'YYYY-MM-DD hh24:mi:ss') as CREATEDATE, YCSFW020.CHANGER, to_char(YCSFW020.CHANGEDATE, 'YYYY-MM-DD hh24:mi:ss') as CHANGEDATE, YCSFW020.FCLIENT, YCSFW020.FBAK03, to_char(YCSFW020.FBAK04, 'YYYY-MM-DD hh24:mi') as FBAK04, YCSFW020.FBAK05, YCSFW020.FBAK06, YCSFW020.FBAK07, YCSFW020.FBAK08, YCSFW020.FBAK09, YCSFW020.FBAK10, YCSFW020.ISLOCKSTATUSSYS, YCSFW020.CURRENTUSERSYS, YCSFW020.CURRENTROLESYS, YCSFW020.CURRENTUSERGORUPSYS, YCSFW020.CURRENTDEPARTMENTSYS, YCSFW020.ISSTARTRECYCLE, YCSFW020.SHAREROLESYS, YCSFW020.SHAREUSERSYS, YCSFW020.SHAREDEPARTMENTSYS, YCSFW020.SHAREUSERGROUP, YCSFW020.SALES_ORG, YCSFW020.DISTR_CHAN, YCSFW020.DIVISION, YCSFW020.SALES_OFFICE, YCSFW020.IS_DELETESYS, YCSFW020.UPDATE_DATESYS, to_char(YCSFW020.FBAK11, 'YYYY-MM-DD hh24:mi:ss') as FBAK11, YCSFW020.FBAK01, YCSFW020.FBAK02, YCSFW020.FBILLINGITEM_STATUS, YCSFW020.SALES_GROUP, YCSFW020.FBILLING_COMPANYNO, to_char(YCSFW020.FLIST_ENDDATE, 'YYYY-MM-DD hh24:mi:ss') as FLIST_ENDDATE, YCSFW020.FOUT_STATE, YCSFW020.FLOCK_STATE, YCSFW020.FLOCK_REASON, to_char(YCSFW020.FUNLOCK_TIME, 'YYYY-MM-DD hh24:mi:ss') as FUNLOCK_TIME, YCSFW020.SALES_AREA FROM YCSFW020 YCSFW020 LEFT JOIN (SELECT MD.FBUS_SECTION, MD.FUSE1, CP.FPRODUCT_SERIAL, MD.FMATR_NO FROM MDMBMD040 MD LEFT JOIN YCSCP020 CP ON MD.FMATR_NO=CP.FMATR_NO) TP ON YCSFW020.FPRODUCT=TP.FPRODUCT_SERIAL LEFT JOIN (SELECT YCSFW030.FSERV_LIST, YCSFW030.FCUSMATR_NO, YCSFW030.FSUP_NO, YCSFW030.FS_PMET FROM YCSFW030) YCSFW030 ON YCSFW030.FSERV_LIST=YCSFW020.FSERV_LIST LEFT JOIN (SELECT a.FS_PMET, a.FS_ABBR FROM MDMCOM103 a) COM ON COM.FS_PMET=YCSFW030.FS_PMET WHERE YCSFW020.ISLOCKSTATUSSYS LIKE '%0%' AND (YCSFW020.CURRENTUSERSYS IN('YCA450015') OR YCSFW020.FCODEID in ('1729', '1762') ) ORDER BY YCSFW020.FCODEID DESC ) ROW_ WHERE ROWNUM <= :1) WHERE ROWNUM_ > :2
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