WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
VIS	403747463	VIS	1	12-Jun-14 15:06	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
A4U4S141	Solaris[tm] OE (64-bit)	32	16	1	1022.25

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	25	12-Jun-14 16:23:13	2466	31.2
End Snap:	27	12-Jun-14 17:23:24	2389	32.1
Elapsed:		60.19 (mins)
DB Time:		411.66 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	94,720M	94,720M	Std Block Size:	8K
Shared Pool Size:	153,600M	153,600M	Log Buffer:	478,456K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	6.8	0.1	0.00	0.00
DB CPU(s):	5.5	0.1	0.00	0.00
Redo size:	3,707,252.0	30,968.7
Logical reads:	298,564.3	2,494.1
Block changes:	22,298.1	186.3
Physical reads:	23.1	0.2
Physical writes:	609.4	5.1
User calls:	4,427.3	37.0
Parses:	2,257.5	18.9
Hard parses:	0.7	0.0
W/A MB processed:	56.7	0.5
Logons:	3.0	0.0
Executes:	18,738.5	156.5
Rollbacks:	4.0	0.0
Transactions:	119.7

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	100.01	Soft Parse %:	99.97
Execute to Parse %:	87.95	Latch Hit %:	97.75
Parse CPU to Parse Elapsd %:	96.20	% Non-Parse CPU:	97.70

Shared Pool Statistics

	Begin	End
Memory Usage %:	9.70	9.72
% SQL with executions>1:	90.13	90.13
% Memory for SQL w/exec>1:	87.10	85.64

Top 5 Timed Foreground Events

Host CPU (CPUs: 32 Cores: 16 Sockets: 1)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
6.55	6.39	17.7	1.6	0.0	80.7

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	1,046,784.0	1,046,784.0
SGA use (MB):	256,000.0	256,000.0
PGA use (MB):	24,810.0	26,557.9
% Host Mem used for SGA+PGA:	26.83	26.99

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): 24699.9s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 101.5% of Total DB time 24,699.89 (s)
• Total FG Wait Time: 5,072.40 (s) DB CPU time: 20,008.83 (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)

