WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
VIS	435804736	VIS	1	14-Sep-15 13:09	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dbzone3.priv.com	Solaris[tm] OE (64-bit)				.00

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	131	15-Sep-15 18:15:09	4927	31.4
End Snap:	135	15-Sep-15 19:15:17	1093	33.9
Elapsed:		60.13 (mins)
DB Time:		2,872.75 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	62,208M	62,208M	Std Block Size:	8K
Shared Pool Size:	16,384M	16,384M	Log Buffer:	172,632K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	47.8	0.2	0.00	0.00
DB CPU(s):	44.7	0.1	0.00	0.00
Redo size:	10,545,012.4	32,285.9
Logical reads:	993,458.5	3,041.7
Block changes:	70,992.5	217.4
Physical reads:	35.5	0.1
Physical writes:	1,259.1	3.9
User calls:	9,773.8	29.9
Parses:	6,498.0	19.9
Hard parses:	0.0	0.0
W/A MB processed:	196.5	0.6
Logons:	6.3	0.0
Executes:	55,483.1	169.9
Rollbacks:	7.3	0.0
Transactions:	326.6

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.19	Soft Parse %:	100.00
Execute to Parse %:	88.29	Latch Hit %:	89.83
Parse CPU to Parse Elapsd %:	50.68	% Non-Parse CPU:	95.50

Shared Pool Statistics

	Begin	End
Memory Usage %:	30.08	21.87
% SQL with executions>1:	95.20	95.10
% Memory for SQL w/exec>1:	94.73	94.74

Top 5 Timed Foreground Events

