WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
PRODB	215918786	PRODB	1	19-Mar-15 10:03	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
ebs02	Solaris[tm] OE (64-bit)	128	16	2	63.50

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	19219	24-Mar-15 00:00:37	125	19.2
End Snap:	19238	24-Mar-15 19:00:38	124	18.7
Elapsed:		1,140.01 (mins)
DB Time:		161.54 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	736M	736M	Std Block Size:	8K
Shared Pool Size:	1,200M	1,200M	Log Buffer:	21,904K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.1	0.1	0.01	0.01
DB CPU(s):	0.1	0.1	0.01	0.01
Redo size:	23,162.3	11,434.3
Logical reads:	721.4	356.1
Block changes:	173.6	85.7
Physical reads:	22.5	11.1
Physical writes:	4.1	2.0
User calls:	9.6	4.7
Parses:	0.8	0.4
Hard parses:	0.1	0.1
W/A MB processed:	0.1	0.1
Logons:	0.0	0.0
Executes:	20.6	10.2
Rollbacks:	1.2	0.6
Transactions:	2.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	97.45	In-memory Sort %:	100.00
Library Hit %:	98.87	Soft Parse %:	88.14
Execute to Parse %:	96.08	Latch Hit %:	99.66
Parse CPU to Parse Elapsd %:	94.90	% Non-Parse CPU:	94.47

Shared Pool Statistics

	Begin	End
Memory Usage %:	84.86	83.49
% SQL with executions>1:	95.58	95.59
% Memory for SQL w/exec>1:	95.93	92.74

Top 5 Timed Foreground Events