No data exists for this section of the report.

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 21.3% of Total DB Time (s): 24,700
• Captured PL/SQL account for 7.2% of Total DB Time (s): 24,700

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 26.1% of Total CPU Time (s): 20,009
• Captured PL/SQL account for 8.7% of Total CPU Time (s): 20,009

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

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: 1,078,312,600
• Captured SQL account for 54.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 83,449
• Captured SQL account for 0.4% 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,478
• Captured SQL account for 1.0% of Total
• Total UnOptimized Read Requests: 17,478
• Captured SQL account for 1.0% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 67,676,915
• Captured SQL account for 10.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 8,153,418
• Captured SQL account for 51.4% 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

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
0d3t5pd9c06kx	SELECT NVL( SUM( NVL(EXTENDED_AMOUNT, 0 ) ), 0), NVL( SUM( NVL(EXTENDED_AMOUNT, 0 ) ), 0) FROM RA_CUSTOMER_TRX_LINES WHERE CUSTOMER_TRX_ID = :B2 AND LINE_TYPE = :B1
0rxhfv39us09g	SELECT 'Y' FROM RA_CUSTOMER_TRX_LINES CTL WHERE CTL.CUSTOMER_TRX_ID = :B1 AND CTL.LINE_TYPE = 'LINE' AND NVL(CTL.AUTORULE_COMPLETE_FLAG, 'Y') <> 'N'
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1g62m2w49xngu	BEGIN XNP_EVENT.PROCESS_IN_EVT(:1, :2, :3, :4) ; END;
2714fpj38u2c0	SELECT HS.HOLD_SOURCE_ID, HS.HOLD_ID, HS.HOLD_ENTITY_CODE, HS.HOLD_ENTITY_ID, HS.HOLD_ENTITY_CODE2, HS.HOLD_ENTITY_ID2 FROM OE_HOLD_SOURCES HS, OE_HOLD_DEFINITIONS HLD WHERE HLD.HOLD_ID = HS.HOLD_ID AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >= ROUND( SYSDATE ) AND HS.RELEASED_FLAG = 'N' AND SYSDATE BETWEEN NVL( HLD.START_DATE_ACTIVE, SYSDATE ) AND NVL( HLD.END_DATE_ACTIVE, SYSDATE ) AND HS.HOLD_ENTITY_CODE = :B2 AND HS.HOLD_ENTITY_ID = :B1
2gr8c5nzs91d3	SELECT SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', -1*NVL(UNIT_SELLING_PRICE, 0), NVL(UNIT_SELLING_PRICE, 0))) FROM OE_ORDER_LINES WHERE ORDER_SOURCE_ID=27 AND ORIG_SYS_DOCUMENT_REF=TO_CHAR(:B2 ) AND ORIG_SYS_LINE_REF = TO_CHAR(:B1 ) AND RETROBILL_REQUEST_ID IS NOT NULL
2mj6c1fqvxmp9	SELECT 'EXISTS' FROM OE_ORDER_LINES_ALL WHERE HEADER_ID = :B1 AND ROWNUM = 1
2v1vanmps8nck	SELECT NVL(OT.CUST_TRX_TYPE_ID, 0) FROM OE_ORDER_TYPES_V OT, OE_ORDER_HEADERS_ALL OH WHERE OT.ORDER_TYPE_ID = OH.ORDER_TYPE_ID AND OH.HEADER_ID = :B1
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3cv034rb4c2z4	SELECT RELATED_CUST_ACCOUNT_ID FROM HZ_CUST_ACCT_RELATE WHERE CUST_ACCOUNT_ID = :B1
3jznhhwdk3hj4	SELECT NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', NVL(ORDERED_QUANTITY, 0)*(UNIT_LIST_PRICE), 0)), 0), NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', 0, NVL(ORDERED_QUANTITY, 0)*(UNIT_LIST_PRICE))), 0), NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', NVL(ORDERED_QUANTITY, 0), 0)), 0), NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', 0, NVL(ORDERED_QUANTITY, 0))), 0) FROM OE_ORDER_LINES WHERE HEADER_ID=:B1 AND (CANCELLED_FLAG='N' OR CANCELLED_FLAG IS NULL) AND CHARGE_PERIODICITY_CODE IS NULL
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
4wgb411d8s7ss	INSERT INTO QP_NPREQ_LINE_ATTRS_TMP (LINE_INDEX, ATTRIBUTE_LEVEL, ATTRIBUTE_TYPE, CONTEXT, ATTRIBUTE, VALUE_FROM, VALIDATED_FLAG, APPLIED_FLAG, PRICING_STATUS_CODE, PRICING_ATTR_FLAG ) VALUES (:B1 , :B10 , :B2 , :B3 , :B4 , :B5 , :B6 , :B9 , :B8 , :B7 )
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
50f9jsbadpx27	UPDATE RA_CUST_TRX_LINE_GL_DIST LGD SET (AMOUNT, ACCTD_AMOUNT) = (SELECT NVL(LGD.AMOUNT, 0) - ( SUM(LGD2.AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) ) ), NVL(LGD.ACCTD_AMOUNT, 0) - ( SUM(LGD2.ACCTD_AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD2, RA_CUSTOMER_TRX_LINES CTL, RA_CUSTOMER_TRX CT, RA_CUST_TRX_LINE_GL_DIST REC1 WHERE REC1.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC1.ACCOUNT_CLASS = 'REC' AND REC1.LATEST_REC_FLAG = 'Y' AND CT.CUSTOMER_TRX_ID = REC1.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.ACCOUNT_CLASS = LGD.ACCOUNT_CLASS AND LGD2.ACCOUNT_SET_FLAG = 'N' AND NVL(LGD2.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD.GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), REC1.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, CT.EXCHANGE_RATE ), PERCENT = (SELECT DECODE(LGD.ACCOUNT_CLASS || LGD.ACCOUNT_SET_FLAG, 'SUSPENSEN', LGD.PERCENT, 'UNBILLN', LGD.PERCENT, 'UNEARNN', LGD.PERCENT, NVL(LGD.PERCENT, 0) - ( SUM(NVL(LGD4.PERCENT, 0)) - DECODE(REC2.GL_DATE, NVL(LGD.GL_DATE, REC2.GL_DATE), 100, 0) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD4, RA_CUST_TRX_LINE_GL_DIST REC2 WHERE REC2.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC2.ACCOUNT_CLASS = 'REC' AND REC2.LATEST_REC_FLAG = 'Y' AND LGD4.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD4.ACCOUNT_SET_FLAG = LGD.ACCOUNT_SET_FLAG AND DECODE(LGD4.ACCOUNT_SET_FLAG, 'Y', LGD4.ACCOUNT_CLASS, LGD.ACCOUNT_CLASS) = LGD.ACCOUNT_CLASS AND NVL(LGD4.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD.GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY REC2.GL_DATE, LGD.GL_DATE ), LAST_UPDATED_BY = :B1 , LAST_UPDATE_DATE = SYSDATE WHERE CUST_TRX_LINE_GL_DIST_ID IN (SELECT MIN(DECODE(LGD3.GL_POSTED_DATE, NULL, LGD3.CUST_TRX_LINE_GL_DIST_ID, NULL) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD3, RA_CUST_TRX_LINE_GL_DIST REC3, RA_CUSTOMER_TRX T, RA_CUSTOMER_TRX_LINES CTL WHERE CTL.CUSTOMER_TRX_LINE_ID = :B5 AND T.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID AND REC3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND REC3.ACCOUNT_CLASS = 'REC' AND REC3.LATEST_REC_FLAG = 'Y' AND ( CTL.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL.LINE_TYPE = 'LINE' AND CTL.ACCOUNTING_RULE_ID IS NULL) ) AND LGD3.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID AND LGD3.ACCOUNT_SET_FLAG = 'N' AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) = DECODE(:B4 , 'INV', -1, 'REGULAR_CM', T.PREVIOUS_CUSTOMER_TRX_ID, NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), LGD3.GL_DATE, REC3.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, T.EXCHANGE_RATE HAVING ( SUM(NVL(LGD3.AMOUNT, 0)) <> DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) OR SUM(NVL(LGD3.ACCTD_AMOUNT, 0)) <> DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.A CCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) UNION SELECT TO_NUMBER( MIN(DECODE(LGD5.GL_POSTED_DATE||LGD5.ACCOUNT_CLASS|| LGD5.ACCOUNT_SET_FLAG, 'REVN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'REVY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNEARNY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNBILLY', LGD5.CUST_TRX_LINE_GL_DIST_ID, NULL) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD5, RA_CUST_TRX_LINE_GL_DIST REC5, RA_CUSTOMER_TRX_LINES CTL2 WHERE CTL2.CUSTOMER_TRX_LINE_ID = :B5 AND REC5.CUSTOMER_TRX_ID = LGD5.CUSTOMER_TRX_ID AND REC5.ACCOUNT_CLASS = 'REC' AND REC5.LATEST_REC_FLAG = 'Y' AND LGD5.CUSTOMER_TRX_LINE_ID = CTL2.CUSTOMER_TRX_LINE_ID AND ( CTL2.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL2.LINE_TYPE = 'LINE' AND (CTL2.ACCOUNTING_RULE_ID IS NULL OR LGD5.ACCOUNT_SET_FLAG = 'Y') ) ) GROUP BY LGD5.CUSTOMER_TRX_LINE_ID, LGD5.GL_DATE, REC5.GL_DATE, LGD5.ACCOUNT_SET_FLAG, DECODE(LGD5.ACCOUNT_SET_FLAG, 'N', NULL, LGD5.ACCOUNT_CLASS) HAVING SUM(NVL(LGD5.PERCENT, 0)) <> DECODE( NVL(LGD5.GL_DATE, REC5.GL_DATE), REC5.GL_DATE, 100, 0) )
52uy1628x95hv	SELECT AD.TYPE TYPE, ADS.SEGMENT SEGMENT, UPPER(ADS.TABLE_NAME) TABLE_NAME, ADS.CONSTANT CONSTANT FROM RA_ACCOUNT_DEFAULT_SEGMENTS ADS, RA_ACCOUNT_DEFAULTS AD WHERE AD.GL_DEFAULT_ID = ADS.GL_DEFAULT_ID AND AD.ORG_ID = NVL(:B1 , AD.ORG_ID) AND AD.TYPE IN ( 'REV', 'REC', 'FREIGHT', 'TAX', 'UNBILL', 'UNEARN', 'SUSPENSE' ) ORDER BY TYPE, SEGMENT_NUM
592madzz61k01	WITH a as (SELECT a$.dbid, a$.snap_id, a$.INSTANCE_NUMBER, a$.PLSQL_ENTRY_OBJECT_ID, a$.PLSQL_ENTRY_SUBPROGRAM_ID, a$.TIME_MODEL FROM WRH$_ACTIVE_SESSION_HISTORY a$ WHERE a$.dbid = :dbid AND a$.instance_number = :inst AND a$.snap_id > :bid AND a$.snap_id <= :eid AND a$.session_type = 1 ) , ash as (SELECT cnt , PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID FROM ( SELECT count(*) as cnt , a.PLSQL_ENTRY_OBJECT_ID, a.PLSQL_ENTRY_SUBPROGRAM_ID FROM a WHERE bitand(a.time_model, power(2, 11 )) !=0 AND a.PLSQL_ENTRY_OBJECT_ID > 0 AND a.PLSQL_ENTRY_SUBPROGRAM_ID > 0 GROUP BY PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID HAVING count(*) >= :rowcnt ORDER BY 1 DESC, 2 ASC ) WHERE rownum <= :ret) SELECT ash.plsql_entry_object_id, ash.plsql_entry_subprogram_id, dba.object_name, dba.object_type, dba.owner, dba.procedure_name, to_number(dba.overload), ash.cnt FROM dba_procedures dba, ash WHERE ash.plsql_entry_object_id = dba.object_id(+) AND ash.plsql_entry_subprogram_id = dba.subprogram_id(+) ORDER BY ash.cnt DESC, ash.plsql_entry_object_id, ash.plsql_entry_subprogram_id
5af1f003zv7st	INSERT INTO CSI_ITEM_INSTANCES_H( INSTANCE_HISTORY_ID, INSTANCE_ID, TRANSACTION_ID, OLD_INSTANCE_NUMBER, NEW_INSTANCE_NUMBER, OLD_EXTERNAL_REFERENCE, NEW_EXTERNAL_REFERENCE, OLD_INVENTORY_ITEM_ID, NEW_INVENTORY_ITEM_ID, OLD_INVENTORY_REVISION, NEW_INVENTORY_REVISION, OLD_INV_MASTER_ORGANIZATION_ID, NEW_INV_MASTER_ORGANIZATION_ID, OLD_SERIAL_NUMBER, NEW_SERIAL_NUMBER , OLD_MFG_SERIAL_NUMBER_FLAG, NEW_MFG_SERIAL_NUMBER_FLAG, OLD_LOT_NUMBER, NEW_LOT_NUMBER, OLD_QUANTITY, NEW_QUANTITY, OLD_UNIT_OF_MEASURE, NEW_UNIT_OF_MEASURE, OLD_ACCOUNTING_CLASS_CODE, NEW_ACCOUNTING_CLASS_CODE, OLD_INSTANCE_CONDITION_ID, NEW_INSTANCE_CONDITION_ID, OLD_INSTANCE_STATUS_ID, NEW_INSTANCE_STATUS_ID, OLD_CUSTOMER_VIEW_FLAG, NEW_CUSTOMER_VIEW_FLAG, OLD_MERCHANT_VIEW_FLAG, NEW_MERCHANT_VIEW_FLAG, OLD_SELLABLE_FLAG, NEW_SELLABLE_FLAG, OLD_SYSTEM_ID, NEW_SYSTEM_ID, OLD_INSTANCE_TYPE_CODE, NEW_INSTANCE_TYPE_CODE, OLD_ACTIVE_START_DATE, NEW_ACTIVE_START_DATE, OLD_ACTIVE_END_DATE, NEW_ACTIVE_END_DATE, OLD_LOCATION_TYPE_CODE, NEW_LOCATION_TYPE_CODE, OLD_LOCATION_ID, NEW_LOCATION_ID, OLD_INV_ORGANIZATION_ID, NEW_INV_ORGANIZATION_ID, OLD_INV_SUBINVENTORY_NAME, NEW_INV_SUBINVENTORY_NAME, OLD_INV_LOCATOR_ID, NEW_INV_LOCATOR_ID, OLD_PA_PROJECT_ID, NEW_PA_PROJECT_ID, OLD_PA_PROJECT_TASK_ID, NEW_PA_PROJECT_TASK_ID, OLD_IN_TRANSIT_ORDER_LINE_ID, NEW_IN_TRANSIT_ORDER_LINE_ID, OLD_WIP_JOB_ID, NEW_WIP_JOB_ID, OLD_PO_ORDER_LINE_ID, NEW_PO_ORDER_LINE_ID, OLD_COMPLETENESS_FLAG, NEW_COMPLETENESS_FLAG, FULL_DUMP_FLAG, OLD_CONTEXT, NEW_CONTEXT, OLD_ATTRIBUTE1, NEW_ATTRIBUTE1, OLD_ATTRIBUTE2, NEW_ATTRIBUTE2, OLD_ATTRIBUTE3, NEW_ATTRIBUTE3, OLD_ATTRIBUTE4, NEW_ATTRIBUTE4, OLD_ATTRIBUTE5, NEW_ATTRIBUTE5, OLD_ATTRIBUTE6, NEW_ATTRIBUTE6, OLD_ATTRIBUTE7, NEW_ATTRIBUTE7, OLD_ATTRIBUTE8, NEW_ATTRIBUTE8, OLD_ATTRIBUTE9, NEW_ATTRIBUTE9, OLD_ATTRIBUTE10, NEW_ATTRIBUTE10, OLD_ATTRIBUTE11, NEW_ATTRIBUTE11, OLD_ATTRIBUTE12, NEW_ATTRIBUTE12, OLD_ATTRIBUTE13, NEW_ATTRIBUTE13, OLD_ATTRIBUTE14, NEW_ATTRIBUTE14, OLD_ATTRIBUTE15, NEW_ATTRIBUTE15, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, OLD_INST_LOC_TYPE_CODE, NEW_INST_LOC_TYPE_CODE, OLD_INST_LOC_ID, NEW_INST_LOC_ID, OLD_INST_USAGE_CODE, NEW_INST_USAGE_CODE, OLD_LAST_VLD_ORGANIZATION_ID, NEW_LAST_VLD_ORGANIZATION_ID, OLD_CONFIG_INST_REV_NUM , NEW_CONFIG_INST_REV_NUM , OLD_CONFIG_VALID_STATUS , NEW_CONFIG_VALID_STATUS , OLD_INSTANCE_DESCRIPTION , NEW_INSTANCE_DESCRIPTION , OLD_INSTALL_DATE , NEW_INSTALL_DATE , OLD_RETURN_BY_DATE , NEW_RETURN_BY_DATE , OLD_ACTUAL_RETURN_DATE , NEW_ACTUAL_RETURN_DATE , OLD_OE_AGREEMENT_ID , NEW_OE_AGREEMENT_ID , OLD_LAST_OE_ORDER_LINE_ID, NEW_LAST_OE_ORDER_LINE_ID, OLD_LAST_OE_RMA_LINE_ID, NEW_LAST_OE_RMA_LINE_ID, OLD_LAST_WIP_JOB_ID, NEW_LAST_WIP_JOB_ID, OLD_LAST_PO_PO_LINE_ID, NEW_LAST_PO_PO_LINE_ID, OLD_LAST_PA_PROJECT_ID, NEW_LAST_PA_PROJECT_ID, OLD_LAST_PA_TASK_ID, NEW_LAST_PA_TASK_ID, OLD_LAST_TXN_LINE_DETAIL_ID, NEW_LAST_TXN_LINE_DETAIL_ID, OLD_LAST_OE_PO_NUMBER, NEW_LAST_OE_PO_NUMBER, OLD_NETWORK_ASSET_FLAG, NEW_NETWORK_ASSET_FLAG, OLD_MAINTAINABLE_FLAG, NEW_MAINTAINABLE_FLAG, OLD_PN_LOCATION_ID, NEW_PN_LOCATION_ID, OLD_ASSET_CRITICALITY_CODE, NEW_ASSET_CRITICALITY_CODE, OLD_CATEGORY_ID, NEW_CATEGORY_ID, OLD_EQUIPMENT_GEN_OBJECT_ID, NEW_EQUIPMENT_GEN_OBJECT_ID, OLD_INSTANTIATION_FLAG, NEW_INSTANTIATION_FLAG, OLD_LINEAR_LOCATION_ID, NEW_LINEAR_LOCATION_ID, OLD_OPERATIONAL_LOG_FLAG, NEW_OPERATIONAL_LOG_FLAG, OLD_CHECKIN_STATUS, NEW_CHECKIN_STATUS, OLD_SUPPLIER_WARRANTY_EXP_DATE, NEW_SUPPLIER_WARRANTY_EXP_DATE, OLD_ATTRIBUTE16, NEW_ATTRIBUTE16, OLD_ATTRIBUTE17, NEW_ATTRIBUTE17, OLD_ATTRIBUTE18, NEW_ATTRIBUTE18, OLD_ATTRIBUTE19, NEW_ATTRIBUTE19, OLD_ATTRIBUTE20, NEW_ATTRIBUTE20, OLD_ATTRIBUTE21, NEW_ATTRIBUTE21, OLD_ATTRIBUTE22, NEW_ATTRIBUTE22, OLD_ATTRIBUTE23, NEW_ATTRIBU TE23, OLD_ATTRIBUTE24, NEW_ATTRIBUTE24, OLD_ATTRIBUTE25, NEW_ATTRIBUTE25, OLD_ATTRIBUTE26, NEW_ATTRIBUTE26, OLD_ATTRIBUTE27, NEW_ATTRIBUTE27, OLD_ATTRIBUTE28, NEW_ATTRIBUTE28, OLD_ATTRIBUTE29, NEW_ATTRIBUTE29, OLD_ATTRIBUTE30, NEW_ATTRIBUTE30, OLD_PAYABLES_UNIT_PRICE, NEW_PAYABLES_UNIT_PRICE, OLD_PAYABLES_CURRENCY_CODE, NEW_PAYABLES_CURRENCY_CODE, OLD_PURCHASE_UNIT_PRICE, NEW_PURCHASE_UNIT_PRICE, OLD_PURCHASE_CURRENCY_CODE, NEW_PURCHASE_CURRENCY_CODE, OLD_SALES_UNIT_PRICE, NEW_SALES_UNIT_PRICE, OLD_SALES_CURRENCY_CODE, NEW_SALES_CURRENCY_CODE, OLD_OPERATIONAL_STATUS_CODE, NEW_OPERATIONAL_STATUS_CODE, OLD_SOURCE_CODE, NEW_SOURCE_CODE ) VALUES ( :B213 , DECODE( :B212 , :B9 , NULL, :B212 ), DECODE( :B211 , :B9 , NULL, :B211 ), DECODE( :B210 , :B2 , NULL, :B210 ), DECODE( :B209 , :B2 , NULL, :B209 ), DECODE( :B208 , :B2 , NULL, :B208 ), DECODE( :B207 , :B2 , NULL, :B207 ), DECODE( :B206 , :B9 , NULL, :B206 ), DECODE( :B205 , :B9 , NULL, :B205 ), DECODE( :B204 , :B2 , NULL, :B204 ), DECODE( :B203 , :B2 , NULL, :B203 ), DECODE( :B202 , :B9 , NULL, :B202 ), DECODE( :B201 , :B9 , NULL, :B201 ), DECODE( :B200 , :B2 , NULL, :B200 ), DECODE( :B199 , :B2 , NULL, :B199 ) , DECODE( :B198 , :B2 , NULL, :B198 ), DECODE( :B197 , :B2 , NULL, :B197 ), DECODE( :B196 , :B2 , NULL, :B196 ), DECODE( :B195 , :B2 , NULL, :B195 ), DECODE( :B194 , :B9 , NULL, :B194 ), DECODE( :B193 , :B9 , NULL, :B193 ), DECODE( :B192 , :B2 , NULL, :B192 ), DECODE( :B191 , :B2 , NULL, :B191 ), DECODE( :B190 , :B2 , NULL, :B190 ), DECODE( :B189 , :B2 , NULL, :B189 ), DECODE( :B188 , :B9 , NULL, :B188 ), DECODE( :B187 , :B9 , NULL, :B187 ), DECODE( :B186 , :B9 , NULL, :B186 ), DECODE( :B185 , :B9 , NULL, :B185 ), DECODE( :B184 , :B2 , NULL, :B184 ), DECODE( :B183 , :B2 , NULL, :B183 ), DECODE( :B182 , :B2 , NULL, :B182 ), DECODE( :B181 , :B2 , NULL, :B181 ), DECODE( :B180 , :B2 , NULL, :B180 ), DECODE( :B179 , :B2 , NULL, :B179 ), DECODE( :B178 , :B9 , NULL, :B178 ), DECODE( :B177 , :B9 , NULL, :B177 ), DECODE( :B176 , :B2 , NULL, :B176 ), DECODE( :B175 , :B2 , NULL, :B175 ), DECODE( :B174 , :B50 , TO_DATE(NULL), :B174 ), DECODE( :B173 , :B50 , TO_DATE(NULL), :B173 ), DECODE( :B172 , :B50 , TO_DATE(NULL), :B172 ), DECODE( :B171 , :B50 , TO_DATE(NULL), :B171 ), DECODE( :B170 , :B2 , NULL, :B170 ), DECODE( :B169 , :B2 , NULL, :B169 ), DECODE( :B168 , :B9 , NULL, :B168 ), DECODE( :B167 , :B9 , NULL, :B167 ), DECODE( :B166 , :B9 , NULL, :B166 ), DECODE( :B165 , :B9 , NULL, :B165 ), DECODE( :B164 , :B2 , NULL, :B164 ), DECODE( :B163 , :B2 , NULL, :B163 ), DECODE( :B162 , :B9 , NULL, :B162 ), DECODE( :B161 , :B9 , NULL, :B161 ), DECODE( :B160 , :B9 , NULL, :B160 ), DECODE( :B159 , :B9 , NULL, :B159 ), DECODE( :B158 , :B9 , NULL, :B158 ), DECODE( :B157 , :B9 , NULL, :B157 ), DECODE( :B156 , :B9 , NULL, :B156 ), DECODE( :B155 , :B9 , NULL, :B155 ), DECODE( :B154 , :B9 , NULL, :B154 ), DECODE( :B153 , :B9 , NULL, :B153 ), DECODE( :B152 , :B9 , NULL, :B152 ), DECODE( :B151 , :B9 , NULL, :B151 ), DECODE( :B150 , :B2 , NULL, :B150 ), DECODE( :B149 , :B2 , NULL, :B149 ), DECODE( :B148 , :B2 , NULL, :B148 ), DECODE( :B147 , :B2 , NULL, :B147 ), DECODE( :B146 , :B2 , NULL, :B146 ), DECODE( :B145 , :B2 , NULL, :B145 ), DECODE( :B144 , :B2 , NULL, :B144 ), DECODE( :B143 , :B2 , NULL, :B143 ), DECODE( :B142 , :B2 , NULL, :B142 ), DECODE( :B141 , :B2 , NULL, :B141 ), DECODE( :B140 , :B2 , NULL, :B140 ), DECODE( :B139 , :B2 , NULL, :B139 ), DECODE( :B138 , :B2 , NULL, :B138 ), DECODE( :B137 , :B2 , NULL, :B137 ), DECODE( :B136 , :B2 , NULL, :B136 ), DECODE( :B135 , :B2 , NULL, :B135 ), DECODE( :B134 , :B2 , NULL, :B134 ), DECODE( :B133 , :B2 , NULL, :B133 ), DECODE( :B132 , :B2 , NULL, :B132 ), DECODE( :B131 , :B2 , NULL, :B131 ), DECODE( :B130 , :B2 , NULL, :B130 ), DECODE( :B129 , :B2 , NULL, :B129 ), DECODE( :B128 , :B2 , NULL, :B128 ), DECODE( :B127 , :B2 , NULL, :B127 ), DECODE( :B126 , :B2 , NULL, :B126 ), DECODE( :B125 , :B2 , NULL, :B125 ), DECODE( :B124 , :B2 , NULL, :B124 ), DECODE( :B123 , :B2 , NULL, :B123 ), DECODE( :B122 , :B2 , NULL, :B122 ), DECODE( :B121 , :B2 , NULL, :B121 ), DECODE( :B120 , :B2 , NULL, :B120 ), DECODE( :B119 , :B2 , NULL, :B119 ), DECODE( :B118 , :B2 , NULL, :B118 ), DECODE( :B117 , :B2 , NULL, :B117 ), DECODE( :B116 , :B2 , NULL, :B116 ), DECODE( :B115 , :B9 , NULL, :B115 ), DECODE( :B114 , :B50 , TO_DATE(NULL), :B114 ), DECODE( :B113 , :B9 , NULL, :B113 ), DECODE( :B112 , :B50 , TO_DATE(NULL), :B112 ), DECODE( :B111 , :B9 , NULL, :B111 ), DECODE( :B110 , :B9 , NULL, :B110 ), DECODE( :B109 , :B2 , NULL, :B109 ), DECODE( :B108 , :B2 , NULL, :B108 ), DECODE( :B107 , :B9 , NULL, :B107 ), DECODE( :B106 , :B9 , NULL, :B106 ), DECODE( :B105 , :B2 , NULL, :B105 ), DECODE( :B104 , :B2 , NULL, :B104 ), DECODE( :B103 , :B9 , NULL, :B103 ), DECODE( :B102 , :B9 , NULL, :B102 ), DECODE( :B101 , :B9 , NULL, :B101 ), DECODE( :B100 , :B9 , NULL, :B100 ), DECODE( :B99 , :B2 , NULL, :B99 ), DECODE( :B98 , :B2 , NULL, :B98 ), DECODE( :B97 , :B2 , NULL, :B97 ), DECODE( :B96 , :B2 , NULL, :B96 ), DECODE( :B95 , :B50 , TO_DATE(NULL), :B95 ), DECODE( :B94 , :B50 , TO_DATE(NULL), :B94 ), DECODE( :B93 , :B50 , TO_DATE(NULL), :B93 ), DECODE( :B92 , :B50 , TO_DATE(NULL), :B92 ), DECODE( :B91 , :B50 , TO_DATE(NULL), :B91 ), DECODE( :B90 , :B50 , TO_DATE(NULL), :B90 ), DECODE( :B89 , :B9 , NULL, :B89 ), DECODE( :B88 , :B9 , NULL, :B88 ), DECODE(:B87 , :B9 , NULL, :B87 ), DECODE(:B86 , :B9 , NULL, :B86 ), DECODE(:B85 , :B9 , NULL, :B85 ), DECODE(:B84 , :B9 , NULL, :B84 ), DECODE(:B83 , :B9 , NULL, :B83 ), DECODE(:B82 , :B9 , NULL, :B82 ), DECODE(:B81 , :B9 , NULL, :B81 ), DECODE(:B80 , :B9 , NULL, :B80 ), DECODE(:B79 , :B9 , NULL, :B79 ), DECODE(:B78 , :B9 , NULL, :B78 ), DECODE(:B77 , :B9 , NULL, :B77 ), DECODE(:B76 , :B9 , NULL, :B76 ), DECODE(:B75 , :B9 , NULL, :B75 ), DECODE(:B74 , :B9 , NULL, :B74 ), DECODE(:B73 , :B2 , NULL, :B73 ), DECODE(:B72 , :B2 , NULL, :B72 ), DECODE( :B71 , :B2 , NULL, :B71 ), DECODE( :B70 , :B2 , NULL, :B70 ), DECODE( :B69 , :B2 , NULL, :B69 ), DECODE( :B68 , :B2 , NULL, :B68 ), DECODE( :B67 , :B9 , NULL, :B67 ), DECODE( :B66 , :B9 , NULL, :B66 ), DECODE( :B65 , :B2 , NULL, :B65 ), DECODE( :B64 , :B2 , NULL, :B64 ), DECODE( :B63 , :B9 , NULL, :B63 ), DECODE( :B62 , :B9 , NULL, :B62 ), DECODE( :B61 , :B9 , NULL, :B61 ), DECODE( :B60 , :B9 , NULL, :B60 ), DECODE( :B59 , :B2 , NULL, :B59 ), DECODE( :B58 , :B2 , NULL, :B58 ), DECODE( :B57 , :B9 , NULL, :B57 ), DECODE( :B56 , :B9 , NULL, :B56 ), DECODE( :B55 , :B2 , NULL, :B55 ), DECODE( :B54 , :B2 , NULL, :B54 ), DECODE( :B53 , :B9 , NULL, :B53 ), DECODE( :B52 , :B9 , NULL, :B52 ), DECODE( :B51 , :B50 , TO_DATE(NULL), :B51 ), DECODE( :B49 , :B50 , TO_DATE(NULL), :B49 ), DECODE( :B48 , :B2 , NULL, :B48 ), DECODE( :B47 , :B2 , NULL, :B47 ), DECODE( :B46 , :B2 , NULL, :B46 ), DECODE( :B45 , :B2 , NULL, :B45 ), DECODE( :B44 , :B2 , NULL, :B44 ), DECODE( :B43 , :B2 , NULL, :B43 ), DECODE( :B42 , :B2 , NULL, :B42 ), DECODE( :B41 , :B2 , NULL, :B41 ), DECODE( :B40 , :B2 , NULL, :B40 ), DECODE( :B39 , :B2 , NULL, :B39 ), DECODE( :B38 , :B2 , NULL, :B38 ), DECODE( :B37 , :B2 , NULL, :B37 ), DECODE( :B36 , :B2 , NULL, :B36 ), DECODE( :B35 , :B2 , NULL, :B35 ), DECODE( :B34 , :B2 , NULL, :B34 ), DECODE( :B33 , :B2 , NULL, :B33 ), DECODE( :B32 , :B2 , NULL, :B3 2 ), DECODE( :B31 , :B2 , NULL, :B31 ), DECODE( :B30 , :B2 , NULL, :B30 ), DECODE( :B29 , :B2 , NULL, :B29 ), DECODE( :B28 , :B2 , NULL, :B28 ), DECODE( :B27 , :B2 , NULL, :B27 ), DECODE( :B26 , :B2 , NULL, :B26 ), DECODE( :B25 , :B2 , NULL, :B25 ), DECODE( :B24 , :B2 , NULL, :B24 ), DECODE( :B23 , :B2 , NULL, :B23 ), DECODE( :B22 , :B2 , NULL, :B22 ), DECODE( :B21 , :B2 , NULL, :B21 ), DECODE( :B20 , :B2 , NULL, :B20 ), DECODE( :B19 , :B2 , NULL, :B19 ), DECODE( :B18 , :B9 , NULL, :B18 ), DECODE( :B17 , :B9 , NULL, :B17 ), DECODE( :B16 , :B2 , NULL, :B16 ), DECODE( :B15 , :B2 , NULL, :B15 ), DECODE( :B14 , :B9 , NULL, :B14 ), DECODE( :B13 , :B9 , NULL, :B13 ), DECODE( :B12 , :B2 , NULL, :B12 ), DECODE( :B11 , :B2 , NULL, :B11 ), DECODE( :B10 , :B9 , NULL, :B10 ), DECODE( :B8 , :B9 , NULL, :B8 ), DECODE( :B7 , :B2 , NULL, :B7 ), DECODE( :B6 , :B2 , NULL, :B6 ), DECODE( :B5 , :B2 , NULL, :B5 ), DECODE( :B4 , :B2 , NULL, :B4 ), DECODE( :B3 , :B2 , NULL, :B3 ), DECODE( :B1 , :B2 , NULL, :B1 ) )
5j000r4cc1kaz	SELECT PERIOD3_ORDERED_QUANTITY, PRIMARY_UOM_CODE FROM OE_ITEM_CUST_VOLS WHERE SOLD_TO_ORG_ID = :B2 AND INVENTORY_ITEM_ID = :B1
5uc22nkkupb6x	SELECT INVENTORY_ITEM_ID , ORGANIZATION_ID , INVOICING_RULE_ID , ACCOUNTING_RULE_ID , DEFAULT_SHIPPING_ORG , SHIP_MODEL_COMPLETE_FLAG , BUILD_IN_WIP_FLAG , BOM_ITEM_TYPE , REPLENISH_TO_ORDER_FLAG , PRIMARY_UOM_CODE , PICK_COMPONENTS_FLAG , SHIPPABLE_ITEM_FLAG , SERVICE_ITEM_FLAG , ORGANIZATION_ID , CUSTOMER_ORDER_ENABLED_FLAG , INTERNAL_ORDER_ENABLED_FLAG , RETURNABLE_FLAG , RESTRICT_SUBINVENTORIES_CODE FROM MTL_SYSTEM_ITEMS WHERE INVENTORY_ITEM_ID = :B2 AND ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID', :B1 )
5vbbcp6pd58b8	begin Fnd_Concurrent.Init_Request; end;
6a02d9nxfg5x9	SELECT PID INTO :opid FROM V$PROCESS P, V$SESSION S WHERE S.AUDSID = USERENV('SESSIONID') AND P.Addr = S.Paddr
6y2m7nrx0s6tn	BEGIN DECLARE l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ; BEGIN l_msg_header.message_id := :message_id ; l_msg_header.message_code := :message_code ; l_msg_header.reference_id := :reference_id ; l_msg_header.opp_reference_id := :opp_ref_id ; l_msg_header.creation_date := :creation_date; l_msg_header.sender_name := :sender_name ; l_msg_header.recipient_name := :recipient_name ; l_msg_header.version := :version; l_msg_header.direction_indr := :direction_indr ; l_msg_header.order_id := :order_id ; l_msg_header.wi_instance_id := :wi_instance_id ; l_msg_header.fa_instance_id := :fa_instance_id ; XNP_CSISUBTR_U.DEFAULT_PROCESS( l_msg_header, :l_msg_body, :error_code, :error_message ) ; END ; END ;
8camsgjsr9zya	begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8p204vk5avzuq	SELECT TAX_REGIME_CODE, TAX, STATUS_RESULT, RATE_RESULT, CONDITION_SET_ID, EXCEPTION_SET_ID, RESULT_ID, QUERY_NUM FROM (SELECT /*+ leading(PR) use_nl(RL) */ RL.TAX_REGIME_CODE, RL.TAX, PR.STATUS_RESULT, PR.RATE_RESULT, PR.CONDITION_SET_ID, PR.EXCEPTION_SET_ID, PR.RESULT_ID, 1 QUERY_NUM, TAX.COMPOUNDING_PRECEDENCE FROM ZX_PROCESS_RESULTS PR, ZX_SCO_RULES_B_V RL, ZX_SCO_TAXES_B_V TAX WHERE (PR.CONDITION_GROUP_CODE = :B2 OR PR.CONDITION_GROUP_CODE LIKE :B2 ||'~'||'%') AND RL.EFFECTIVE_FROM <= :B1 AND (RL.EFFECTIVE_TO >= :B1 OR RL.EFFECTIVE_TO IS NULL ) AND PR.ENABLED_FLAG = 'Y' AND RL.TAX_RULE_ID = PR.TAX_RULE_ID AND RL.SERVICE_TYPE_CODE = 'DET_DIRECT_RATE' AND TAX.TAX_REGIME_CODE=RL.TAX_REGIME_CODE AND TAX.TAX=RL.TAX AND EXISTS (SELECT /*+ no_unnest */ 1 FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_REGIME_CODE = RL.TAX_REGIME_CODE AND RT.TAX = RL.TAX AND RT.TAX_STATUS_CODE = PR.STATUS_RESULT AND RT.TAX_RATE_CODE = PR.RATE_RESULT AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL)) UNION ALL SELECT /*+ leading(RT.a) use_nl(RT.sd) */ DISTINCT RT.TAX_REGIME_CODE, RT.TAX, RT.TAX_STATUS_CODE, RT.TAX_RATE_CODE, NULL CONDITION_SET_ID, NULL EXCEPTION_SET_ID, NULL RESULT_ID, 2 QUERY_NUM, -1 COMPOUNDING_PRECEDENCE FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_RATE_CODE = :B4 AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL) AND EXISTS (SELECT 1 FROM ZX_SCO_TAXES_B_V TAX WHERE TAX.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND TAX.TAX = RT.TAX AND TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y') ) ORDER BY COMPOUNDING_PRECEDENCE NULLS FIRST
8qrr7q1f17rnu	select cust_acct.account_number account_number, party.party_name party_name, party.jgzz_fiscal_code jgzz_fiscal_code, party.tax_reference tax_reference, cust_acct.cust_account_id customer_id , decode(al_fob.meaning, null, null, cust_acct.fob_point) fob_point, al_fob.meaning fob_point_meaning, decode(oft.description, null, null, cust_acct.ship_via) ship_via, oft.description ship_via_meaning, to_number( decode(ras.name, null, null, cust_acct.primary_salesrep_id) ) primary_salesrep_id, ras.name primary_salesrep_name, ras.salesrep_number primary_salesrep_num , cust_acct.account_name account_description from hz_cust_accounts cust_acct, hz_parties party, ra_salesreps ras, org_freight oft, ar_lookups al_fob where (ACCOUNT_NUMBER LIKE :1) AND ( cust_acct.party_id = party.party_id and cust_acct.ship_via = oft.freight_code(+) and :2 = organization_id(+) and cust_acct.fob_point = al_fob.lookup_code(+) and 'FOB' = al_fob.lookup_type(+) and 'Y' = al_fob.enabled_flag(+) and cust_acct.primary_salesrep_id = ras.salesrep_id(+) and :3 <= nvl(trunc(oft.disable_date(+)), :4) and :5 between al_fob.start_date_active (+) and nvl(al_fob.end_date_active(+), :6) and :7 between nvl(ras.start_date_active(+), :8) and nvl(ras.end_date_active, :9) and ( /* credit memos against specific transactions must have the same ship to customer as the transaction they are crediting. */ (cust_acct.cust_account_id = decode(:10, 'SHIP_TO', :11, 'BILL_TO', :12, :13)) or ( ( :14 is null or :15 != 'SHIP_TO' ) and nvl(cust_acct.status, 'A') = 'A' and nvl(party.category_code, 'CUSTOMER') != 'PROSPECT' and exists ( select 'site use exists' from hz_cust_Acct_sites acct_site where acct_site.cust_account_id = cust_acct.cust_account_id and acct_site.status = 'A' and ( ( :16 = 'SHIP_TO' and acct_site.ship_to_flag in ( 'Y', 'P') ) or (:17 = 'BILL_TO' and acct_site.bill_to_flag in ( 'Y', 'P') ) or (:18 = 'SOLD_TO'))))) ) order by decode(:19, 'NAME', party.party_name, cust_acct.account_number ), decode(:20, 'NAME', cust_acct.account_number, party.party_name )
8r13yd5kb4z0t	SELECT T.BILL_TO_SITE_USE_ID FROM RA_CUSTOMER_TRX T WHERE T.CUSTOMER_TRX_ID = :B1
98s59wa9rt0jx	SELECT T.ID, D.IGNORE_FOR_PLANNING FROM WSH_TMP T, WSH_NEW_DELIVERIES D WHERE D.DELIVERY_ID = T.ID AND NOT EXISTS ( SELECT WDA.DELIVERY_DETAIL_ID FROM WSH_DELIVERY_ASSIGNMENTS_V WDA, WSH_DELIVERY_DETAILS WDD WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WDA.DELIVERY_ID = T.ID AND WDA.DELIVERY_ID IS NOT NULL AND WDD.SOURCE_CODE <> 'OE' AND WDD.CONTAINER_FLAG = 'N') AND NOT EXISTS ( SELECT 1 FROM WSH_DELIVERY_LEGS WDL WHERE WDL.DELIVERY_ID = T.ID AND WDL.PARENT_DELIVERY_LEG_ID IS NOT NULL ) ORDER BY D.CREATION_DATE
9cz4wbnyvaz6j	INSERT INTO MSC_REGIONS_TEMP (SESSION_ID, PARTNER_SITE_ID, REGION_ID, REGION_TYPE, ZONE_FLAG, PARTNER_TYPE) SELECT DISTINCT :B5 , :B3 , A.REGION_ID, A.ZONE_LEVEL, :B6 , :B4 FROM WSH_REGIONS A, WSH_ZONE_REGIONS B, MSC_REGIONS_TEMP C WHERE A.REGION_ID = B.PARENT_REGION_ID AND A.REGION_TYPE = 10 AND A.ZONE_LEVEL IS NOT NULL AND B.REGION_ID = C.REGION_ID AND C.SESSION_ID = :B5 AND C.PARTNER_SITE_ID = DECODE(:B1 , :B4 , :B3 , :B2 ) AND C.PARTNER_TYPE = :B1
a14wcsg9mk8j3	WITH a as (SELECT a$.dbid, a$.snap_id, a$.INSTANCE_NUMBER, a$.PLSQL_ENTRY_OBJECT_ID, a$.PLSQL_ENTRY_SUBPROGRAM_ID, a$.PLSQL_OBJECT_ID, a$.PLSQL_SUBPROGRAM_ID, a$.TIME_MODEL FROM WRH$_ACTIVE_SESSION_HISTORY a$ WHERE a$.dbid = :dbid AND a$.instance_number = :inst AND a$.snap_id > :bid AND a$.snap_id <= :eid AND a$.session_type = 1 ) , ash as (SELECT cnt , PLSQL_OBJECT_ID, PLSQL_SUBPROGRAM_ID FROM ( SELECT count(*) as cnt , a.PLSQL_OBJECT_ID, a.PLSQL_SUBPROGRAM_ID FROM a WHERE bitand(a.time_model, power(2, 11 )) !=0 AND a.PLSQL_ENTRY_OBJECT_ID = :plsqleid AND a.PLSQL_ENTRY_SUBPROGRAM_ID = :plsqlesid GROUP BY PLSQL_OBJECT_ID, PLSQL_SUBPROGRAM_ID HAVING count(*) >= :rowcnt ORDER BY 1 DESC, 2 ASC ) WHERE rownum <= :ret) SELECT ash.plsql_object_id, ash.plsql_subprogram_id, dba.object_name, dba.object_type, dba.owner, dba.procedure_name, to_number(dba.overload), ash.cnt FROM dba_procedures dba, ash WHERE ash.plsql_object_id = dba.object_id(+) AND ash.plsql_subprogram_id = dba.subprogram_id(+) ORDER BY ash.cnt DESC, ash.plsql_object_id, ash.plsql_subprogram_id
aa6zd9qzswmpt	SELECT NVL(GSA_INDICATOR, 'N') FROM HZ_CUST_SITE_USES HSU WHERE SITE_USE_ID = :B2 AND HSU.ORG_ID = :B1
akdc5ap5258pd	SELECT LOOKUP_CODE FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = :B3 AND ORG_ID IN (:B2 , -99) AND ENABLED_FLAG = 'Y' AND (START_DATE_ACTIVE <= :B1 OR START_DATE_ACTIVE IS NULL) AND (END_DATE_ACTIVE >= :B1 OR END_DATE_ACTIVE IS NULL) AND ROWNUM = 1 ORDER BY ORG_ID DESC
bmvr0154yzvmv	SELECT MIN(CALENDAR_DATE), MAX(CALENDAR_DATE) FROM BOM_CALENDAR_DATES WHERE CALENDAR_CODE = :B1 AND SEQ_NUM IS NOT NULL
bxgr0u9qv23cv	SELECT ct.customer_trx_id, /* customer_trx_id */ ctl.customer_trx_line_id, /* customer_trx_line_id */ to_number(''), /* cust_trx_line_salesrep_id */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('REC', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, decode(:total_trx_amount, NULL, to_number(''), to_char( :total_trx_amount ) ) , to_number('')), /* line_amount */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('REC', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, decode(NULL, NULL, round((decode(:total_trx_amount, NULL, to_number(''), to_char( :total_trx_amount ) ) * nvl(ct.exchange_rate, 1)), 2), round((decode(:total_trx_amount, NULL, to_number(''), to_char( :total_trx_amount ) ) * nvl(ct.exchange_rate, 1)) / NULL) * NULL ), to_number('')), /* accounted_line_amount */ round( 100, 4), /* percent */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('REC', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, decode(:total_trx_amount, NULL, to_number(''), to_char( :total_trx_amount ) ) , to_number('') ), /* amount */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('REC', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, decode( NULL, NULL, round ((decode(:total_trx_amount, NULL, to_number(''), to_char( :total_trx_amount ) ) * nvl(ct.exchange_rate, 1)), 2), round((decode(:total_trx_amount, NULL, to_number(''), to_char( :total_trx_amount ) ) * nvl(ct.exchange_rate, 1)) / NULL ) * NULL ), to_number('')), /* acctd_amt */ 'REC', /* account class */ decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('REC', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, 'N', 'Y' ), /* account_set_flag */ ct.cust_trx_type_id, /* cust_trx_type_id */ decode(ct.invoicing_rule_id, -3, 'Y', 'N'), /* allow_not_open_flag */ to_char(''), /* concatenated segments */ to_number(''), /* code_combination_id */ to_char(rgd.gl_date, 'J'), /* gl_date */ decode( :original_gl_date, NULL, decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('REC', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, to_char(rgd.original_gl_date, 'J'), '' ), decode(decode( NVL(:force_account_set_no, 'N'), 'N', ct.invoicing_rule_id, decode('REC', 'UNBILL', ct.invoicing_rule_id, 'UNEARN', ct.invoicing_rule_id, decode(nvl(ctl.accounting_rule_duration, 0), 1, decode(nvl(ctl.autorule_duration_processed, 0), 0, ct.invoicing_rule_id, null), ct.invoicing_rule_id ) ) ), NULL, to_char(nvl(rgd.original_gl_date, :original_gl_date), 'J'), '' ) ), /* orig_gl_date */ nvl(ctl.default_ussgl_transaction_code, ct.default_ussgl_transaction_code), /* ussgl_trx_code */ nvl(ctl.default_ussg l_trx_code_context, ct.default_ussgl_trx_code_context), /* ussgl_trx_code_cntxt*/ ct.primary_salesrep_id, /* salesrep_id */ ctl.inventory_item_id, /* inventory_item_id */ ctl.memo_line_id, /* memo_line_id */ to_number(''), to_number(''), ct.bill_to_site_use_id, /* Billing site id */ ctl.warehouse_id /* Warehouse id */ , ctl.link_to_cust_trx_line_id /* 1651593 - tax errors */ FROM fnd_currencies fc_foreign, ra_cust_trx_line_gl_dist lgd, ra_cust_trx_line_gl_dist rgd, ra_customer_trx_lines ctl, ra_customer_trx ct WHERE ct.customer_trx_id = ctl.customer_trx_id(+) AND ct.invoice_currency_code = fc_foreign.currency_code /* prevent duplicate records from being created */ AND ct.customer_trx_id = lgd.customer_trx_id(+) AND 'REC' = lgd.account_class(+) AND decode(ct.invoicing_rule_id, NULL, 'N', 'Y' ) = lgd.account_set_flag(+) AND lgd.customer_trx_id is null AND ct.customer_trx_id = rgd.customer_trx_id(+) AND 'REC' = rgd.account_class(+) AND 'N' = rgd.account_set_flag(+) AND ctl.line_type (+) = '~!' and nvl(ct.invoicing_rule_id, -10) = nvl(ct.invoicing_rule_id, -10) AND ct.customer_trx_id = :customer_trx_id AND (ctl.customer_trx_line_id = :customer_trx_line_id OR ctl.link_to_cust_trx_line_id = :customer_trx_line_id) ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
cd4dpzrvancs3	SELECT TAX_CALCULATION_FLAG FROM RA_CUST_TRX_TYPES WHERE CUST_TRX_TYPE_ID = :B1
cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
drt9k4tpvph64	SELECT AR_TAX.LOCATION_SEGMENT_ID, AR_TAX.ORG_ID, AR_TAX.TAX_LINE_ID, AR_TAX.VAT_TAX_ID, AR_TAX.SET_OF_BOOKS_ID, NVL(AR_REC.GL_DATE, TRUNC(SYSDATE)) FROM RA_CUSTOMER_TRX_LINES AR_TAX, RA_CUST_TRX_LINE_GL_DIST AR_REC WHERE AR_TAX.CUSTOMER_TRX_LINE_ID = :B1 AND AR_TAX.CUSTOMER_TRX_ID = AR_REC.CUSTOMER_TRX_ID AND AR_REC.ACCOUNT_CLASS = 'REC' AND AR_REC.LATEST_REC_FLAG = 'Y'
fjvwzpxbpch0h	/* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STREAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
fmvtkwzyaz67m	SELECT C.CONSTRAINT_ID, C.ENTITY_ID , C.ON_OPERATION_ACTION, C.COLUMN_NAME FROM OE_PC_CONSTRAINTS C WHERE C.ENTITY_ID = :B3 AND C.CONSTRAINED_OPERATION = :B2 AND EXISTS ( SELECT 'EXISTS' FROM OE_PC_ASSIGNMENTS A WHERE A.CONSTRAINT_ID = C.CONSTRAINT_ID AND ( A.RESPONSIBILITY_ID = :B5 OR A.RESPONSIBILITY_ID IS NULL) AND ( A.APPLICATION_ID = :B4 OR A.APPLICATION_ID IS NULL) AND NOT EXISTS ( SELECT 'EXISTS' FROM OE_PC_EXCLUSIONS E WHERE E.RESPONSIBILITY_ID = :B5 AND E.ASSIGNMENT_ID = A.ASSIGNMENT_ID AND E.APPLICATION_ID = :B4 ) ) AND NVL(C.ENABLED_FLAG, 'Y') = 'Y' AND ((:B1 IS NULL) OR NVL(C.QUALIFIER_ATTRIBUTE, :B1 ) = :B1 ) ORDER BY C.ON_OPERATION_ACTION
fqa353m4t2gvs	SELECT 'x' FROM DUAL WHERE EXISTS ( SELECT /*+ ORDERED */ 'x' FROM QP_LIST_HEADER_PHASES LHP, QP_LIST_HEADERS_B QPLH WHERE LHP.PRICING_PHASE_ID = :B1 AND QPLH.LIST_HEADER_ID = LHP.LIST_HEADER_ID AND QPLH.ACTIVE_FLAG = 'Y') OR EXISTS ( SELECT /*+ ORDERED */ 'x' FROM QP_LIST_LINES QPLL, QP_LIST_HEADERS_B QPLH WHERE QPLL.PRICING_PHASE_ID = :B1 AND QPLL.QUALIFICATION_IND IN (0, 4, 20) AND QPLL.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.ACTIVE_FLAG = 'Y')
ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)
gpcbywvqvk1n8	SELECT 'Y' FROM OE_ORDER_HOLDS WHERE HEADER_ID = :B1 AND RELEASED_FLAG = 'N'
gyxv37z6aqyqp	SELECT P.PID, P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGUAGE'), INSTR( USERENV('LANGUAGE'), '.') + 1) FROM V$SESSION S, V$PROCESS P WHERE P.ADDR = S.PADDR AND S.AUDSID = USERENV('SESSIONID')

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: 2,201,103

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

No data exists for this section of the report.

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