Host CPU (CPUs: Cores: Sockets: )

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):
SGA use (MB):	81,920.0	81,920.0
PGA use (MB):	51,623.7	6,021.5
% Host Mem used for SGA+PGA:

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): 172364.7s
• 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.4% of Total DB time 172,364.75 (s)
• Total FG Wait Time: 13,554.35 (s) DB CPU time: 161,201.06 (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 49.9% of Total DB Time (s): 172,365
• Captured PL/SQL account for 8.9% of Total DB Time (s): 172,365

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 50.5% of Total CPU Time (s): 161,201
• Captured PL/SQL account for 8.9% of Total CPU Time (s): 161,201

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

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: 3,584,360,481
• Captured SQL account for 45.1% 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: 128,130
• Captured SQL account for 0.0% 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,994
• Captured SQL account for 0.2% of Total
• Total UnOptimized Read Requests: 17,994
• Captured SQL account for 0.2% 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: 200,180,973
• Captured SQL account for 9.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 23,444,606
• Captured SQL account for 47.5% 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
02pt8xyb4az7w	select item, item_id, item_description, inventory_item_id, item_identifier_type, decode(item_identifier_type, :"SYS_B_0", :1, :"SYS_B_1", :2, item_identifier_type) item_identifier_type_meaning, inventory_item, Address, cust_address, item_definition_level , RANK from oe_items_v where ( UPPER(ITEM) LIKE :3 AND (ITEM LIKE :4 OR ITEM LIKE :5 OR ITEM LIKE :6 OR ITEM LIKE :7)) AND ( (sold_to_org_id = :8 or sold_to_org_id is null) and (item_status =:"SYS_B_2" or item_status IS NULL) and (cross_ref_status = :"SYS_B_3" or cross_ref_status IS NULL) ) order by item
02zf27p5upk26	SELECT /*+ NO_EXPAND ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) INDEX(QPLINES) INDEX(QPLATPR) index(QPPROD QP_PRICING_ATTRIBUTES_N5 ) index(qph QP_LIST_HEADERS_B_N7) */ QPL.LIST_HEADER_ID, QPL.LIST_LINE_ID, QPL.LIST_LINE_TYPE_CODE, QPLATPR.LINE_INDEX, QPLATPR.VALIDATED_FLAG, QPLATPR.APPLIED_FLAG, QPLATPR.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLATPR.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLATPR.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLATPR.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLATPR.VALUE_FROM PRODUCT_ATTR_VALUE, QPPROD.PRODUCT_ATTR_VALUE PRODUCT_SETUP_VALUE, QPLATPR.PRICING_ATTR_FLAG PRODUCT_PRICING_ATTR_FLAG, QPPROD.PRODUCT_UOM_CODE PRODUCT_UOM_CODE, QPPROD.EXCLUDER_FLAG, NULL QUALIFIER_GROUPING_NO, NULL QUALIFIER_PRECEDENCE, QPL.AUTOMATIC_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.PRIMARY_UOM_FLAG, QPL.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE, QPL.OPERAND OPERAND_VALUE, QPL.NET_AMOUNT_FLAG, QPL.PRICING_GROUP_SEQUENCE, QPH.ASK_FOR_FLAG, QPH.LIST_TYPE_CODE CREATED_FROM_LIST_TYPE, QPL.PRICING_PHASE_ID, QPL.PRICE_BREAK_TYPE_CODE, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.OVERRIDE_FLAG, QPL.BENEFIT_QTY, QPL.BENEFIT_UOM_CODE, QPL.LIST_LINE_NO, QPL.ACCRUAL_FLAG, QPL.ACCRUAL_CONVERSION_RATE, QPL.ESTIM_ACCRUAL_RATE, QPH.LIMIT_EXISTS_FLAG HEADER_LIMIT_EXISTS, QPL.LIMIT_EXISTS_FLAG LINE_LIMIT_EXISTS, 'NQ' QUALIFIER_TYPE, QPL.CHARGE_TYPE_CODE, QPL.CHARGE_SUBTYPE_CODE, QPL.ACCUM_CONTEXT, QPL.ACCUM_ATTRIBUTE, QPL.ACCUM_ATTR_RUN_SRC_FLAG FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLATPR, QP_PRICING_ATTRIBUTES QPPROD , QP_LIST_HEADERS_B QPH , QP_LIST_LINES QPL , QP_PRICE_REQ_SOURCES_V QPRS WHERE (QPLINES.PRICE_FLAG = :B1 OR (QPLINES.PRICE_FLAG = :B16 AND :B15 = :B1 )) AND QPH.LIST_HEADER_ID = QPPROD.LIST_HEADER_ID AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE) OR QPH.CURRENCY_CODE IS NULL) AND (QPLINES.UNIT_PRICE IS NOT NULL OR QPLINES.USAGE_PRICING_TYPE = :B14 OR QPLINES.LINE_TYPE_CODE = :B13 ) AND (QPL.MODIFIER_LEVEL_CODE = QPLINES.LINE_TYPE_CODE OR (QPL.MODIFIER_LEVEL_CODE = :B12 AND NVL(:B3 , :B2 ) <> :B1 )) AND QPH.ACTIVE_FLAG = :B1 AND ((QPH.ASK_FOR_FLAG = :B1 AND EXISTS (SELECT /*+ index(la QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' FROM QP_NPREQ_LINE_ATTRS_TMP LA WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B9 AND VALIDATED_FLAG = :B2 AND LIST_HEADER_ID = QPH.LIST_HEADER_ID AND LINE_INDEX = QPLINES.LINE_INDEX)) OR QPH.ASK_FOR_FLAG = :B2 ) AND QPL.LIST_LINE_ID = QPPROD.LIST_LINE_ID AND NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE_FIRST, NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE_FIRST, NVL(QPLINES.START_DATE_ACTIVE_FIRST, TRUNC(SYSDATE))) AND NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE)) BETWEEN NVL(QPH.START_DATE_ACTIVE_SECOND, NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE))) AND NVL(QPH.END_DATE_ACTIVE_SECOND, NVL(QPLINES.START_DATE_ACTIVE_SECOND, TRUNC(SYSDATE))) AND NVL(QPLINES.ACTIVE_DATE_FIRST_TYPE, 'X') = NVL(QPH.ACTIVE_DATE_FIRST_TYPE, NVL(QPLINES.ACTIVE_DATE_FIRST_TYPE, 'X')) AND NVL(QPLINES.ACTIVE_DATE_SECOND_TYPE, 'X') = NVL(QPH.ACTIVE_DATE_SECOND_TYPE, NVL(QPLINES.ACTIVE_DATE_SECOND_TYPE, 'X')) AND NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE)) BETWEEN NVL(QPL.START_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND NVL(QPL.END_DATE_ACTIVE, NVL(QPLINES.PRICING_EFFECTIVE_DATE, TRUNC(SYSDATE))) AND QPLINES.PRICED_UOM_CODE = NVL(QPPROD.PRODUCT_UOM_CODE, QPLINES.PRICED_UOM_CODE) AND QPPROD.PRICING_PHASE_ID = :B11 AND QPPROD.QUALIFICATION_IND = :B10 AND QPPROD.PRODUCT_ATTRIBUTE_CONTEXT = QPLATPR.CONTEXT AND QPPROD.PRODUCT_ATTRIBUTE = QPLATP R.ATTRIBUTE AND QPPROD.PRODUCT_ATTR_VALUE = QPLATPR.VALUE_FROM AND QPPROD.EXCLUDER_FLAG = :B2 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPLATPR.LINE_INDEX = QPLINES.LINE_INDEX AND QPLATPR.ATTRIBUTE_TYPE='PRODUCT' AND QPLATPR.PRICING_STATUS_CODE=:B9 AND (NVL(:B3 , :B2 ) = :B1 AND QPL.LIST_LINE_TYPE_CODE NOT IN (:B8 , :B7 , :B6 , :B5 , :B4 ) OR NVL(:B3 , :B2 ) <> :B1 ) ORDER BY 4, 2
055x7wdzkktkt	SELECT 'x' FROM DUAL WHERE EXISTS(SELECT 'x' FROM OE_ORDER_LINES WHERE HEADER_ID = :B1 AND CALCULATE_PRICE_FLAG IN ('Y', 'P') AND ITEM_TYPE_CODE NOT IN ('CONFIG', 'INCLUDED'))
0bujgc94rg3fj	begin WF_EVENT.setNavigationParams ( p_agentName => :1, p_navigationThreshold => :2 ); WF_EVENT.LISTEN ( p_agent_name => :3, p_wait => :4, p_correlation => :5, p_deq_condition => null, p_message_count => :6, p_max_error_count => :7 );end;
0hfaqhz3gz1zw	SELECT DISTINCT PROFILE_CLASS_ID FROM HZ_CUSTOMER_PROFILES WHERE CUST_ACCOUNT_ID = :B1
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
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
3mbz7cvyf9cz3	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4d99rhcwdfgp0	begin :v1 := WF_XML.Send_Rule(:v2, :v3); end;
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;
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;
6xusmw3vc1xny	SELECT MIN(CALENDAR_DATE), MAX(CALENDAR_DATE) FROM BOM_CALENDAR_DATES CAL, MTL_PARAMETERS ORG WHERE CAL.CALENDAR_CODE = ORG.CALENDAR_CODE AND CAL.EXCEPTION_SET_ID = ORG.CALENDAR_EXCEPTION_SET_ID AND ORG.ORGANIZATION_ID = :B1 AND CAL.SEQ_NUM IS NOT NULL
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
9zuxp618k86n4	SELECT MTL_MSI.BOM_ITEM_TYPE , MTL_MSI.REPLENISH_TO_ORDER_FLAG , MTL_MSI.CONFIG_MODEL_TYPE FROM MTL_SYSTEM_ITEMS MTL_MSI WHERE MTL_MSI.INVENTORY_ITEM_ID = :B2 AND MTL_MSI.ORGANIZATION_ID=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID', :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
aw21gc59tbcnr	SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID , NULL IS_RESERVABLE_LOT FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL, X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DETAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT ( :B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) ) ) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS) , 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS) , 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSACTION_ACTION_ID, TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBIN VENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34)) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID, 3, MMTT.TRANSFER_ORGANIZATION, MMTT.ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND DECODE( NVL(MMTT.TRANSACTION_STATUS, 0), 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 2), 1 ) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ( (:B11 = 1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID
bmvr0154yzvmv	SELECT MIN(CALENDAR_DATE), MAX(CALENDAR_DATE) FROM BOM_CALENDAR_DATES WHERE CALENDAR_CODE = :B1 AND SEQ_NUM IS NOT NULL
cd4dpzrvancs3	SELECT TAX_CALCULATION_FLAG FROM RA_CUST_TRX_TYPES WHERE CUST_TRX_TYPE_ID = :B1
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')
gpcbywvqvk1n8	SELECT 'Y' FROM OE_ORDER_HOLDS WHERE HEADER_ID = :B1 AND RELEASED_FLAG = 'N'

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: 4,542,655

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

Back to Wait Statistics
Back to Top

Enqueue Activity

• only enqueues with waits are shown
• Enqueue stats gathered prior to 10g should not be compared with 10g data
• ordered by Wait Time desc, Waits desc

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