WORKLOAD REPOSITORY PDB report (root snapshots)

DB Name	DB Id	Unique Name	Role	Edition	Release	RAC	CDB
CDBFINI2	43681096	CDBFINI2	PRIMARY	XP	19.0.0.0.0	YES	YES

Instance	Inst Num	Startup Time	User Name	System Data Visible
CDBFINI21	1	02-Nov-24 11:09	SYS	YES

Container DB Id	Container Name	Open Time
4009012992	PDBFINI2	02-Nov-24 11:11

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
etic1pdb03	Linux x86 64-bit	4	2	2	393.16

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	16511	07-Feb-25 19:00:32	326	22.8
End Snap:	16515	07-Feb-25 23:00:26	353	21.1
Elapsed:		239.90 (mins)
DB Time:		48.43 (mins)

Report Summary

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.2	0.1	0.00	0.00
DB CPU(s):	0.1	0.0	0.00	0.00
Background CPU(s):	0.0	0.0	0.00	0.00
Redo size (bytes):	2,342.7	968.3
Logical read (blocks):	8,568.3	3,541.6
Block changes:	14.7	6.1
Physical read (blocks):	117.8	48.7
Physical write (blocks):	0.0	0.0
Read IO requests:	5.5	2.3
Write IO requests:	0.0	0.0
Read IO (MB):	0.9	0.4
Write IO (MB):	0.0	0.0
IM scan rows:	0.0	0.0
Session Logical Read IM:	0.0	0.0
Global Cache blocks received:	22.5	9.3
Global Cache blocks served:	0.0	0.0
User calls:	80.2	33.1
Parses (SQL):	1.2	0.5
Hard parses (SQL):	0.0	0.0
SQL Work Area (MB):	0.5	0.2
Logons:	0.1	0.0
User logons:	0.0	0.0
Executes (SQL):	80.4	33.2
Rollbacks:	2.3	1.0
Transactions:	2.4

Top 10 Foreground Events by Total Wait Time

Wait Classes by Total Wait Time

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	5.9	5.9	0.0
Database Requests:	5.5	5.5	0.0
Optimized Requests:	5.9	5.9	0.0
Redo Requests:
Total (MB):	0.9	0.9	0.0
Database (MB):	0.9	0.9	0.0
Optimized Total (MB):	0.9	0.9	0.0
Redo (MB):
Database (blocks):	117.8	117.8	0.0
Via Buffer Cache (blocks):	5.0	5.0	0.0
Direct (blocks):	112.8	112.8	0.0

Database Resource Limits

	Begin	End
CPUs:	8	4
SGA Target:	7,969,177,600	7,969,177,600
PGA Target:	5,242,880,000	5,242,880,000
Memory Target	0	0

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Wait Statistics
• Undo Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Initialization Parameters
• Active Session History (ASH) Report
• ADDM Reports

Wait Events Statistics

• Time Model Statistics
• Foreground Wait Class
• Foreground Wait Events
• Service Statistics
• Service Wait Class Stats
• Top Process Types by Wait Class
• Top Process Types by CPU Used

Time Model Statistics

• DB Time represents total time in user calls
• DB CPU represents CPU time of foreground processes
• Total CPU Time represents foreground and background processes
• Statistics including the word "background" measure background process time, therefore do not contribute to the DB time statistic
• Ordered by % of DB time in descending order, followed by Statistic Name

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond, us - microsecond, ns - nanosecond
• 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 52.7% of Total DB time 2,905.93 (s)
• Total FG Wait Time: 738.92 (s) DB CPU time: 793.46 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond, us - microsecond, ns - nanosecond
• 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

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

Top Process Types by Wait Class

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Top Process Types by CPU Used

No data exists for this section of the report.

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 Offload Eligible Bytes
• 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 93.8% of Total DB Time (s): 2,906
• Captured PL/SQL account for 60.0% of Total DB Time (s): 2,906

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 71.9% of Total CPU Time (s): 793
• Captured PL/SQL account for 42.8% of Total CPU Time (s): 793

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

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: 123,334,095
• Captured SQL account for 99.7% 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: 1,696,048
• Captured SQL account for 137.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqs - (Optimized Read Reqs - Cell Flash Cache Read Hits for Controlfile)
• %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: 79,720
• Captured SQL account for 183.5% of Total
• Total UnOptimized Read Requests: 1
• Captured SQL account for 1.2E+05% of Total
• Total Optimized Read Requests: 84,219
• Captured SQL account for 172.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Offload Eligible Bytes