Host CPU (CPUs: 128 Cores: 16 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.41	1.59	0.3	0.7	0.0	99.0

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	65,024.0	65,024.0
SGA use (MB):	2,048.0	2,048.0
PGA use (MB):	562.6	554.9
% Host Mem used for SGA+PGA:	4.01	4.00

Main Report

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

Wait Events Statistics

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

Time Model Statistics

• Total time in database user-calls (DB Time): 9692.4s
• 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 97.0% of Total DB time 9,692.44 (s)
• Total FG Wait Time: 1,040.25 (s) DB CPU time: 8,360.79 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

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 43.0% of Total CPU Time (s): 8,361
• Captured PL/SQL account for 56.1% of Total CPU Time (s): 8,361

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

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: 49,341,404
• Captured SQL account for 85.5% 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,537,421
• Captured SQL account for 69.2% 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: 904,739
• Captured SQL account for 75.1% of Total
• Total UnOptimized Read Requests: 904,739
• Captured SQL account for 75.1% 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: 1,410,892
• Captured SQL account for 57.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 55,238
• Captured SQL account for 20.7% 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

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
01xv155rhts3j	SELECT COUNT(*) FROM SYS_UNCOMPRESSED_SEGS WHERE TOTAL_INDEXES >= 3 AND SEGSIZE > 10485760
073n31wnz5tg1	SELECT 'Y' FROM AR_CASH_RECEIPT_HISTORY_ALL CRH WHERE CRH.CASH_RECEIPT_ID = :B1 AND CRH.CURRENT_RECORD_FLAG = 'Y' AND CRH.STATUS = 'REVERSED'
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0p70vwm9n64uj	SELECT /* DS_SVC */ /*+ cursor_sharing_exact dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) */ SUM(C1) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "R") */ 1 AS C1 FROM "APPLSYS"."FND_CONCURRENT_REQUESTS" SAMPLE BLOCK(1.28281, 8) SEED(1) "R" WHERE ("R"."REQUESTED_BY"=:B1) AND ("R"."REQUEST_TYPE" IS NULL OR "R"."REQUEST_TYPE"='B' OR "R"."REQUEST_TYPE"='C')) innerQuery
0q8w0cndsp865	SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID
0wmwsjy9kd92f	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
14w75a0fugaan	begin CUX_GL_JE_IMP_PVT.validate_iface(x_return_status=>:return_status, x_msg_data=>:msg_data, p_commit=>:commit, p_interface_run_id=>:interface_run_id); end;
19w2h52d7ggr7	SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ( 'NLS_LANGUAGE', 'NLS_DATE_LANGUAGE', 'NLS_SORT', 'NLS_TERRITORY', 'NLS_DATE_FORMAT', 'NLS_NUMERIC_CHARACTERS', 'NLS_CHARACTERSET' )
1pynhc2r0qb3u	BEGIN CUX_unify_import_pvt.submit_main(:errbuf, :rc, :A0, :A1, :A2); END;
1ty222xdwtb3k	SELECT b.je_batch_id, h.je_header_id, b.name batch_name, b.approval_status_code, b.control_total, b.running_total_dr, b.running_total_cr, h.je_header_id, h.name je_name, h.currency_code, (SELECT SUM(l.entered_dr) FROM gl_je_lines l WHERE l.je_header_id = h.je_header_id) entered_dr, (SELECT SUM(l.entered_cr) FROM gl_je_lines l WHERE l.je_header_id = h.je_header_id) entered_cr, cu.full_name created_name, pe.full_name approved_name FROM hr_employees pe, cux_user_employees_v cu, gl_je_categories c, gl_je_sources s, gl_je_batches b, gl_je_headers h WHERE pe.employee_id(+) = b.approver_employee_id AND cu.user_id(+) = b.created_by AND b.je_batch_id(+) = h.je_batch_id AND h.je_source = s.je_source_name AND h.je_category = c.je_category_name AND b.status <> 'P' --未过账 AND h.ledger_id =2022 --分类账名称 --AND s.je_source_name = nvl(p_je_source_name, s.je_source_name) --日记账来源 -- AND h.je_category = nvl(p_je_category, h.je_category) --日记账类别 AND h.default_effective_date >= to_date('2015-2-1', 'yyyy-mm-dd') --起始GL日期 AND h.default_effective_date <= to_date('2015-2-28', 'yyyy-mm-dd') --截止GL日期 AND b.name >= nvl('114 2022_CNY_21-03-15_00 收款池 A 36817 1676969', b.name) --起始批名 /* AND b.name <= nvl(p_to_batch_name, b.name) --截止批名 AND b.created_by = nvl(p_created_by, b.created_by) --创建人 AND ((p_approver_employee_id IS NOT NULL AND b.approver_employee_id = b.approver_employee_id) OR p_approver_employee_id IS NULL)*/ AND ('Y' = 'Y' OR ('N' = 'N' AND EXISTS (SELECT 1 FROM gl_code_combinations gcc, gl_je_lines l, cux_access_ledger_segment_v sv WHERE gcc.code_combination_id = l.code_combination_id AND l.je_header_id = h.je_header_id AND gcc.segment1 = sv.segment_value AND sv.access_set_id = 1005 AND sv.ledger_id = 2022))) --数据权限集对segment1的限制 AND EXISTS (SELECT 1 FROM gl_code_combinations gcc, gl_je_lines l WHERE gcc.code_combination_id = l.code_combination_id AND l.je_header_id = h.je_header_id AND gcc.segment1 >= nvl('', gcc.segment1) AND gcc.segment1 <= nvl('', gcc.segment1) AND gcc.segment2 >= nvl('14', gcc.segment2) AND gcc.segment2 >= nvl('14', gcc.segment2)) AND EXISTS (SELECT 'Y' FROM fnd_flex_value_rule_lines l, fnd_flex_value_rules_vl r, fnd_flex_value_rule_usages u, gl_code_combinations gcc, gl_je_lines jl WHERE gcc.code_combination_id = jl.code_combination_id AND jl.je_header_id = h.je_header_id AND l.flex_value_rule_id = r.flex_value_rule_id AND r.flex_value_rule_id = u.flex_value_rule_id AND u.responsibility_id = 51834 AND u.flex_value_set_id = 1014862 --值集：'SOHU_GL_BU' AND ((l.include_exclude_indicator = 'I' AND gcc.segment2 >= l.flex_value_low AND gcc.segment2 <= l.flex_value_high) OR (l.include_exclude_indicator = 'E' AND gcc.segment2 <= l.flex_value_low AND gcc.segment2 >= l.flex_value_high))) --安全性对板块段segment2的限制 ORDER BY b.name, h.name
298dybjj1k8b7	SELECT B.JE_BATCH_ID, B.NAME BATCH_NAME, B.APPROVAL_STATUS_CODE, B.CONTROL_TOTAL, B.RUNNING_TOTAL_DR, B.RUNNING_TOTAL_CR, H.JE_HEADER_ID, H.NAME JE_NAME, H.CURRENCY_CODE, (SELECT SUM(L.ENTERED_DR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_DR, (SELECT SUM(L.ENTERED_CR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_CR, CU.FULL_NAME CREATED_NAME, PE.FULL_NAME APPROVED_NAME FROM HR_EMPLOYEES PE, CUX_USER_EMPLOYEES_V CU, GL_JE_CATEGORIES C, GL_JE_SOURCES S, GL_JE_BATCHES B, GL_JE_HEADERS H WHERE PE.EMPLOYEE_ID(+) = B.APPROVER_EMPLOYEE_ID AND CU.USER_ID(+) = B.CREATED_BY AND B.JE_BATCH_ID(+) = H.JE_BATCH_ID AND H.JE_SOURCE = S.JE_SOURCE_NAME AND H.JE_CATEGORY = C.JE_CATEGORY_NAME AND B.STATUS <> 'P' AND H.LEDGER_ID = :B10 AND S.JE_SOURCE_NAME = NVL(:B9 , S.JE_SOURCE_NAME) AND H.JE_CATEGORY = NVL(:B8 , H.JE_CATEGORY) AND H.DEFAULT_EFFECTIVE_DATE >= :B7 AND H.DEFAULT_EFFECTIVE_DATE <= :B6 AND B.NAME >= NVL(:B5 , B.NAME) AND B.NAME <= NVL(:B4 , B.NAME) AND B.CREATED_BY = NVL(:B3 , B.CREATED_BY) AND ((:B2 IS NOT NULL AND B.APPROVER_EMPLOYEE_ID = B.APPROVER_EMPLOYEE_ID) OR :B2 IS NULL) AND (:B1 = 'Y' OR (:B1 = 'N' AND EXISTS (SELECT 1 FROM GL_CODE_COMBINATIONS GCC, GL_JE_LINES L, CUX_ACCESS_LEDGER_SEGMENT_V SV WHERE GCC.CODE_COMBINATION_ID = L.CODE_COMBINATION_ID AND L.JE_HEADER_ID = H.JE_HEADER_ID AND GCC.SEGMENT1 >= NVL(:B15 , GCC.SEGMENT1) AND GCC.SEGMENT1 <= NVL(:B14 , GCC.SEGMENT1) AND GCC.SEGMENT2 >= NVL(:B13 , GCC.SEGMENT2) AND GCC.SEGMENT2 >= NVL(:B12 , GCC.SEGMENT2) AND GCC.SEGMENT1 = SV.SEGMENT_VALUE AND SV.ACCESS_SET_ID = :B11 AND SV.LEDGER_ID = :B10 ))) AND EXISTS (SELECT 'Y' FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES_VL R, FND_FLEX_VALUE_RULE_USAGES U, GL_CODE_COMBINATIONS GCC, GL_JE_LINES JL WHERE GCC.CODE_COMBINATION_ID = JL.CODE_COMBINATION_ID AND JL.JE_HEADER_ID = H.JE_HEADER_ID AND L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND R.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID AND U.RESPONSIBILITY_ID = :B16 AND U.FLEX_VALUE_SET_ID = 1014862 AND ((L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND GCC.SEGMENT2 >= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 <= L.FLEX_VALUE_HIGH) OR (L.INCLUDE_EXCLUDE_INDICATOR = 'E' AND GCC.SEGMENT2 <= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 >= L.FLEX_VALUE_HIGH))) ORDER BY B.NAME, H.NAME
2sjraytcfcv2n	SELECT /*+ USE_NL (A B I) */ DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME, B.APPLICATION_SHORT_NAME, B.BASEPATH, I.PRODUCT_VERSION FROM FND_APPLICATION_TL A, FND_APPLICATION B, FND_PRODUCT_INSTALLATIONS I WHERE A.APPLICATION_ID = I.APPLICATION_ID (+) AND A.APPLICATION_ID = B.APPLICATION_ID AND A.LANGUAGE = USERENV ('LANG')
3ayt0w7yfzj64	SELECT B.JE_BATCH_ID, B.NAME BATCH_NAME, B.APPROVAL_STATUS_CODE, B.CONTROL_TOTAL, B.RUNNING_TOTAL_DR, B.RUNNING_TOTAL_CR, H.JE_HEADER_ID, H.NAME JE_NAME, H.CURRENCY_CODE, (SELECT SUM(L.ENTERED_DR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_DR, (SELECT SUM(L.ENTERED_CR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_CR, CU.FULL_NAME CREATED_NAME, PE.FULL_NAME APPROVED_NAME FROM HR_EMPLOYEES PE, CUX_USER_EMPLOYEES_V CU, GL_JE_CATEGORIES C, GL_JE_SOURCES S, GL_JE_BATCHES B, GL_JE_HEADERS H WHERE PE.EMPLOYEE_ID(+) = B.APPROVER_EMPLOYEE_ID AND CU.USER_ID(+) = B.CREATED_BY AND B.JE_BATCH_ID(+) = H.JE_BATCH_ID AND H.JE_SOURCE = S.JE_SOURCE_NAME AND H.JE_CATEGORY = C.JE_CATEGORY_NAME AND B.STATUS <> 'P' AND H.LEDGER_ID = :B10 AND S.JE_SOURCE_NAME = NVL(:B9 , S.JE_SOURCE_NAME) AND H.JE_CATEGORY = NVL(:B8 , H.JE_CATEGORY) AND H.DEFAULT_EFFECTIVE_DATE >= :B7 AND H.DEFAULT_EFFECTIVE_DATE <= :B6 AND B.NAME >= NVL(:B5 , B.NAME) AND B.NAME <= NVL(:B4 , B.NAME) AND B.CREATED_BY = NVL(:B3 , B.CREATED_BY) AND ((:B2 IS NOT NULL AND B.APPROVER_EMPLOYEE_ID = B.APPROVER_EMPLOYEE_ID) OR :B2 IS NULL) AND EXISTS (SELECT 1 FROM GL_CODE_COMBINATIONS GCC1, GL_JE_LINES L1 WHERE GCC1.CODE_COMBINATION_ID = L1.CODE_COMBINATION_ID AND L1.JE_HEADER_ID = H.JE_HEADER_ID AND GCC1.SEGMENT1 >= NVL(:B14 , GCC1.SEGMENT1) AND GCC1.SEGMENT1 <= NVL(:B13 , GCC1.SEGMENT1) AND GCC1.SEGMENT2 >= NVL(:B12 , GCC1.SEGMENT2) AND GCC1.SEGMENT2 <= NVL(:B11 , GCC1.SEGMENT2)) AND (:B1 = 'Y' OR (:B1 = 'N' AND EXISTS (SELECT 1 FROM GL_CODE_COMBINATIONS GCC, GL_JE_LINES L, CUX_ACCESS_LEDGER_SEGMENT_V SV WHERE GCC.CODE_COMBINATION_ID = L.CODE_COMBINATION_ID AND L.JE_HEADER_ID = H.JE_HEADER_ID AND GCC.SEGMENT1 = SV.SEGMENT_VALUE AND SV.ACCESS_SET_ID = :B15 AND SV.LEDGER_ID = :B10 ))) AND EXISTS (SELECT 'Y' FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES_VL R, FND_FLEX_VALUE_RULE_USAGES U, GL_CODE_COMBINATIONS GCC, GL_JE_LINES JL WHERE GCC.CODE_COMBINATION_ID = JL.CODE_COMBINATION_ID AND JL.JE_HEADER_ID = H.JE_HEADER_ID AND L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND R.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID AND U.RESPONSIBILITY_ID = :B16 AND U.FLEX_VALUE_SET_ID = 1014862 AND ((L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND GCC.SEGMENT2 >= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 <= L.FLEX_VALUE_HIGH) OR (L.INCLUDE_EXCLUDE_INDICATOR = 'E' AND GCC.SEGMENT2 <= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 >= L.FLEX_VALUE_HIGH))) ORDER BY B.NAME, H.NAME
3ppkc2qq9ks8d	select nvl(s.bytes, 0) from dba_segments s where s.owner=:1 and s.segment_name=:2
3sc6gm8r4cxjb	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 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 ((510, 40112), (510, 40113), (510, 41497), (510, 41498), (530, 41859), (530, 41860), (535, 41492), (535, 41493), (535, 41494)))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
3vgmza8dk1qjf	SELECT SUM(RA.APPLY_AMOUNT) FROM CUX_AR_RM_APP_LINES_ALL RA WHERE CUX_AR_RM_APPLY_PVT.CHECK_RECEIPT_REVERSED(RA.CASH_RECEIPT_ID) = 'N' AND RA.STATUS != CUX_AR_RM_COMMON_UTIL.G_REC_STS_CANCELLED AND RA.RM_LINE_ID = :B1
4sbp5w6qdgscf	SELECT GCC.SEGMENT4 FROM GL_CODE_COMBINATIONS_KFV GCC WHERE GCC.CONCATENATED_SEGMENTS = :B1
4stj00z64qshd	SELECT B.JE_BATCH_ID, B.NAME BATCH_NAME, B.APPROVAL_STATUS_CODE, B.CONTROL_TOTAL, B.RUNNING_TOTAL_DR, B.RUNNING_TOTAL_CR, H.JE_HEADER_ID, H.NAME JE_NAME, H.CURRENCY_CODE, (SELECT SUM(L.ENTERED_DR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_DR, (SELECT SUM(L.ENTERED_CR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_CR, CU.FULL_NAME CREATED_NAME, PE.FULL_NAME APPROVED_NAME FROM HR_EMPLOYEES PE, CUX_USER_EMPLOYEES_V CU, GL_JE_CATEGORIES C, GL_JE_SOURCES S, GL_JE_BATCHES B, GL_JE_HEADERS H WHERE PE.EMPLOYEE_ID(+) = B.APPROVER_EMPLOYEE_ID AND CU.USER_ID(+) = B.CREATED_BY AND B.JE_BATCH_ID(+) = H.JE_BATCH_ID AND H.JE_SOURCE = S.JE_SOURCE_NAME AND H.JE_CATEGORY = C.JE_CATEGORY_NAME AND B.STATUS <> 'P' AND H.LEDGER_ID = :B10 AND S.JE_SOURCE_NAME = NVL(:B9 , S.JE_SOURCE_NAME) AND H.JE_CATEGORY = NVL(:B8 , H.JE_CATEGORY) AND H.DEFAULT_EFFECTIVE_DATE >= :B7 AND H.DEFAULT_EFFECTIVE_DATE <= :B6 AND B.NAME >= NVL(:B5 , B.NAME) AND B.NAME <= NVL(:B4 , B.NAME) AND B.CREATED_BY = NVL(:B3 , B.CREATED_BY) AND ((:B2 IS NOT NULL AND B.APPROVER_EMPLOYEE_ID = B.APPROVER_EMPLOYEE_ID) OR :B2 IS NULL) AND EXISTS (SELECT 1 FROM GL_CODE_COMBINATIONS GCC1, GL_JE_LINES L1 WHERE GCC1.CODE_COMBINATION_ID = L1.CODE_COMBINATION_ID AND L1.JE_HEADER_ID = H.JE_HEADER_ID AND GCC1.SEGMENT1 >= NVL(:B14 , GCC1.SEGMENT1) AND GCC1.SEGMENT1 <= NVL(:B13 , GCC1.SEGMENT1) AND GCC1.SEGMENT2 >= NVL(:B12 , GCC1.SEGMENT2) AND GCC1.SEGMENT2 >= NVL(:B11 , GCC1.SEGMENT2)) AND (:B1 = 'Y' OR (:B1 = 'N' AND EXISTS (SELECT 1 FROM GL_CODE_COMBINATIONS GCC, GL_JE_LINES L, CUX_ACCESS_LEDGER_SEGMENT_V SV WHERE GCC.CODE_COMBINATION_ID = L.CODE_COMBINATION_ID AND L.JE_HEADER_ID = H.JE_HEADER_ID AND GCC.SEGMENT1 = SV.SEGMENT_VALUE AND SV.ACCESS_SET_ID = :B15 AND SV.LEDGER_ID = :B10 ))) AND EXISTS (SELECT 'Y' FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES_VL R, FND_FLEX_VALUE_RULE_USAGES U, GL_CODE_COMBINATIONS GCC, GL_JE_LINES JL WHERE GCC.CODE_COMBINATION_ID = JL.CODE_COMBINATION_ID AND JL.JE_HEADER_ID = H.JE_HEADER_ID AND L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND R.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID AND U.RESPONSIBILITY_ID = :B16 AND U.FLEX_VALUE_SET_ID = 1014862 AND ((L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND GCC.SEGMENT2 >= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 <= L.FLEX_VALUE_HIGH) OR (L.INCLUDE_EXCLUDE_INDICATOR = 'E' AND GCC.SEGMENT2 <= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 >= L.FLEX_VALUE_HIGH))) ORDER BY B.NAME, H.NAME
4xd696x7z8dm1	lock TABLE FND_CONCURRENT_QUEUES IN SHARE UPDATE MODE
55dc767ajydh3	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
55y2ztzqcgqd0	/* SQL Analyze(1358, 1) */ select request_id, decode (r.description, null, pt.user_concurrent_program_name, r.description||'('||pt.user_concurrent_program_name||')'), argument_text, request_date from fnd_concurrent_requests r, fnd_concurrent_programs p, fnd_concurrent_programs_tl pt where p.concurrent_program_id = r.concurrent_program_id and p.application_id = r.program_application_id and p.srs_flag in ('Y', 'Q') and p.enabled_flag = 'Y' and pt.concurrent_program_id = r.concurrent_program_id and pt.application_id = r.program_application_id and pt.language = userenv('LANG') and requested_by = :1 and (request_type is null or request_type='B' or request_type='C') and (p.application_id in (select u.unit_application_id from fnd_request_group_units u where u.application_id = :2 and u.request_group_id = :3 and u.request_unit_type = 'A') or (p.application_id, p.concurrent_program_id) in (select u.unit_application_id, u.request_unit_id from fnd_request_group_units u where u.application_id = :4 and u.request_group_id = :5 and u.request_unit_type = 'P'))order by request_id desc
5zruc4v6y32f9	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6842742n5dmp6	SELECT DECODE(:B4 , 0, FLV.MEANING, FLV.DESCRIPTION) FROM FND_LOOKUP_VALUES_VL FLV WHERE (FLV.VIEW_APPLICATION_ID = :B3 OR :B3 IS NULL) AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE, FLV.VIEW_APPLICATION_ID) AND FLV.LOOKUP_TYPE = :B2 AND FLV.LOOKUP_CODE = :B1
6hg8vugcxxcva	SELECT COUNT(*) FROM WF_ITEMS WI WHERE WI.ITEM_TYPE = :B1 AND WI.END_DATE <= SYSDATE AND EXISTS (SELECT NULL FROM WF_ITEM_TYPES WIT WHERE WI.END_DATE+NVL(WIT.PERSISTENCE_DAYS, 0)<=SYSDATE AND WI.ITEM_TYPE = WIT.NAME ) AND NOT EXISTS (SELECT NULL FROM WF_ITEMS WI2 WHERE WI2.END_DATE IS NULL START WITH WI2.ITEM_TYPE = WI.ITEM_TYPE AND WI2.ITEM_KEY = WI.ITEM_KEY CONNECT BY PRIOR WI2.ITEM_TYPE = WI2.PARENT_ITEM_TYPE AND PRIOR WI2.ITEM_KEY = WI2.PARENT_ITEM_KEY UNION ALL SELECT NULL FROM WF_ITEMS WI2 WHERE WI2.END_DATE IS NULL START WITH WI2.ITEM_TYPE = WI.ITEM_TYPE AND WI2.ITEM_KEY = WI.ITEM_KEY CONNECT BY PRIOR WI2.PARENT_ITEM_TYPE = WI2.ITEM_TYPE AND PRIOR WI2.PARENT_ITEM_KEY = WI2.ITEM_KEY)
6mcpb06rctk0x	call dbms_space.auto_space_advisor_job_proc ( )
7jbtgth3qch3c	select distinct name from gl_je_headers where ( UPPER(NAME) LIKE :1 AND (NAME LIKE :2)) AND ( ( (actual_flag = :3) or (:4 = 'Q') or ( (:5 = 'A') and (actual_flag = 'B'))) and (display_alc_journal_flag <> 'N' or display_alc_journal_flag is null) ) order by name
7qs7fx89194u1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
7yqcrnkxhx4p8	BEGIN WF_OAM_METRICS.workItemsStatConcurrent(:errbuf, :rc); END;
8szmwam7fysa3	insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
8untjv9m3brr3	SELECT U.SPACE_USED, U.SPACE_ALLOCATED FROM TABLE(DBMS_SPACE.OBJECT_SPACE_USAGE_TBF( :B1 , :B2 , :B3 , 0, :B4 , 'TRUE', 1)) U
8w57t3xaxs89k	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS
91k4w10zgrg4m	select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
9n126p922amjm	SELECT /*+ PARALLEL(wf_item_activity_statuses) */ ITEM_TYPE, COUNT(DISTINCT(ITEM_KEY)) CNT FROM WF_ITEM_ACTIVITY_STATUSES WHERE ACTIVITY_STATUS IN ('ACTIVE', 'NOTIFIED', 'WAITING') GROUP BY ITEM_TYPE ORDER BY ITEM_TYPE
9qfxu16nhz5cz	BEGIN cux_ps_sg_sal_journal_imp_pkg.main(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6); END;
9v9n97qj8z1dg	delete /*+ dynamic_sampling(4) */ from sys.wri$_optstat_histhead_history where savtime < :1 and rownum <= NVL(:2, rownum)
a49xsqhv0h31b	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, 0) 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.OPS_INSTANCE is null) or (R.OPS_INSTANCE = -1) or (R.OPS_INSTANCE = decode(:dcp_on, 1, FND_CONC_GLOBAL.OPS_INST_NUM, R.OPS_INSTANCE))) 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.Ho ld_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 ((510, 40112), (510, 40113), (510, 41497), (510, 41498), (530, 41859), (530, 41860), (535, 41492), (535, 41493), (535, 41494)))) FOR UPDATE OF R.status_code NoWait
a4v5gubsxy067	BEGIN cux_gl_batch_post_pkg.main(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13); END;
a6zz9jdpts66p	SELECT R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.SECURITY_GROUP_ID, R.RESPONSIBILITY_NAME, S.SECURITY_GROUP_NAME FROM FND_RESPONSIBILITY_VL R, FND_USER_RESP_GROUPS U, FND_SECURITY_GROUPS_VL S WHERE U.USER_ID = :A00 AND SYSDATE BETWEEN U.START_DATE AND NVL(U.END_DATE, SYSDATE) AND R.VERSION IN ('4', 'W') AND R.APPLICATION_ID = U.RESPONSIBILITY_APPLICATION_ID AND R.RESPONSIBILITY_ID = U.RESPONSIBILITY_ID AND SYSDATE BETWEEN R.START_DATE AND NVL(R.END_DATE, SYSDATE) AND U.SECURITY_GROUP_ID = S.SECURITY_GROUP_ID AND S.SECURITY_GROUP_ID >= 0 AND S.SECURITY_GROUP_KEY = NVL(:A01, S.SECURITY_GROUP_KEY) AND R.RESPONSIBILITY_KEY = NVL(:A02, R.RESPONSIBILITY_KEY) AND R.APPLICATION_ID = NVL(:A03, R.APPLICATION_ID) AND NVL(FND_PROFILE.VALUE('NODE_TRUST_LEVEL'), 1) <= NVL(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL', U.USER_ID, R.RESPONSIBILITY_ID, R.APPLICATION_ID), 1) ORDER BY RESPONSIBILITY_NAME, SECURITY_GROUP_NAME
a7z22y3zmhtqs	select from_tz( cast ((max(analyzetime) - 1) as timestamp), to_char(systimestamp, 'TZH:TZM')) from sys.tab$ where analyzetime is not null
a8755j5yrfjq6	SELECT b.je_batch_id, b.name batch_name, b.approval_status_code, b.control_total, b.running_total_dr, b.running_total_cr, h.je_header_id, h.name je_name, h.currency_code, (SELECT SUM(l.entered_dr) FROM gl_je_lines l WHERE l.je_header_id = h.je_header_id) entered_dr, (SELECT SUM(l.entered_cr) FROM gl_je_lines l WHERE l.je_header_id = h.je_header_id) entered_cr, cu.full_name created_name, pe.full_name approved_name FROM hr_employees pe, cux_user_employees_v cu, gl_je_categories c, gl_je_sources s, gl_je_batches b, gl_je_headers h WHERE pe.employee_id(+) = b.approver_employee_id AND cu.user_id(+) = b.created_by AND b.je_batch_id(+) = h.je_batch_id AND h.je_source = s.je_source_name AND h.je_category = c.je_category_name AND b.status <> 'P' --未过账 AND h.ledger_id =2022 --分类账名称 --AND s.je_source_name = nvl(p_je_source_name, s.je_source_name) --日记账来源 -- AND h.je_category = nvl(p_je_category, h.je_category) --日记账类别 AND h.default_effective_date >= to_date('2015-2-1', 'yyyy-mm-dd') --起始GL日期 AND h.default_effective_date <= to_date('2015-2-28', 'yyyy-mm-dd') --截止GL日期 AND b.name >= nvl('114 2022_CNY_21-03-15_00 收款池 A 36817 1676969', b.name) --起始批名 /* AND b.name <= nvl(p_to_batch_name, b.name) --截止批名 AND b.created_by = nvl(p_created_by, b.created_by) --创建人 AND ((p_approver_employee_id IS NOT NULL AND b.approver_employee_id = b.approver_employee_id) OR p_approver_employee_id IS NULL)*/ AND ('Y' = 'Y' OR ('N' = 'N' AND EXISTS (SELECT 1 FROM gl_code_combinations gcc, gl_je_lines l, cux_access_ledger_segment_v sv WHERE gcc.code_combination_id = l.code_combination_id AND l.je_header_id = h.je_header_id AND gcc.segment1 = sv.segment_value AND sv.access_set_id = 1005 AND sv.ledger_id = 2022))) --数据权限集对segment1的限制 AND EXISTS (SELECT 1 FROM gl_code_combinations gcc, gl_je_lines l WHERE gcc.code_combination_id = l.code_combination_id AND l.je_header_id = h.je_header_id AND gcc.segment1 >= nvl('', gcc.segment1) AND gcc.segment1 <= nvl('', gcc.segment1) AND gcc.segment2 >= nvl('14', gcc.segment2) AND gcc.segment2 >= nvl('14', gcc.segment2)) AND EXISTS (SELECT 'Y' FROM fnd_flex_value_rule_lines l, fnd_flex_value_rules_vl r, fnd_flex_value_rule_usages u, gl_code_combinations gcc, gl_je_lines jl WHERE gcc.code_combination_id = jl.code_combination_id AND jl.je_header_id = h.je_header_id AND l.flex_value_rule_id = r.flex_value_rule_id AND r.flex_value_rule_id = u.flex_value_rule_id AND u.responsibility_id = 51834 AND u.flex_value_set_id = 1014862 --值集：'SOHU_GL_BU' AND ((l.include_exclude_indicator = 'I' AND gcc.segment2 >= l.flex_value_low AND gcc.segment2 <= l.flex_value_high) OR (l.include_exclude_indicator = 'E' AND gcc.segment2 <= l.flex_value_low AND gcc.segment2 >= l.flex_value_high))) --安全性对板块段segment2的限制 ORDER BY b.name, h.name
a90wnvray15z2	LOCK TABLE FND_CONCURRENT_QUEUES IN EXCLUSIVE MODE NOWAIT
bazquck2vuvm1	SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT_GROUP_ID
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from 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')
bs15p0trrn9th	SELECT MAX(REQUEST_ID) FROM FND_CONCURRENT_REQUESTS WHERE PROGRAM_APPLICATION_ID = :B2 AND CONCURRENT_PROGRAM_ID = :B1
c2p32r5mzv8hb	BEGIN prvt_advisor.delete_expired_tasks; END;
c8khjbn635s3c	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) 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')
ca847z8stwvzh	/* SQL Analyze(1358, 1) */ SELECT B.JE_BATCH_ID, B.NAME BATCH_NAME, B.APPROVAL_STATUS_CODE, B.CONTROL_TOTAL, B.RUNNING_TOTAL_DR, B.RUNNING_TOTAL_CR, H.JE_HEADER_ID, H.NAME JE_NAME, H.CURRENCY_CODE, (SELECT SUM(L.ENTERED_DR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_DR, (SELECT SUM(L.ENTERED_CR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_CR, CU.FULL_NAME CREATED_NAME, PE.FULL_NAME APPROVED_NAME FROM HR_EMPLOYEES PE, CUX_USER_EMPLOYEES_V CU, GL_JE_CATEGORIES C, GL_JE_SOURCES S, GL_JE_BATCHES B, GL_JE_HEADERS H WHERE PE.EMPLOYEE_ID(+) = B.APPROVER_EMPLOYEE_ID AND CU.USER_ID(+) = B.CREATED_BY AND B.JE_BATCH_ID(+) = H.JE_BATCH_ID AND H.JE_SOURCE = S.JE_SOURCE_NAME AND H.JE_CATEGORY = C.JE_CATEGORY_NAME AND B.STATUS <> 'P' AND H.LEDGER_ID = :B10 AND S.JE_SOURCE_NAME = NVL(:B9 , S.JE_SOURCE_NAME) AND H.JE_CATEGORY = NVL(:B8 , H.JE_CATEGORY) AND H.DEFAULT_EFFECTIVE_DATE >= :B7 AND H.DEFAULT_EFFECTIVE_DATE <= :B6 AND B.NAME >= NVL(:B5 , B.NAME) AND B.NAME <= NVL(:B4 , B.NAME) AND B.CREATED_BY = NVL(:B3 , B.CREATED_BY) AND ((:B2 IS NOT NULL AND B.APPROVER_EMPLOYEE_ID = B.APPROVER_EMPLOYEE_ID) OR :B2 IS NULL) AND (:B1 = 'Y' OR (:B1 = 'N' AND EXISTS (SELECT 1 FROM GL_CODE_COMBINATIONS GCC, GL_JE_LINES L, CUX_ACCESS_LEDGER_SEGMENT_V SV WHERE GCC.CODE_COMBINATION_ID = L.CODE_COMBINATION_ID AND L.JE_HEADER_ID = H.JE_HEADER_ID AND GCC.SEGMENT1 >= NVL(:B15 , GCC.SEGMENT1) AND GCC.SEGMENT1 <= NVL(:B14 , GCC.SEGMENT1) AND GCC.SEGMENT2 >= NVL(:B13 , GCC.SEGMENT2) AND GCC.SEGMENT2 >= NVL(:B12 , GCC.SEGMENT2) AND GCC.SEGMENT1 = SV.SEGMENT_VALUE AND SV.ACCESS_SET_ID = :B11 AND SV.LEDGER_ID = :B10 ))) AND EXISTS (SELECT 'Y' FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES_VL R, FND_FLEX_VALUE_RULE_USAGES U, GL_CODE_COMBINATIONS GCC, GL_JE_LINES JL WHERE GCC.CODE_COMBINATION_ID = JL.CODE_COMBINATION_ID AND JL.JE_HEADER_ID = H.JE_HEADER_ID AND L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND R.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID AND U.RESPONSIBILITY_ID = :B16 AND U.FLEX_VALUE_SET_ID = 1014862 AND ((L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND GCC.SEGMENT2 >= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 <= L.FLEX_VALUE_HIGH) OR (L.INCLUDE_EXCLUDE_INDICATOR = 'E' AND GCC.SEGMENT2 <= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 >= L.FLEX_VALUE_HIGH))) ORDER BY B.NAME, H.NAME
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cqh9su5zqj993	SELECT SUM(RA.AMOUNT) FROM CUX_AR_RM_RECEIPTS_ALL RA WHERE CUX_AR_RM_APPLY_PVT.CHECK_RECEIPT_REVERSED(RA.CASH_RECEIPT_ID) = 'N' AND RA.STATUS != CUX_AR_RM_COMMON_UTIL.G_REC_STS_CANCELLED AND RA.RM_LINE_ID = :B1
dshsnydzxf4n9	SELECT CHECK_FLAG, REC_TYPE_DESC, BATCH_NAME, LINE_NUMBER, STATUS_DESC, RECEIPT_DATE, BANK_ACCOUNT_NUM, BANK_ACCOUNT_NAME, INTERNAL_BANK_ACCOUNT, CUSTOMER_PAYMENT_METHOD, BANK_ACCOUNT_ADDRESS, PAY_FROM_CUSTOMER, CUSTOMER_NAME, CUSTOMER_NUMBER, CUST_TYPE_DESC, BANK_LINE_NUMBER, CURRENCY_CODE, RECEIPT_AMOUNT, RECEIPT_REMAIN_AMOUNT, APPLIED_AMOUNT, EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE, EXCHANGE_RATE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE15, STATUS, CUSTOMER_TYPE, SOURCE_CODE, LEDGER_ID, LINE_ID, BATCH_ID, RECEIPT_TYPE, BANK_ACCOUNT_ID, CUSTOMER_ID, ROW_ID, OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14 FROM CUX_AR_RM_LINES_V order by batch_name, line_number
fqmpmkfr6pqyk	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) 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')
fvbr4jfwy25sy	select request_id, decode (r.description, null, pt.user_concurrent_program_name, r.description||'('||pt.user_concurrent_program_name||')'), argument_text, request_date from fnd_concurrent_requests r, fnd_concurrent_programs p, fnd_concurrent_programs_tl pt where p.concurrent_program_id = r.concurrent_program_id and p.application_id = r.program_application_id and p.srs_flag in ('Y', 'Q') and p.enabled_flag = 'Y' and pt.concurrent_program_id = r.concurrent_program_id and pt.application_id = r.program_application_id and pt.language = userenv('LANG') and requested_by = :1 and (request_type is null or request_type='B' or request_type='C') and (p.application_id in (select u.unit_application_id from fnd_request_group_units u where u.application_id = :2 and u.request_group_id = :3 and u.request_unit_type = 'A') or (p.application_id, p.concurrent_program_id) in (select u.unit_application_id, u.request_unit_id from fnd_request_group_units u where u.application_id = :4 and u.request_group_id = :5 and u.request_unit_type = 'P'))order by request_id desc
g0h8ufvuqk7kq	SELECT COUNT(ITEM_KEY) FROM (SELECT /*+ PARALLEL(wf_item_activity_statuses) */ DISTINCT ITEM_TYPE, ITEM_KEY FROM WF_ITEM_ACTIVITY_STATUSES WHERE ACTIVITY_STATUS IN ('ACTIVE', 'NOTIFIED', 'WAITING'))
g8bgja5vc9mhz	begin fnd_oam_collection.submit_col_req_conditional; end;
gxb6hqhd607xw	SELECT /* DS_SVC */ /*+ cursor_sharing_exact dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) OPT_ESTIMATE(@"innerQuery", INDEX_SCAN, "H", "CUX_GL_JE_HEADERS_N1", SCALE_ROWS=7.568858567) OPT_ESTIMATE(@"innerQuery", TABLE, "H", SCALE_ROWS=72.66654015) */ C1, C2, C3 FROM (SELECT /*+ qb_name("innerQuery") INDEX( "H" "CUX_GL_JE_HEADERS_N2") */ COUNT(*) AS C1, 4294967295 AS C2, SUM(CASE WHEN ("H"."JE_CATEGORY"=NVL(:B1, "H"."JE_CATEGORY")) THEN 1 ELSE 0 END) AS C3 FROM "GL"."GL_JE_HEADERS" "H" WHERE ("H"."LEDGER_ID"=:B2) AND ("H"."LEDGER_ID"=:B3)) innerQuery

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Back to Instance Activity Statistics
Back to Top

IO Stats

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

IOStat by Function summary

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

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File