WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
TEST	215918786	TEST	1	30-Jan-15 12:01	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:	18741	02-Mar-15 13:00:19	125	19.1
End Snap:	18742	02-Mar-15 14:00:23	125	19.1
Elapsed:		60.07 (mins)
DB Time:		3.51 (mins)

Report Summary

Cache Sizes

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

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.1	0.0	0.00	0.01
DB CPU(s):	0.0	0.0	0.00	0.00
Redo size:	2,188.3	1,530.0
Logical reads:	1,740.5	1,216.9
Block changes:	14.3	10.0
Physical reads:	5.4	3.7
Physical writes:	0.4	0.3
User calls:	8.4	5.9
Parses:	0.5	0.4
Hard parses:	0.0	0.0
W/A MB processed:	0.0	0.0
Logons:	0.0	0.0
Executes:	259.8	181.6
Rollbacks:	1.2	0.8
Transactions:	1.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.69	In-memory Sort %:	100.00
Library Hit %:	99.65	Soft Parse %:	99.58
Execute to Parse %:	99.80	Latch Hit %:	99.83
Parse CPU to Parse Elapsd %:	89.47	% Non-Parse CPU:	99.77

Shared Pool Statistics

	Begin	End
Memory Usage %:	90.82	90.83
% SQL with executions>1:	96.72	96.55
% Memory for SQL w/exec>1:	96.04	95.37

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.18	2.18	1.7	0.2	0.0	98.1

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.0	2.2	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):	599.4	601.1
% Host Mem used for SGA+PGA:	4.07	4.07

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): 210.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 101.5% of Total DB time 210.37 (s)
• Total FG Wait Time: 68.43 (s) DB CPU time: 145.18 (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 109.9% of Total DB Time (s): 210
• Captured PL/SQL account for 3.1% of Total DB Time (s): 210

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

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

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: 6,273,256
• Captured SQL account for 145.4% 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: 19,286
• Captured SQL account for 96.3% 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: 17,424
• Captured SQL account for 5.4% of Total
• Total UnOptimized Read Requests: 17,424
• Captured SQL account for 5.4% 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: 936,362
• Captured SQL account for 97.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 1,916
• Captured SQL account for 26.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
014kucmqhkt96	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Receipts' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
018x8jv0c9900	select count(*) from user$ u, xdb.xdb$schema s where u.user# = :1 and u.name = s.xmldata.schema_owner and (xdb.dbms_xmlschema_int.xdb$Oid2IntName(s.object_id) = :2)
0643vntsbbshw	select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE_APPLICATION_ID = :3 and V.LEVEL_VALUE = :4
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
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
0sp22whyrm6km	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2036 OR H2.je_category != 'Revaluation' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2036 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_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
17ya8n4yk06wg	SELECT COUNT (*) FROM ALL_OBJECTS WHERE ( OWNER = 'SYS' AND OBJECT_NAME = 'DBMS_JAVA' AND OBJECT_TYPE = 'PACKAGE' AND ALL_OBJECTS.STATUS = 'VALID' ) OR ( OWNER = 'SYSTEM' AND OBJECT_NAME = 'ORA_DE_REFLECTION' AND OBJECT_TYPE = 'PACKAGE' AND ALL_OBJECTS.STATUS = 'VALID' ) OR ( OWNER = 'SYSTEM' AND OBJECT_NAME = 'oracle/opb/Reflection' AND OBJECT_TYPE = 'JAVA CLASS' AND ALL_OBJECTS.STATUS = 'VALID' ) OR ( OWNER = 'SYSTEM' AND OBJECT_NAME = 'oracle/opb/SchemaClassLoader' AND OBJECT_TYPE = 'JAVA CLASS' AND ALL_OBJECTS.STATUS = 'VALID' )
1803mv0ftntrp	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Revaluation' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
1j7w3anv7bnkj	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != '1' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
1p36ta7p3d7fu	select file#, block#, ts#, blocks from seg$ where type# = 3
1s7mvxay5yk21	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Other' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
20n6ztrg3qrj9	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2036 OR H2.je_category != 'Addition' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2036 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
2gcrz6n8bkrd7	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Addition' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
3350m9wncvqvn	select HIERARCHY_TYPE, SITE_ENABLED_FLAG, APP_ENABLED_FLAG, RESP_ENABLED_FLAG, USER_ENABLED_FLAG, SERVER_ENABLED_FLAG, ORG_ENABLED_FLAG, SQL_VALIDATION, SERVERRESP_ENABLED_FLAG from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME = :1
37kp7bjxfn4u5	SELECT NLS_DATE_LANGUAGE FROM (SELECT UTF8_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 UNION SELECT LOCAL_DATE_LANGUAGE NLS_DATE_LANGUAGE FROM FND_LANGUAGES WHERE NLS_CHARSET_NAME(NLS_CHARSET_ID('CHAR_CS')) NOT IN ('UTF8', 'AL32UTF8') AND INSTALLED_FLAG <>'D' AND NLS_LANGUAGE = :B1 )
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
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
497wh6n7hu14f	BEGIN FND_CP_GSM_IPC.Get_Message(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10); END;
4xd696x7z8dm1	lock TABLE FND_CONCURRENT_QUEUES IN SHARE UPDATE MODE
5afhq9x8v3txy	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2036 OR H2.je_category != 'Transfer' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2036 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
5bnjgynp5qghs	SELECT SUM(RA.AMOUNT) FROM CUX_AR_RM_EXCEPTIONS RA WHERE RA.STATUS NOT IN (CUX_AR_RM_COMMON_UTIL.G_REC_STS_CANCELLED, CUX_AR_RM_COMMON_UTIL.G_REC_STS_REVERSED) AND RA.RM_LINE_ID = :B1
5bwkwvjxs4v4v	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2036 OR H2.je_category != 'Adjustment' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2036 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
5tmm78yt172tw	select distinct role_name from wf_user_roles where user_name = :1 or (user_name = (select name from wf_local_roles wlr, fnd_user fusr where fusr.person_party_id = wlr.orig_system_id and wlr.orig_system = 'HZ_PARTY' and fusr.user_name = :2 and rownum < 2)) and role_name <> user_name
5us2xwzatpnwy	begin fnd_dcp.check_process_status_by_handle (:h, :r, :a); end;
6ncv39aj0y393	select distinct menu_id, grant_flag from fnd_compiled_menu_functions where function_id = :1
6vtxunqng57nu	BEGIN :1 := jdr_mds_internal.exportDocumentAsXML(:2, :3, :4, :5, :6); END;
73zm3kytx1dsy	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Credit Memos' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
7b5w34atn8q1h	BEGIN FND_CP_OPP_IPC.Get_Message(:1, :2, :3, :4, :5, :6, :7, :8); END;
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
7z1yaw09vj3r7	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Transfer' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
8hdqp6quwjf0t	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2036 OR H2.je_category != 'Depreciation' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2036 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
8mhtpm4mafqzm	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)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', fnd_conc_release_classes_S.nextval , null ), :b61) , Decode(:b64, 0, null , :b64) , :b66 , :b67 , :b68 , :b69 , :b70 , :b71 , :b72 , :b73 , :b74 , :b75 , :b76 , :b77 , :b78 , :b79 , :b80 , :b81 , :b82 , :b83 , :b84 , :b85 , :b86 , :b87 , :b88 , :b89 , :b90 , decode(:b91, 0, null , :b91) , decode(:b93, 'NULL', null , :b93) , decode(:b95, 'NULL', null , :b95) from FND_CONCURRENT_PROGRAMS Fcp , FND_ORACLE_USERID , FND_APPLICATION Fa where (((ORACLE_USERNAME=:b97 and Fcp.Enabled_Flag='Y') and (Fcp.APPLICATION_ID=Fa.Application_ID and CONCURRENT_PROGRAM_NAME=:b98)) and Fa.APPLICATION_SHORT_NAME=:b99)
8w57t3xaxs89k	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS
8z7srfn4yx5vw	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2036 OR H2.je_category != 'Other' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2036 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
9nmz0ubwg5vg8	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Payments' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
a90wnvray15z2	LOCK TABLE FND_CONCURRENT_QUEUES IN EXCLUSIVE MODE NOWAIT
bazquck2vuvm1	SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT_GROUP_ID
bfzs95axm8g10	SELECT BATCH_ID, BATCH_NAME, BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM, LOCKED_STATUS, LOCKED_USER, STATUS_DESC, MIN_RECEIPT_DATE, MAX_RECEIPT_DATE, LINE_COUNT, APPLIED_AMOUNT, UNAPPLIED_AMOUNT, RECEIPT_SUM, RECEIPT_REMAIN_AMOUNT, CREATED_USER, CREATION_DATE, BANK_ACCOUNT_ID, STATUS_CODE, IS_LOCKED, LOCK_USER_ID, LEDGER_ID, ROW_ID, OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 FROM CUX_AR_RM_BATCHES_V WHERE (BATCH_NAME=:1) order by batch_id
bpx2566x96swd	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Sales Invoices' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
bqzutt5g7maz0	select distinct furg.responsibility_id, furg.responsibility_application_id, furg.security_group_id, furg.start_date, furg.end_date from fnd_user_resp_groups furg, fnd_responsibility fr where furg.user_id = :1 and furg.responsibility_id = fr.responsibility_id and furg.responsibility_application_id = fr.application_id and furg.start_date <= sysdate and (furg.end_date is null or furg.end_date >= sysdate) and fr.start_date <= sysdate and (fr.end_date is null or fr.end_date >= sysdate) order by furg.responsibility_id, furg.responsibility_application_id, furg.security_group_id
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
dawf7hvg1ym94	select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3
dpnjtv87bx8nd	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Adjustment' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id
gfy1zq2p4mxc0	SELECT B.je_batch_id, substrb(B.name, 1, 75), B.status, B.default_period_name, B.actual_flag, B.request_id FROM GL_JE_BATCHES B WHERE B.chart_of_accounts_id = 50368 AND B.period_set_name = 'SOHU_CAL' AND B.accounted_period_type = '21' AND (B.status < 'P' OR B.status > 'P') AND B.status_verified = 'N' AND greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)) = decode(B.control_total, null, greatest(nvl(B.running_total_dr, 0), nvl(B.running_total_cr, 0)), B.control_total) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H2 WHERE H2.je_batch_id = B.je_batch_id AND H2.display_alc_journal_flag IS NULL AND (H2.ledger_id != 2028 OR H2.je_category != 'Depreciation' )) AND B.approval_status_code IN ('A', 'Z') AND B.je_batch_id IN ( SELECT H.je_batch_id FROM GL_JE_HEADERS H WHERE H.je_batch_id = B.je_batch_id AND H.display_alc_journal_flag IS NULL AND H.ledger_id = 2028 AND H.je_source = '1' ) AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H4, GL_PERIOD_STATUSES PS WHERE H4.je_batch_id = B.je_batch_id AND H4.display_alc_journal_flag IS NULL AND B.actual_flag = 'A' AND PS.application_id = 101 AND PS.ledger_id = H4.ledger_id AND PS.period_name = H4.period_name AND PS.closing_status != 'O') AND NOT EXISTS ( SELECT 1 FROM GL_JE_HEADERS H5, GL_LEDGERS L5 WHERE H5.je_batch_id = B.je_batch_id AND H5.display_alc_journal_flag IS NULL AND H5.je_source = 'Manual' AND H5.actual_flag = 'A' AND H5.currency_code != 'STAT' AND H5.tax_status_code = 'R' AND L5.ledger_id = H5.ledger_id AND L5.enable_automatic_tax_flag = 'Y') ORDER BY B.name, B.default_period_name FOR UPDATE OF B.status, B.posting_run_id

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Back to Instance Activity Statistics
Back to Top

IO Stats

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

IOStat by Function summary

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

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Buffer Pool Statistics
• Checkpoint Activity

Buffer Pool Statistics

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

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 1,555

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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

Instance Recovery Stats

• B: Begin Snapshot, E: End Snapshot

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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