• Offload Eligible Bytes are eligible for offload on Exadata
• %Ret SS - percentage of Interconnect GB returned for Smart Scan
• %Cell Eff - Cell Offload Efficiency
• %Total - Offload Eligible Bytes as a percentage of Total Offload Elig Bytes
• Total Offload Eligible GB: 12
• Captured SQL account for 102.3% of Total
• Total IO Interconnect GB: 1
• Captured SQL account for 818.3% of Total
• Total Uncompressed GB: 0
• Captured SQL account for 201.5% 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: 1,157,069
• Captured SQL account for 100.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 16,629
• Captured SQL account for 53.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): 600
• Captured SQL account for 94.9% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
01d5n1nm17r2h	select nvl2(stale_stats, decode(stale_stats, 'NO', 3, 1), 2) from dba_ind_statistics where owner=:1 and index_name=:2
142rj761ckuwk	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((602, 48122)) OR (R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) IN ((0, 4))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
14xvw340bb2xz	begin :s := FND_CP_GSM_IPC.Get_Status(:h); end;
23s96rf87635s	select count(*) from sys.col_group_usage$ where obj# = :1 and cols = :2 and trunc(sysdate) = trunc(timestamp) and bitand(flags, :3) = :3
24pgux6v1rpuz	select sum(space_usage_kbytes) from v$sysaux_occupants
2gfw51wrma0wc	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((101, 20215), (50001, 64527)) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((50, 44069), (50, 46333), (200, 37306), (200, 55405), (222, 42109), (222, 42110), (602, 48093), (602, 48096)))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
2mwvn9xwq1tz3	select (RUNNING_PROCESSES-MAX_PROCESSES) , MAX_PROCESSES , NVL(SLEEP_SECONDS, 0) , DIAGNOSTIC_LEVEL into :b0, :b1, :b2, :b3:b4 from FND_CONCURRENT_QUEUES where ((APPLICATION_ID=:b5 and CONCURRENT_QUEUE_ID=:b6) and (TARGET_NODE=:b7 or (TARGET_NODE is null and :b7 is null )))
2rhptsz3hb1zg	delete from WRM$_SNAPSHOT_DETAILS snap_det where snap_det.dbid = :dbid and snap_det.snap_id >= :beg_snap and snap_det.snap_id <= :end_snap
3kqrku32p6sfn	MERGE /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ INTO OPTSTAT_USER_PREFS$ D USING ( SELECT * FROM (SELECT O.OBJ#, SYSTIMESTAMP CHGTIME, ROUND(MAX(S.DELTA_READ_IO_BYTES/S.DELTA_TIME), 3) SCANRATE FROM GV$ACTIVE_SESSION_HISTORY S, GV$SQL_PLAN P, OBJ$ O, USER$ U WHERE S.INST_ID = P.INST_ID AND S.SQL_ID = P.SQL_ID AND S.SQL_PLAN_HASH_VALUE = P.PLAN_HASH_VALUE AND S.SQL_PLAN_LINE_ID = P.ID AND P.OBJECT_NAME = O.NAME AND (:B4 IS NULL OR O.OBJ# = :B4 ) AND O.OWNER# = U.USER# AND P.OBJECT_OWNER = U.NAME AND O.TYPE# = 2 AND S.CON_ID = SYS_CONTEXT('userenv', 'con_id') AND P.CON_ID = SYS_CONTEXT('userenv', 'con_id') AND S.SQL_PLAN_OPERATION = 'TABLE ACCESS' AND P.OPERATION = 'TABLE ACCESS' AND S.DELTA_TIME > 0 AND S.DELTA_READ_IO_BYTES > 0 AND FROM_TZ(S.SAMPLE_TIME, :B3 ) > :B2 AND (:B1 = 'ON' OR (:B1 = 'HADOOP_ONLY' AND EXISTS ( SELECT NULL FROM SYS.EXTERNAL_TAB$ ET WHERE ET.OBJ# = O.OBJ# AND TYPE$ IN ('ORACLE_HIVE', 'ORACLE_HDFS', 'ORACLE_BIGDATA')))) GROUP BY O.OBJ#) C WHERE NOT EXISTS (SELECT NULL FROM OPTSTAT_USER_PREFS$ PR WHERE PNAME = 'SCAN_RATE' AND C.OBJ# = PR.OBJ# AND (PR.SPARE1 IS NULL OR C.SCANRATE <= TO_NUMBER(PR.VALCHAR))) ) SRC ON (D.OBJ#=SRC.OBJ# AND D.PNAME = 'SCAN_RATE') WHEN MATCHED THEN UPDATE SET D.VALCHAR= TO_CHAR(SRC.SCANRATE), D.CHGTIME=SRC.CHGTIME, D.SPARE1=1 WHEN NOT MATCHED THEN INSERT (OBJ#, PNAME, VALCHAR, CHGTIME, SPARE1) VALUES(SRC.OBJ#, 'SCAN_RATE', TO_CHAR(SRC.SCANRATE), SRC.CHGTIME, 1)
3wrrjm9qtr2my	SELECT T.CLIENT_ID, T.OPERATION_ID, T.TARGET_TYPE, T.TARGET_NAME, T.CURR_JOB_NAME, TO_NUMBER(BITAND(T.ATTRIBUTES, 131072)), CASE NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'RUNNING' THEN 1 WHEN 'DISABLED' THEN 2 WHEN 'SCHEDULED' THEN 3 WHEN 'RETRY SCHEDULED' THEN 99 WHEN 'COMPLETED' THEN 99 WHEN 'BROKEN' THEN 99 WHEN 'FAILED' THEN 99 WHEN 'REMOTE' THEN 99 WHEN 'SUCCEEDED' THEN 99 WHEN 'STOPPED' THEN 99 WHEN 'CHAIN_STALLED' THEN 99 ELSE 99 END AS CONSOLIDATED_STATE, CASE NVL(JRD.STATUS, 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'SUCCEEDED' THEN 10 WHEN 'FAILED' THEN 11 WHEN 'STOPPED' THEN CASE WHEN JRD.ADDITIONAL_INFO LIKE '%called by user%' THEN 12 WHEN JRD.ADDITIONAL_INFO LIKE '%window was closed%' THEN 13 WHEN JRD.ADDITIONAL_INFO LIKE 'ORA-01014%' THEN 14 ELSE 15 END ELSE 99 END AS STATUS, NVL(JRD.RUN_DURATION, INTERVAL '0' SECOND), NVL(JRD.CPU_USED, INTERVAL '0' SECOND), NVL(JRD.ERROR#, 0), NVL(JRD.STATUS, 'NO LOG ENTRY') || '(jrd)' AS DBG_STATUS, NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') ||'(jobs)' AS DBG_STATE, NVL(JRD.LOG_DATE, TIMESTAMP '2001-01-01 01:01:01.01 +01:01'), NVL(JRD.LOG_ID, 0) FROM KET$_CLIENT_TASKS T, DBA_SCHEDULER_JOB_RUN_DETAILS JRD WHERE T.CURR_JOB_NAME IS NOT NULL AND T.CURR_JOB_NAME = JRD.JOB_NAME(+) AND 'SYS' = JRD.OWNER(+)
3y5b3uba1419p	SELECT RCTTA.NAME , HOU.ORGANIZATION_ID, HCSUA.SITE_USE_ID, RCTA.BILL_TO_CUSTOMER_ID, RCTA.CUSTOMER_TRX_ID ID_AVOIR, HOU.NAME UO, HCP.SITE_USE_ID SUT, HP.PARTY_NAME NOM_CLIENT, HCA.ACCOUNT_NUMBER CODE_CLIENT_ORACLE, RCTA.TRX_NUMBER NUM_AVOIR, (SELECT DISTINCT EXTPAYERSEO.DEBIT_ADVICE_EMAIL FROM IBY_EXTERNAL_PAYERS_ALL EXTPAYERSEO WHERE HP.PARTY_ID = EXTPAYERSEO.PARTY_ID AND HOU.ORGANIZATION_ID = EXTPAYERSEO.ORG_ID AND HCSUA.SITE_USE_ID = EXTPAYERSEO.ACCT_SITE_USE_ID AND HCA.CUST_ACCOUNT_ID = EXTPAYERSEO.CUST_ACCOUNT_ID ) MAIL, RCTA.TRX_DATE DATE_AVOIR, SUM(RCTL.EXTENDED_AMOUNT) MONTANT_AVOIR, PS.AMOUNT_DUE_REMAINING MONTANT_NON_SOLDE, RCTA.ATTRIBUTE7 COMMENTAIRE, SUBSTR(RCTA.ATTRIBUTE12, 1, 100) REF_VIR_CLI, PS.CLASS, RCTA.ATTRIBUTE6, HCA.CUST_ACCOUNT_ID, HP.ADDRESS2 || ' ' || HP.ADDRESS3 || ' ' || HP.ADDRESS4 || ' ' || HP.CITY SITE_ORACLE, RCTA.ORG_ID, HP.PARTY_ID, ( CASE WHEN ( SELECT COUNT(EBA.IBAN) FROM HZ_CUST_ACCOUNTS CA, IBY_EXTERNAL_PAYERS_ALL EPA, IBY_PMT_INSTR_USES_ALL PIU, IBY_EXT_BANK_ACCOUNTS EBA WHERE CA.CUST_ACCOUNT_ID = EPA.CUST_ACCOUNT_ID AND PIU.EXT_PMT_PARTY_ID = EPA.EXT_PAYER_ID AND PIU.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT' AND EBA.EXT_BANK_ACCOUNT_ID = PIU.INSTRUMENT_ID AND CA.PARTY_ID = HP.PARTY_ID AND NVL(PIU.END_DATE, SYSDATE+1) > SYSDATE AND PIU.START_DATE <= SYSDATE AND RCTA.BILL_TO_CUSTOMER_ID =CA.CUST_ACCOUNT_ID AND EPA.ORG_ID = RCTA.ORG_ID ) < 2 THEN ( SELECT EBA.IBAN FROM HZ_CUST_ACCOUNTS CA, IBY_EXTERNAL_PAYERS_ALL EPA, IBY_PMT_INSTR_USES_ALL PIU, IBY_EXT_BANK_ACCOUNTS EBA WHERE CA.CUST_ACCOUNT_ID = EPA.CUST_ACCOUNT_ID AND PIU.EXT_PMT_PARTY_ID = EPA.EXT_PAYER_ID AND PIU.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT' AND EBA.EXT_BANK_ACCOUNT_ID = PIU.INSTRUMENT_ID AND CA.PARTY_ID = HP.PARTY_ID AND NVL(PIU.END_DATE, SYSDATE+1) > SYSDATE AND PIU.START_DATE <= SYSDATE AND RCTA.BILL_TO_CUSTOMER_ID =CA.CUST_ACCOUNT_ID AND EPA.ORG_ID = RCTA.ORG_ID ) ELSE NULL END ) IBAN, AR.NAME CODE_CHARGE_RECOUVR, HCASA.ATTRIBUTE3 CODE_ANAEL, (CASE WHEN RCTA.ATTRIBUTE6 = 'OUI' THEN RCTA.ATTRIBUTE9 ELSE NULL END )MOTIF_REJET FROM HZ_CUST_ACCOUNTS HCA, RA_CUSTOMER_TRX_ALL RCTA, RA_CUSTOMER_TRX_LINES_ALL RCTL, AR_PAYMENT_SCHEDULES_ALL PS, HZ_PARTIES HP, HR_OPERATING_UNITS HOU, XLE_ENTITY_PROFILES XEP, HZ_CUST_SITE_USES_ALL HCSUA, AR.HZ_CUSTOMER_PROFILES HCP, AR_COLLECTORS AR, HZ_CUST_ACCT_SITES_ALL HCASA, HZ_PARTY_SITES HPS, RA_CUST_TRX_TYPES_ALL RCTTA WHERE 1 = 1 AND RCTA.BILL_TO_SITE_USE_ID = HCP.SITE_USE_ID AND HCA.PARTY_ID = HCP.PARTY_ID AND HCASA.PARTY_SITE_ID = HPS.PARTY_SITE_ID AND AR.COLLECTOR_ID = HCP.COLLECTOR_ID AND HCASA.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID AND HCSUA.CUST_ACCT_SITE_ID = HCASA.CUST_ACCT_SITE_ID AND HCP.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID AND HCP.SITE_USE_ID = HCSUA.SITE_USE_ID AND HP.PARTY_ID = HCA.PARTY_ID AND HCA.CUST_ACCOUNT_ID = RCTA.BILL_TO_CUSTOMER_ID AND RCTA.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_ID AND RCTA.ORG_ID = HOU.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = HCSUA.ORG_ID AND PS.CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID AND NVL(PS.AMOUNT_DUE_REMAINING, 0) <> 0 AND PS.CLASS = 'CM' AND XEP.LEGAL_ENTITY_ID = HOU.DEFAULT_LEGAL_CONTEXT_ID AND RCTA.CUST_TRX_TYPE_ID = RCTTA.CUST_TRX_TYPE_ID AND RCTTA.NAME IN ('MAN_AVOIR', 'SI_AMONT_AVOIR') AND RCTA.ATTRIBUTE6 = 'OUI' AND HOU.ORGANIZATION_ID IN (SELECT DISTINCT HOUI.ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS HOUI WHERE SUBSTR(HOUI.NAME, 1, 3) = NVL(:B1 , SUBSTR(HOUI.NAME, 1, 3))) GROUP BY HOU.ORGANIZATION_ID, HCSUA.SITE_USE_ID, HCA.CUST_ACCOUNT_ID, RCTA.BILL_TO_CUSTOMER_ID, HOU.NAME, AR.NAME, HCP.SITE_USE_ID, RCTA.CUSTOMER_TRX_ID, HCASA.ATTRIBUTE3, HCSUA.CUST_ACCT_SITE_ID, HCSUA.SITE_USE_ID, HCA.ACCOUNT_NUMBER, RCTA.TRX_NUMBER, RCTA.TRX_DATE, PS.AMOUNT_DUE_REMAINING, RCTA.ATTRIBUTE7, RCTA.ATTRIBUTE12, PS.CLASS, HCA.CUST_ACCOUNT_ID, RCTA.ATTRIBUTE6, HP.PARTY_NAME, HP.ADDRESS2, HP.ADDRESS3, HP.ADDRESS4, HP.CITY, RCTA.ORG_ID, HP.PARTY_ID, RCTA.ATTRIBUTE9, RCTTA.NAME ORDER BY MONTANT_AVOIR, NOM_CLIENT, NUM_AVOIR
42dtkhnmbk83f	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) IN ((0, 5))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
46cav1a1ytfww	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) IN ((0, 6), (50001, 10))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
4dck8dxwd753p	select 'X' into :b0 from FND_CONCURRENT_QUEUES where ((APPLICATION_ID=:b1 and CONCURRENT_QUEUE_ID=:b2) and RUNNING_PROCESSES>MAX_PROCESSES) for update of RUNNING_PROCESSES
4s2v1trm8kabf	BEGIN DKA_SARSELECAVOIR_PKG.main(:errbuf, :rc, :A0, :A1); END;
520mkxqpf15q8	select 1 from dual
586577qpbkgnk	select 1 from DBA_SCHEDULER_JOBS where JOB_NAME like 'KWQICPOSTMSGDEL_1_%' and JOB_ACTION = 'DBMS_AQADM_SYS.REMOVE_ORPHMSGS'
5cu0x10yu88sw	merge into sys.wri$_index_usage iu using dual on (iu.obj# = :objn) when matched then update set iu.total_access_count = iu.total_access_count + :ns, iu.total_rows_returned = iu.total_rows_returned + :rr, iu.total_exec_count = iu.total_exec_count + :ne, iu.bucket_0_access_count = iu.bucket_0_access_count + :nsh0, iu.bucket_1_access_count = iu.bucket_1_access_count + :nsh1, iu.bucket_2_10_access_count = iu.bucket_2_10_access_count + :nsh2_10, iu.bucket_2_10_rows_returned = iu.bucket_2_10_rows_returned + :nrh2_10, iu.bucket_11_100_access_count = iu.bucket_11_100_access_count + :nsh11_100, iu.bucket_11_100_rows_returned = iu.bucket_11_100_rows_returned + :nrh11_100, iu.bucket_101_1000_access_count = iu.bucket_101_1000_access_count + :nsh101_1000, iu.bucket_101_1000_rows_returned = iu.bucket_101_1000_rows_returned + :nrh101_1000, iu.bucket_1000_plus_access_count = iu.bucket_1000_plus_access_count + :nsh1000plus, iu.bucket_1000_plus_rows_returned = iu.bucket_1000_plus_rows_returned + :nrh1000plus, last_used = SYSDATE when NOT matched then insert (iu.obj#, iu.total_access_count, iu.total_rows_returned, iu.total_exec_count, iu.bucket_0_access_count, iu.bucket_1_access_count, iu.bucket_2_10_access_count, iu.bucket_2_10_rows_returned, iu.bucket_11_100_access_count, iu.bucket_11_100_rows_returned, iu.bucket_101_1000_access_count, iu.bucket_101_1000_rows_returned, iu.bucket_1000_plus_access_count, iu.bucket_1000_plus_rows_returned, iu.last_used) values (:objn, :ns, :rr, :ne, :nsh0, :nsh1, :nsh2_10, :nrh2_10, :nsh11_100, :nrh11_100, :nsh101_1000, :nrh101_1000, :nsh1000plus, :nrh1000plus, SYSDATE)
5dqz0hqtp9fru	select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand(nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
6451cyrxb8fms	SELECT COUNT (*) FROM V$THREAD
6hnhqahphpk8n	select free_mb from v$asm_diskgroup_stat where name=:1
6ja8mjk9v08su	update Fnd_Concurrent_Requests set Phase_Code=DECODE(phase_code, 'C', phase_code, :b0), Status_Code=DECODE(phase_code, 'C', DECODE(status_code, 'C', DECODE(:b1, 'W', 'W', 'C'), status_code), :b1), Completion_Text=DECODE(Completion_Text, null , :b3, Completion_Text), Has_Sub_Request=DECODE(Has_Sub_Request, 'Y', 'Y', :b4), Req_Information=:b5, Actual_Completion_Date=SYSDATE, Requested_Start_Date=DECODE(:b6, 'Y', TO_DATE(:b7, 'YYYY/MM/DD HH24:MI:SS'), Requested_Start_Date), Resubmitted=:b6, Outcome_Product=:b9, Outcome_Code=null , OFile_Size=decode(to_number(:b10), '-1', null , to_number(:b10)), LFile_Size=decode(to_number(:b12), '-1', null , to_number(:b12)), node_name1=decode(:b14, 'Y', :b15, node_name1) where Request_Id=:b16
6mcpb06rctk0x	call dbms_space.auto_space_advisor_job_proc ( )
6nyajc8nx9tb5	begin fnd_dcp.get_lk_handle (:a, :q, :p, :h, :e, :t); end;
6wrwqq7jkmv3w	INSERT INTO WRI$_HEATMAP_TOPN_DEP2 SELECT TABLE_NAME, OWNER, 'LOBS', SUM(SEGMENT_COUNT), SUM(OBJECT_SIZE) FROM DBA_LOBS, WRI$_HEATMAP_TOPN_DEP1 WHERE WRI$_HEATMAP_TOPN_DEP1.OBJECT_NAME = DBA_LOBS.SEGMENT_NAME AND WRI$_HEATMAP_TOPN_DEP1.OBJECT_OWNER = DBA_LOBS.OWNER GROUP BY TABLE_NAME, OWNER UNION SELECT TABLE_NAME, OWNER, 'INDEX', SUM(SEGMENT_COUNT), SUM(OBJECT_SIZE) FROM DBA_INDEXES , WRI$_HEATMAP_TOPN_DEP1 WHERE WRI$_HEATMAP_TOPN_DEP1.OBJECT_NAME = DBA_INDEXES.INDEX_NAME AND WRI$_HEATMAP_TOPN_DEP1.OBJECT_OWNER = DBA_INDEXES.OWNER GROUP BY TABLE_NAME, OWNER UNION SELECT OBJECT_NAME, OBJECT_OWNER, 'DATA', SUM(SEGMENT_COUNT), SUM(OBJECT_SIZE) FROM WRI$_HEATMAP_TOPN_DEP1 WHERE OBJECT_TYPE LIKE '%TABLE%' GROUP BY OBJECT_NAME, OBJECT_OWNER
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
6ymxhj8mfgb46	select sum(bytes)/1024.0 from dba_segments where owner = 'SYS' and (segment_name like 'WRI$_OPTSTAT_OPR%' or segment_name like 'WRI$_OPTSTAT%HIST%')
718j110y001s6	SELECT VALUE FROM V$PARAMETER WHERE NAME='heat_map'
776vq88169z77	select ceil((select nvl(sum(bytes)/1024/1024, 0) from v$datafile) + (select nvl(sum(bytes)/1024/1024, 0) from v$tempfile)) SIZE_IN_MB from dual
7b5w34atn8q1h	BEGIN FND_CP_OPP_IPC.Get_Message(:1, :2, :3, :4, :5, :6, :7, :8); END;
7tmhqajvc3wyx	SELECT COUNT(*) FROM SYS.SYS_UNCOMPRESSED_SEGS WHERE TOTAL_INDEXES >= 3 AND SEGSIZE > 10485760
8cpwjpm11v8wu	SELECT /*+ ordered full(t) full(o) use_hash(o) OPT_PARAM('_parallel_syspls_obey_force' 'false') */ 'TABLE' OBJTYPE, U.NAME OWNNAME, O.NAME OBJNAME, NULL PARTNAME, NULL SUBPARTNAME, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS, O.OBJ# OBJ_NUM, '0' FXT_TYP, :B7 REASON, 0 STALENESS FROM SYS.TAB$ T, SYS.OBJ$ O, SYS.USER$ U WHERE ((:B6 IS NULL) OR (U.NAME = :B6 )) AND ((:B5 IS NOT NULL) OR (U.NAME != 'SYS')) AND BITAND(T.PROPERTY, 512) != 512 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND (:B4 IS NOT NULL OR BITAND(T.PROPERTY, 2147483648) != 2147483648) AND (:B3 IS NOT NULL OR BITAND(T.PROPERTY, 4294967296) != 4294967296) AND BITAND(O.FLAGS, 128) != 128 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 ((:B2 IS NOT NULL) OR (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608)) 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 T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND O.TYPE# = 2 AND O.LINKNAME IS NULL AND (:B1 = 0 OR BITAND(T.TRIGFLAG, :B1 ) != :B1 ) UNION ALL SELECT * FROM ( SELECT /*+ ordered use_nl(c) use_nl(o) use_nl(u) */ 'INDEX' OBJTYPE, U.NAME OWNNAME, O.NAME OBJNAME, NULL PARTNAME, NULL SUBPARTNAME, ( SELECT /*+ index(t) */ DECODE(SUM(BITAND(T.TRIGFLAG, 67108864)), 0, 0, 67108864) + DECODE(SUM(BITAND(T.TRIGFLAG, 134217728)), 0, 0, 134217728) FROM SYS.TAB$ T WHERE I.BO# = T.BOBJ#) LOCK_FLAGS, O.OBJ# OBJ_NUM, '0' FXT_TYP, :B7 REASON, 0 STALENESS FROM SYS.IND$ I, SYS.CLU$ C, SYS.OBJ$ O, SYS.USER$ U WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B8 ) IS NOT NULL) AND ((:B6 IS NULL) OR (U.NAME = :B6 )) AND ((:B5 IS NOT NULL) OR (U.NAME != 'SYS')) AND I.BO# = C.OBJ# AND I.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND O.TYPE# = 1 AND I.TYPE# = 3 AND O.LINKNAME IS NULL AND BITAND(O.FLAGS, 128) != 128 ) WHERE :B1 = 0 OR BITAND(LOCK_FLAGS, :B1 ) != :B1 UNION ALL SELECT 'TABLE' OBJTYPE, 'SYS' OWNNAME, KQFTANAM OBJNAME, NULL PARTNAME, NULL SUBPARTNAME, BITAND(FOBJ.FLAGS, 67108864 + 134217728) LOCK_FLAGS, KQFTAOBJ OBJ_NUM, TO_CHAR(KQFTATYP) FXT_TYP, :B7 REASON, 0 STALENESS FROM SYS.X$KQFTA FXT, SYS.FIXED_OBJ$ FOBJ, X$KQFOPT OPT WHERE :B10 IS NOT NULL AND BITAND(FXT.KQFTAFLG, 16) != 16 AND ((:B6 IS NULL) OR (:B6 = 'SYS')) AND FOBJ.OBJ# = FXT.KQFTAOBJ AND (:B1 = 0 OR BITAND(FOBJ.FLAGS, :B1 ) != :B1 ) AND FOBJ.OBJ# = OPT.KQFOPTOBJ(+) AND (:B9 IS NULL OR OPT.KQFOPTFLAGS IS NULL OR BITAND(OPT.KQFOPTFLAGS, 16+32) = 0) ORDER BY 3, 1 DESC, 2
8g1nuzkqg2puj	INSERT INTO WRI$_HEATMAP_TOPN_DEP1 SELECT SEGMENT_NAME, OWNER, SEGMENT_TYPE, COUNT(*), SUM(BYTES) FROM SYS_DBA_SEGS WHERE TABLESPACE_NAME = :B1 AND BITAND(SEGMENT_FLAGS, 65536) <> 65536 GROUP BY SEGMENT_NAME, OWNER, SEGMENT_TYPE, TABLESPACE_NAME
8r13yasynfh61	begin dbms_stats_internal.execute_advisor_auto_task(:client); end;
a5fasv0jz2mx2	insert into stats_advisor_filter_obj$ (rule_id, obj#, flags, type) select :rule_id, obj#, :flag_include, :type_expanded from stats_advisor_filter_obj$ where type = :type_priv and (bitand(flags, :flag_orcl_owned) = 0 or :get_orcl_objects = 'T') and obj# not in (select obj# from stats_advisor_filter_obj$ where rule_id = :rule_id and type = :type_user and bitand(flags, :flag_exclude) != 0)
a8xypykqc348c	BEGIN dbms_stats_internal.advisor_setup_obj_filter(:tid, :rid, 'EXECUTE', FALSE); END;
ac8q7kauswfga	insert into Fnd_Concurrent_Requests (Request_Id, Priority_Request_ID, Last_Update_Date, Last_Updated_By, Last_Update_Login, ops_instance, Hold_Flag, Requested_Start_Date, Enforce_Seriality_Flag, Single_Thread_Flag, Request_Date, Requested_By, Number_Of_Copies, Save_Output_Flag, Argument_Input_Method_Code, Priority, Printer, Program_Application_Id, Concurrent_Program_Id, Queue_Method_Code, Request_Class_Application_Id, Concurrent_Request_Class_Id, Oracle_Id, Number_Of_Arguments, Phase_Code, Status_Code, Conc_Login_Id, Responsibility_Id, Responsibility_Application_Id, Nls_Language, Nls_Territory, Nls_numeric_characters, CRM_THRSHLD, Resubmit_Time, Resubmit_Interval, Resubmit_Interval_Unit_Code, Resubmit_Interval_Type_Code, Resubmit_End_Date, Increment_Dates, Resubmitted, Parent_Request_ID, Description, Req_Information, Is_Sub_Request, Has_Sub_Request, Update_Protected, Implicit_Code, Print_Group, Argument_Text, Print_Style, output_file_type, Nls_Compliant, Request_Type, CD_ID, Request_Limit, Enable_Trace, Security_Group_ID, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, ROOT_REQUEST_ID, Argument1, Argument2, Argument3, Argument4, Argument5, Argument6, Argument7, Argument8, Argument9, Argument10, Argument11, Argument12, Argument13, Argument14, Argument15, Argument16, Argument17, Argument18, Argument19, Argument20, Argument21, Argument22, Argument23, Argument24, Argument25, org_id, node_name1, connstr1, edition_name, recalc_parameters, nls_sort, multi_options_map)select :b0 , :b1 , SYSDATE , :b2 , :b3 , :b4 , :b5 , Decode(:b6, '', (SYSDATE-:b7), Greatest(To_Date(:b6, 'YYYY/MM/DD HH24:MI:SS'), Decode(:b9, 0, (SYSDATE-:b7), To_Date('01-01-0001', 'DD-MM-YYYY')))) , 'Y' , :b11 , SYSDATE , :b2 , :b13 , Decode(Fcp.Save_Output_Flag, 'N', 'N', :b14) , :b15 , Decode(Fcp.Queue_Control_Flag, 'Y', NVL(Fcp.request_priority, 0), NVL(Fcp.request_priority, :b16)) , :b17 , Fa.APPLICATION_ID , CONCURRENT_PROGRAM_ID , Decode(:b18, 'Y', 'B', Decode(:b11, 'Y', 'B', QUEUE_METHOD_CODE)) , CLASS_APPLICATION_ID , CONCURRENT_CLASS_ID , ORACLE_ID , :b20 , :b21 , Decode(:b22, 'A', 'A', 'Z', 'Z', Decode(:b23, 'X', 'P', Decode(Queue_Method_Code, 'B', 'Q', Decode(:b11, 'Y', 'Q', Decode(:b18, 'Y', 'Q', 'I'))))) , :b26 , :b27 , :b28 , :b29 , :b30 , Decode(:b31, '', null , :b31) , :b33 , Decode(:b34, '', null , To_Char(To_Date(:b34, Decode(Instr(:b34, ':', 1, 2), 0, 'HH24:MI', 'HH24:MI:SS')), 'HH24:MI:SS')) , Decode(:b37, '', Decode(:b38, (-1), null , :b38), To_Number(:b37)) , :b41 , :b42 , To_Date(Decode(:b43, '', null , :b43), 'YYYY/MM/DD HH24:MI:SS') , :b45 , 'N' , Decode(:b9, 0, null , :b9) , :b48 , null , :b49 , 'N' , :b50 , :b51 , :b52 , :b53 , :b54 , Fcp.Output_File_Type , FCP.Nls_Compliant , Decode(:b55, '0', null , :b55) , :b57 , :b18 , Fcp.Enable_Trace , :b59 , :b60 , Decode(:b61, 0, Decode(:b23, 'P', :b63, null ), :b61) , Decode(:b65, 0, null , :b65) , :b67 , :b68 , :b69 , :b70 , :b71 , :b72 , :b73 , :b74 , :b75 , :b76 , :b77 , :b78 , :b79 , :b80 , :b81 , :b82 , :b83 , :b84 , :b85 , :b86 , :b87 , :b88 , :b89 , :b90 , :b91 , Decode(:b92, (-1), null , :b92) , decode(:b94, 'NULL', null , :b94) , decode(:b96, 'NULL', null , :b96) , sys_context('userenv', 'current_edition_name') , :b98 , :b99 , :b100 from FND_CONCURRENT_PROGRAMS Fcp , FND_ORACLE_USERID , FND_APPLICATION Fa where (((ORACLE_USERNAME=:b101 and Fcp.Enabled_Flag='Y') and (Fcp.APPLICATION_ID=Fa.Application_ID and CONCURRENT_PROGRAM_NAME=:b102)) and Fa.APPLICATION_SHORT_NAME=:b103)
acmvv4fhdc9zh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9, nvl(dflcollid, 16382), creappid, creverid, modappid, modverid, crepatchid, modpatchid from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
au7f6hpnhxpkx	select ts# from ts$ where dflmaxext =:1 and bitand(flags, 1024) =1024 and online$=1
bku5fwd8bhsn6	select count(*) from wri$_optstat_opr o, wri$_optstat_opr_tasks t where o.id = t.op_id(+) and o.operation = 'gather_database_stats (auto)' and ((o.notes like '%<error>%' and not regexp_like( o.notes, '<error>ORA-200[0-9][0-9]')) or (t.notes like '%<error>%' and not regexp_like( t.notes, '<error>ORA-200[0-9][0-9]'))) and rownum=1
ccam3dt03yrca	select nvl(sum(blocks), 0) from DBA_LMT_FREE_SPACE
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
cszf8vk3xm91p	INSERT INTO STATS_ADVISOR_FILTER_OBJ$ (RULE_ID, OBJ#, FLAGS, TYPE) SELECT 0, OBJ#, :B5 + DECODE(BITAND(O.FLAGS, 4194304), 4194304, :B4 , 0), :B3 FROM OBJ$ O, USER$ U WHERE U.NAME = :B2 AND O.OWNER# = U.USER# AND O.NAME = :B1 AND O.SUBNAME IS NULL
ct9ppzr6uuzv9	select owner, segment_name, nvl(sum(blocks), 0) from dba_segments where tablespace_name = :tsname group by owner, segment_name
ctnvx1m6a3yrt	select directory_name from all_directories where directory_path = :1
cufjt3q4n3dzt	select distinct o2.name table_name, o1.name index_name from sys.ind$ i, sys.obj$ o1, sys.obj$ o2 where i.ts# = (select ts# from sys.ts$ where name = :tsname) and i.obj# = o1.obj# and i.bo# = o2.obj#
dhj4zt0649ja3	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) IN ((0, 24))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
f2c368adbbbbx	SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application_ID, P.Concurrent_Program_ID, P.Concurrent_Program_Name, R.Enable_Trace, R.Restart, DECODE(R.Increment_Dates, 'Y', 'Y', 'N'), R.NLS_Compliant, R.OUTPUT_FILE_TYPE, E.Executable_Name, E.Execution_File_Name, A2.Basepath, DECODE(R.Stale, 'Y', 'C', P.Execution_Method_Code), P.Print_Flag, P.Execution_Options, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), P.Argument_Method_Code, R.Print_Style, R.Argument_Input_Method_Code, R.Queue_Method_Code, R.Responsibility_ID, R.Responsibility_Application_ID, R.Requested_By, R.Number_Of_Copies, R.Save_Output_Flag, R.Printer, R.Print_Group, R.Priority, U.User_Name, O.Oracle_Username, O.Encrypted_Oracle_Password, R.Cd_Id, A.Basepath, A.Application_Short_Name, TO_CHAR(R.Requested_Start_Date, 'YYYY/MM/DD HH24:MI:SS'), R.Nls_Language, R.Nls_Territory, R.Nls_Numeric_Characters, DECODE(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority_Request_ID, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Req_Information, R.Description, R.Resubmit_Time, TO_CHAR(R.Resubmit_Interval), R.Resubmit_Interval_Type_Code, R.Resubmit_Interval_Unit_Code, TO_CHAR(R.Resubmit_End_Date, 'YYYY/MM/DD HH24:MI:SS'), Decode(E.Execution_File_Name, NULL, 'N', Decode(E.Subroutine_Name, NULL, Decode(E.Execution_Method_Code, 'I', 'Y', 'J', 'Y', 'N'), 'Y')), R.Argument1, R.Argument2, R.Argument3, R.Argument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100, R.number_of_arguments, C.CD_Name, NVL(R.Security_Group_ID, 0), NVL(R.org_id, -1), NVL(R.request_type, 'R') FROM fnd_concurrent_requests R, fnd_concurrent_programs P, fnd_application A, fnd_user U, fnd_oracle_userid O, fnd_conflicts_domain C, fnd_concurrent_queues Q, fnd_application A2, fnd_executables E, fnd_conc_request_arguments X WHERE R.Status_code = 'I' And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) And R.Request_ID = X.Request_ID(+) And R.Program_Application_Id = P.Application_Id(+) And R.Concurrent_Program_Id = P.Concurrent_Program_Id(+) And R.Program_Application_Id = A.Application_Id(+) And P.Executable_Application_Id = E.Application_Id(+) And P.Executable_Id = E.Executable_Id(+) And P.Executable_Application_Id = A2.Application_Id(+) And R.Requested_By = U.User_Id(+) And R.Cd_Id = C.Cd_Id(+) And R.Oracle_Id = O.Oracle_Id(+) And Q.Application_Id = :q_applid And Q.Concurrent_Queue_Id = :queue_id And (P.Enabled_Flag is NULL OR P.Enabled_Flag = 'Y') And R.Hold_Flag = 'N' And R.Requested_Start_Date <= Sysdate And ( R.Enforce_Seriality_Flag = 'N' OR ( C.RunAlone_Flag = P.Run_Alone_Flag And (P.Run_Alone_Flag = 'N' OR Not Exists (Select Null From Fnd_Concurrent_Requests Sr Where Sr.Status_Code In ('R', 'T') And Sr.Enforce_Seriality_Flag = 'Y' And Sr.CD_id = C.CD_Id)))) And Q.Running_Processes <= Q.Max_Processes And R.Rowid = :reqname And ((P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((50, 44069), (50, 46333), (200, 55405), (222, 42109), (222, 42110), (401, 33045), (401, 41579), (510, 40112), (510, 40113), (510, 41497), (510, 41498), (530, 41859), (530, 41860), (535, 41492), (535, 41493), (535, 41494), (50001, 64527), (50001, 92568)) AND ((R.REQUEST_CLASS_APPLICATION_ID IS NULL AND R.CONCURRENT_REQUEST_CLASS_ID IS NULL) OR (R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) NOT IN ((0, 4), (0, 5), (0, 6), (0, 7), (0, 8), (0, 9), (0, 24), (50001, 10)))) FOR UPDATE OF R.status_code NoWait
f3ww8rgva3hrs	update /* KSXM:FLUSH COL */ sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), flags = flags + :flag - bitand(flags, :flag), timestamp = :time where obj# = :objn and intcol# = :coln
fzgxy8kf6t5ys	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((50, 44069), (50, 46333), (200, 55405), (222, 42109), (222, 42110), (401, 33045), (401, 41579), (510, 40112), (510, 40113), (510, 41497), (510, 41498), (530, 41859), (530, 41860), (535, 41492), (535, 41493), (535, 41494), (50001, 64527), (50001, 92568)) AND ((R.REQUEST_CLASS_APPLICATION_ID IS NULL AND R.CONCURRENT_REQUEST_CLASS_ID IS NULL) OR (R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) NOT IN ((0, 4), (0, 5), (0, 6), (0, 7), (0, 8), (0, 9), (0, 24), (50001, 10)))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
g285rznuc9fw8	begin fndcp_tmsrv.monitor_self2 (:e, :a, :q, :c, :s, :d, :p); end;
gjaap3w3qbf8c	select count(*) from ilmobj$ where rownum = 1
gruuys9xr43k3	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) IN ((0, 8))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
grwydz59pu6mc	select text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Key Instance Activity Stats
• Instance Activity Stats
• Instance Activity Stats - Absolute Values

Key Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

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

IO Stats

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

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
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

Tablespace IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

File IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Segment Statistics

• Segments by Logical Reads
• Segments by Physical Reads
• Segments by Physical Read Requests
• Segments by UnOptimized Reads
• Segments by Optimized Reads
• Segments by Direct Physical Reads
• Segments by Physical Writes
• Segments by Physical Write Requests
• Segments by Direct Physical Writes
• Segments by Table Scans
• Segments by DB Blocks Changes
• Segments by Row Lock Waits
• Segments by ITL Waits
• Segments by Buffer Busy Waits
• Segments by Global Cache Buffer Busy
• Segments by CR Blocks Received
• Segments by Current Blocks Received
• Segments by Global Cache Remote Grants

Segments by Logical Reads

• Total Logical Reads: 123,334,095
• Captured Segments account for 103.0% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 1,696,048
• Captured Segments account for 133.7% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

• Total Physical Read Requests: 79,720
• Captured Segments account for 169.0% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

• Total UnOptimized Read Requests: 1
• Captured Segments account for 5.5E+05% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

• Total Optimized Read Requests: 84,219
• Captured Segments account for 153.4% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

• Total Direct Physical Reads: 1,623,472
• Captured Segments account for 114.5% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Writes

• Total Physical Writes: 1
• Captured Segments account for 4.1E+05% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

• Total Physical Write Requests: 1
• Captured Segments account for 1.6E+05% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

• Total Table Scans: 64
• Captured Segments account for 107.8% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

• % of Capture shows % of DB Block Changes for each top segment compared
• with total DB Block Changes for all segments captured by the Snapshot
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

• % of Capture shows % of row lock waits for each top segment compared
• with total row lock waits for all segments captured by the Snapshot
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

• % of Capture shows % of Buffer Busy Waits for each top segment compared
• with total Buffer Busy Waits for all segments captured by the Snapshot
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

• % of Capture shows % of GC Buffer Busy for each top segment compared
• with GC Buffer Busy for all segments captured by the Snapshot
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

• Total CR Blocks Received: 319,365
• Captured Segments account for 100.3% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available