WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
PROD	215918786	PROD	1	09-Feb-15 10:02	11.2.0.3.0	NO

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

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	19216	24-Mar-15 00:00:11	137	18.4
End Snap:	19235	24-Mar-15 19:00:17	140	18.7
Elapsed:		1,140.11 (mins)
DB Time:		603.13 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	4,512M	4,512M	Std Block Size:	8K
Shared Pool Size:	3,200M	3,200M	Log Buffer:	12,880K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.5	0.3	0.01	0.05
DB CPU(s):	0.5	0.3	0.01	0.04
Redo size:	6,057.2	3,547.5
Logical reads:	9,136.6	5,351.0
Block changes:	35.2	20.6
Physical reads:	15.5	9.1
Physical writes:	8.2	4.8
User calls:	11.7	6.9
Parses:	1.7	1.0
Hard parses:	0.1	0.0
W/A MB processed:	0.3	0.2
Logons:	0.1	0.0
Executes:	79.8	46.8
Rollbacks:	1.2	0.7
Transactions:	1.7

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.95	In-memory Sort %:	100.00
Library Hit %:	99.94	Soft Parse %:	96.88
Execute to Parse %:	97.90	Latch Hit %:	99.93
Parse CPU to Parse Elapsd %:	54.08	% Non-Parse CPU:	98.67

Shared Pool Statistics

	Begin	End
Memory Usage %:	87.86	87.71
% SQL with executions>1:	98.78	98.77
% Memory for SQL w/exec>1:	98.14	98.21

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.34	1.18	0.3	0.7	0.0	99.0

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	65,024.0	65,024.0
SGA use (MB):	8,000.0	8,000.0
PGA use (MB):	717.3	730.9
% Host Mem used for SGA+PGA:	13.41	13.43

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): 36187.8s
• 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 100.0% of Total DB time 36,187.81 (s)
• Total FG Wait Time: 1,263.43 (s) DB CPU time: 34,926.05 (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 81.3% of Total DB Time (s): 36,188
• Captured PL/SQL account for 35.3% of Total DB Time (s): 36,188

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 82.3% of Total CPU Time (s): 34,926
• Captured PL/SQL account for 35.5% of Total CPU Time (s): 34,926

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

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: 625,003,294
• Captured SQL account for 99.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 1,062,814
• Captured SQL account for 81.9% 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: 199,314
• Captured SQL account for 78.9% of Total
• Total UnOptimized Read Requests: 199,314
• Captured SQL account for 78.9% 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: 5,461,689
• Captured SQL account for 71.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 114,738
• Captured SQL account for 29.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
01vct3dyfzytu	/*begin fnd_global.APPS_INITIALIZE(1885, 50674, 20003); mo_global.init('M'); end;*/ SELECT --nvl(rctla.attribute1, '无') vendor_name, rctla.attribute1 vendor_name, rcta.interface_header_attribute6 exe_number, rcta.interface_header_attribute14 contact_number, flvv.DESCRIPTION city, moact.organization_id, sum(rctla.quantity_invoiced * UNIT_SELLING_PRICE) amount FROM Ra_Customer_Trx_All rcta, RA_CUSTOMER_TRX_LINES_ALL rctla, RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd, gl_code_combinations gcc, FND_FLEX_VALUES_VL flvv, FND_FLEX_VALUE_SETS flvs, AR_MEMO_LINES_ALL_VL amla, mo_glob_org_access_tmp moact---Added By Hand@20150323 parameter p_org_Id is optional where 1 = 1 and rctla.customer_trx_id = rcta.customer_trx_id and rctlgd.customer_trx_line_id = rctla.customer_trx_line_id and rctlgd.customer_trx_id = rcta.customer_trx_id and rctlgd.code_combination_id = gcc.code_combination_id and flvv.FLEX_VALUE_SET_ID = flvs.flex_value_set_id and flvs.flex_value_set_name = 'SOHU_GL_BL' and flvv.FLEX_VALUE = gcc.segment6 --and rcta.org_id = p_org_id---Remarked By Hand@20150323 parameter p_org_Id is optional /*and rcta.trx_date BETWEEN nvl(l_begin_date, rcta.trx_date) AND nvl(l_end_date, rcta.trx_date)*/ ----验证行上的OP信息，只是去OP的金额 AND rctla.memo_line_id = amla.memo_line_id and amla.NAME like 'OP%' and rcta.complete_flag = 'Y' ---and rcta.trx_number = 'JS14-FC00527#001-4' ---Added By Hand@20150323 parameter p_org_Id is optional<Begin> and moact.organization_id = rcta.org_id and (moact.organization_id = NULL or NULL is null) ---Added By Hand@20150323 parameter p_org_Id is optional<Begin> and exists (SELECT 1 FROM RA_CUSTOMER_TRX_LINES_ALL rctl, AR_MEMO_LINES_ALL_VL arml where 1 = 1 and rctl.customer_trx_id = rcta.customer_trx_id AND arml.memo_line_id = rctl.memo_line_id and arml.NAME like 'OP%') group by moact.organization_id, moact.organization_name , --Added By Hand@20150323 rctla.attribute1, rcta.interface_header_attribute6, rcta.interface_header_attribute14, flvv.DESCRIPTION order by moact.organization_id , --Added By Hand@20150323 --nvl(rctla.attribute1, '无') desc; rctla.attribute1
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0q8w0cndsp865	SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID
0ss0h0ws2nfcb	select crm_line_id as id, line_number as collectionNumber, contract_number as contractnum, bill_number as projectnumber, apply_amount as collectionPrice, cash_com as ou, apply_gl_date as glTime, receipt_type as receiptMethod, receipt_number as erpCollectId, status as ebsStatus from cux_cm_line_rev_tv where Last_update_date >= to_date(:1 , 'yyyy-mm-dd hh24:mi:ss') and Last_update_date < to_date(:2 , 'yyyy-mm-dd hh24:mi:ss')
0wmwsjy9kd92f	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
15f8d2k3qf6nd	SELECT ASSET_NUMBER, DESCRIPTION, TAG_NUMBER, SERIAL_NUMBER, ASSET_TYPE, CURRENT_UNITS, PARENT_ASSET, PARENT_DESCRIPTION, ATTRIBUTE15, MANUFACTURER_NAME, MODEL_NUMBER, LEASE_NUMBER, LESSOR, LEASE_DESC, PROPERTY_TYPE_CODE, PROPERTY_TYPE_MEANING, OWNED_LEASED, PROPERTY_1245_1250_CODE, PROPERTY_1245_1250_MEANING, NEW_USED, IN_USE_FLAG, INVENTORIAL, ROW_ID, ASSET_ID, ASSET_KEY_CCID, ASSET_CATEGORY_ID, PARENT_ASSET_ID, LEASE_ID, UNIT_ADJUSTMENT_FLAG, ADD_COST_JE_FLAG, CATEGORY_TYPE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, CONTEXT, LS_ATTRIBUTE1, LS_ATTRIBUTE2, LS_ATTRIBUTE3, LS_ATTRIBUTE4, LS_ATTRIBUTE5, LS_ATTRIBUTE6, LS_ATTRIBUTE7, LS_ATTRIBUTE8, LS_ATTRIBUTE9, LS_ATTRIBUTE10, LS_ATTRIBUTE11, LS_ATTRIBUTE12, LS_ATTRIBUTE13, LS_ATTRIBUTE14, LS_ATTRIBUTE15, LS_ATTRIBUTE_CATEGORY_CODE FROM FA_ADDITIONS_V WHERE ((:1 is null) or (:2 = 'N' and asset_type <> 'GROUP')) AND -1=-1 and (ASSET_ID in (select ASSET_ID from FA_BOOKS where DATE_PLACED_IN_SERVICE >= to_date('2013/03/24 00:00:00', 'YYYY/MM/DD HH24:MI:SS') and NVL(DISABLED_FLAG, 'N') = 'N' and transaction_header_id_out is null)) order by asset_number
1dch842bm0bq3	SELECT /* DS_SVC */ /*+ cursor_sharing_exact dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) OPT_ESTIMATE(@"innerQuery", TABLE, "FDS", SCALE_ROWS=9.809991864) */ C1, C2, C3 FROM (SELECT /*+ qb_name("innerQuery") INDEX( "FDS" "FA_DEPRN_SUMMARY_N1") */ COUNT(*) AS C1, 4294967295 AS C2, COUNT(*) AS C3 FROM "FA"."FA_DEPRN_SUMMARY" "FDS" WHERE ("FDS"."BOOK_TYPE_CODE"=:B1) AND ("FDS"."BOOK_TYPE_CODE"=:B2)) innerQuery
2450j0nxcnga5	declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end;
298dybjj1k8b7	SELECT B.JE_BATCH_ID, B.NAME BATCH_NAME, B.APPROVAL_STATUS_CODE, B.CONTROL_TOTAL, B.RUNNING_TOTAL_DR, B.RUNNING_TOTAL_CR, H.JE_HEADER_ID, H.NAME JE_NAME, H.CURRENCY_CODE, (SELECT SUM(L.ENTERED_DR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_DR, (SELECT SUM(L.ENTERED_CR) FROM GL_JE_LINES L WHERE L.JE_HEADER_ID = H.JE_HEADER_ID) ENTERED_CR, CU.FULL_NAME CREATED_NAME, PE.FULL_NAME APPROVED_NAME FROM HR_EMPLOYEES PE, CUX_USER_EMPLOYEES_V CU, GL_JE_CATEGORIES C, GL_JE_SOURCES S, GL_JE_BATCHES B, GL_JE_HEADERS H WHERE PE.EMPLOYEE_ID(+) = B.APPROVER_EMPLOYEE_ID AND CU.USER_ID(+) = B.CREATED_BY AND B.JE_BATCH_ID(+) = H.JE_BATCH_ID AND H.JE_SOURCE = S.JE_SOURCE_NAME AND H.JE_CATEGORY = C.JE_CATEGORY_NAME AND B.STATUS <> 'P' AND H.LEDGER_ID = :B10 AND S.JE_SOURCE_NAME = NVL(:B9 , S.JE_SOURCE_NAME) AND H.JE_CATEGORY = NVL(:B8 , H.JE_CATEGORY) AND H.DEFAULT_EFFECTIVE_DATE >= :B7 AND H.DEFAULT_EFFECTIVE_DATE <= :B6 AND B.NAME >= NVL(:B5 , B.NAME) AND B.NAME <= NVL(:B4 , B.NAME) AND B.CREATED_BY = NVL(:B3 , B.CREATED_BY) AND ((:B2 IS NOT NULL AND B.APPROVER_EMPLOYEE_ID = B.APPROVER_EMPLOYEE_ID) OR :B2 IS NULL) AND (:B1 = 'Y' OR (:B1 = 'N' AND EXISTS (SELECT 1 FROM GL_CODE_COMBINATIONS GCC, GL_JE_LINES L, CUX_ACCESS_LEDGER_SEGMENT_V SV WHERE GCC.CODE_COMBINATION_ID = L.CODE_COMBINATION_ID AND L.JE_HEADER_ID = H.JE_HEADER_ID AND GCC.SEGMENT1 >= NVL(:B15 , GCC.SEGMENT1) AND GCC.SEGMENT1 <= NVL(:B14 , GCC.SEGMENT1) AND GCC.SEGMENT2 >= NVL(:B13 , GCC.SEGMENT2) AND GCC.SEGMENT2 >= NVL(:B12 , GCC.SEGMENT2) AND GCC.SEGMENT1 = SV.SEGMENT_VALUE AND SV.ACCESS_SET_ID = :B11 AND SV.LEDGER_ID = :B10 ))) AND EXISTS (SELECT 'Y' FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES_VL R, FND_FLEX_VALUE_RULE_USAGES U, GL_CODE_COMBINATIONS GCC, GL_JE_LINES JL WHERE GCC.CODE_COMBINATION_ID = JL.CODE_COMBINATION_ID AND JL.JE_HEADER_ID = H.JE_HEADER_ID AND L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND R.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID AND U.RESPONSIBILITY_ID = :B16 AND U.FLEX_VALUE_SET_ID = 1014862 AND ((L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND GCC.SEGMENT2 >= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 <= L.FLEX_VALUE_HIGH) OR (L.INCLUDE_EXCLUDE_INDICATOR = 'E' AND GCC.SEGMENT2 <= L.FLEX_VALUE_LOW AND GCC.SEGMENT2 >= L.FLEX_VALUE_HIGH))) ORDER BY B.NAME, H.NAME
2sjraytcfcv2n	SELECT /*+ USE_NL (A B I) */ DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME, B.APPLICATION_SHORT_NAME, B.BASEPATH, I.PRODUCT_VERSION FROM FND_APPLICATION_TL A, FND_APPLICATION B, FND_PRODUCT_INSTALLATIONS I WHERE A.APPLICATION_ID = I.APPLICATION_ID (+) AND A.APPLICATION_ID = B.APPLICATION_ID AND A.LANGUAGE = USERENV ('LANG')
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4k39vs96wx3bx	SELECT NVL(RCTLA.ATTRIBUTE1, '无') VENDOR_NAME, RCTA.INTERFACE_HEADER_ATTRIBUTE6 EXE_NUMBER, RCTA.INTERFACE_HEADER_ATTRIBUTE14 CONTACT_NUMBER, FLVV.DESCRIPTION CITY, MOACT.ORGANIZATION_ID, SUM(RCTLA.QUANTITY_INVOICED * UNIT_SELLING_PRICE) AMOUNT FROM RA_CUSTOMER_TRX_ALL RCTA, RA_CUSTOMER_TRX_LINES_ALL RCTLA, RA_CUST_TRX_LINE_GL_DIST_ALL RCTLGD, GL_CODE_COMBINATIONS GCC, FND_FLEX_VALUES_VL FLVV, FND_FLEX_VALUE_SETS FLVS, AR_MEMO_LINES_ALL_VL AMLA, MO_GLOB_ORG_ACCESS_TMP MOACT WHERE 1 = 1 AND RCTLA.CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID AND RCTLGD.CUSTOMER_TRX_LINE_ID = RCTLA.CUSTOMER_TRX_LINE_ID AND RCTLGD.CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID AND RCTLGD.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID AND FLVV.FLEX_VALUE_SET_ID = FLVS.FLEX_VALUE_SET_ID AND FLVS.FLEX_VALUE_SET_NAME = 'SOHU_GL_BL' AND FLVV.FLEX_VALUE = GCC.SEGMENT6 AND RCTA.TRX_DATE BETWEEN NVL(:B3 , RCTA.TRX_DATE) AND NVL(:B2 , RCTA.TRX_DATE) AND RCTLA.MEMO_LINE_ID = AMLA.MEMO_LINE_ID AND AMLA.NAME LIKE 'OP%' AND RCTA.COMPLETE_FLAG = 'Y' AND MOACT.ORGANIZATION_ID = RCTA.ORG_ID AND (MOACT.ORGANIZATION_ID = :B1 OR :B1 IS NULL) AND EXISTS (SELECT 1 FROM RA_CUSTOMER_TRX_LINES_ALL RCTL, AR_MEMO_LINES_ALL_VL ARML WHERE 1 = 1 AND RCTL.CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID AND ARML.MEMO_LINE_ID = RCTL.MEMO_LINE_ID AND ARML.NAME LIKE 'OP%') GROUP BY MOACT.ORGANIZATION_ID, MOACT.ORGANIZATION_NAME , RCTLA.ATTRIBUTE1, RCTA.INTERFACE_HEADER_ATTRIBUTE6, RCTA.INTERFACE_HEADER_ATTRIBUTE14, FLVV.DESCRIPTION ORDER BY MOACT.ORGANIZATION_ID , NVL(RCTLA.ATTRIBUTE1, '无') DESC
4n7s0m8m97msa	BEGIN cux_hr_emp_sync_pvt.main(:errbuf, :rc); END;
4sbp5w6qdgscf	SELECT GCC.SEGMENT4 FROM GL_CODE_COMBINATIONS_KFV GCC WHERE GCC.CONCATENATED_SEGMENTS = :B1
4twxwvtqj9188	SELECT DATA_LENGTH FROM ALL_TAB_COLUMNS WHERE OWNER = 'SYS' AND TABLE_NAME = 'V_$SESSION' AND COLUMN_NAME = :B1
54a4zuhrmappy	INSERT INTO XLA_EVENTS_INT_GT (EVENT_ID, EVENT_STATUS_CODE, APPLICATION_ID, LEDGER_ID, ENTITY_CODE, VALUATION_METHOD) SELECT /*+ leading(ev) use_nl(EV TE TH BC) full(ev) index(TE XLA_TRANSACTION_ENTITIES_U1) */ EV.EVENT_ID, 'N', 140, BC.SET_OF_BOOKS_ID, 'TRANSACTIONS', BC.BOOK_TYPE_CODE FROM XLA_TRANSACTION_ENTITIES TE, XLA_EVENTS EV, FA_TRANSACTION_HEADERS TH, FA_BOOK_CONTROLS BC WHERE TE.APPLICATION_ID = :B1 AND TE.LEDGER_ID = :B3 AND TE.ENTITY_CODE = 'TRANSACTIONS' AND TE.VALUATION_METHOD = NVL(:B2 , TE.VALUATION_METHOD) AND EV.APPLICATION_ID = :B1 AND EV.PROCESS_STATUS_CODE IN ('U', 'I', 'E') AND EV.EVENT_STATUS_CODE = 'U' AND EV.EVENT_TYPE_CODE <> 'INFLATION_REVALUATION' AND EV.ENTITY_ID = TE.ENTITY_ID AND TH.TRANSACTION_HEADER_ID = TE.SOURCE_ID_INT_1 AND BC.BOOK_TYPE_CODE = TE.SOURCE_ID_CHAR_1 AND BC.SET_OF_BOOKS_ID = TE.LEDGER_ID AND NOT EXISTS (SELECT /*+ no_unnest */ 1 FROM FA_ADJUSTMENTS ADJ WHERE ADJ.TRANSACTION_HEADER_ID = TH.TRANSACTION_HEADER_ID AND ADJ.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND ADJ.ADJUSTMENT_AMOUNT <> 0 AND NVL(ADJ.TRACK_MEMBER_FLAG, 'N') <> 'Y')
55dc767ajydh3	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
5t39uchjqpyfm	BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;
5tmm78yt172tw	select distinct role_name from wf_user_roles where user_name = :1 or (user_name = (select name from wf_local_roles wlr, fnd_user fusr where fusr.person_party_id = wlr.orig_system_id and wlr.orig_system = 'HZ_PARTY' and fusr.user_name = :2 and rownum < 2)) and role_name <> user_name
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5yyubbyjhg55z	SELECT RCTLA.ATTRIBUTE1 VENDOR_NAME, RCTA.INTERFACE_HEADER_ATTRIBUTE6 EXE_NUMBER, RCTA.INTERFACE_HEADER_ATTRIBUTE14 CONTACT_NUMBER, FLVV.DESCRIPTION CITY, MOACT.ORGANIZATION_ID, SUM(RCTLA.QUANTITY_INVOICED * UNIT_SELLING_PRICE) AMOUNT FROM RA_CUSTOMER_TRX_ALL RCTA, RA_CUSTOMER_TRX_LINES_ALL RCTLA, RA_CUST_TRX_LINE_GL_DIST_ALL RCTLGD, GL_CODE_COMBINATIONS GCC, FND_FLEX_VALUES_VL FLVV, FND_FLEX_VALUE_SETS FLVS, AR_MEMO_LINES_ALL_VL AMLA, MO_GLOB_ORG_ACCESS_TMP MOACT WHERE 1 = 1 AND RCTLA.CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID AND RCTLGD.CUSTOMER_TRX_LINE_ID = RCTLA.CUSTOMER_TRX_LINE_ID AND RCTLGD.CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID AND RCTLGD.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID AND FLVV.FLEX_VALUE_SET_ID = FLVS.FLEX_VALUE_SET_ID AND FLVS.FLEX_VALUE_SET_NAME = 'SOHU_GL_BL' AND FLVV.FLEX_VALUE = GCC.SEGMENT6 AND RCTA.TRX_DATE BETWEEN NVL(:B3 , RCTA.TRX_DATE) AND NVL(:B2 , RCTA.TRX_DATE) AND RCTLA.MEMO_LINE_ID = AMLA.MEMO_LINE_ID AND AMLA.NAME LIKE 'OP%' AND RCTA.COMPLETE_FLAG = 'Y' AND MOACT.ORGANIZATION_ID = RCTA.ORG_ID AND (MOACT.ORGANIZATION_ID = :B1 OR :B1 IS NULL) AND EXISTS (SELECT 1 FROM RA_CUSTOMER_TRX_LINES_ALL RCTL, AR_MEMO_LINES_ALL_VL ARML WHERE 1 = 1 AND RCTL.CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID AND ARML.MEMO_LINE_ID = RCTL.MEMO_LINE_ID AND ARML.NAME LIKE 'OP%') GROUP BY MOACT.ORGANIZATION_ID, MOACT.ORGANIZATION_NAME , RCTLA.ATTRIBUTE1, RCTA.INTERFACE_HEADER_ATTRIBUTE6, RCTA.INTERFACE_HEADER_ATTRIBUTE14, FLVV.DESCRIPTION ORDER BY MOACT.ORGANIZATION_ID , RCTLA.ATTRIBUTE1 DESC
5zruc4v6y32f9	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
656sk77p7a7qs	Declare l_flag Boolean; BEGIN l_flag := XLA_CREATE_ACCT_RPT_PVT.BeforeReport ; if (l_flag) then :XDO_OUT_PARAMETER := 1; end if; end;
67xv3hzvw1wsu	SELECT SUM(AIDA.AMOUNT * (NVL((SELECT NVL(SUM(AVP.PREPAY_AMOUNT_APPLIED), 0) FROM AP_VIEW_PREPAYS_V AVP WHERE (AVP.INVOICE_ID = AIA.INVOICE_ID) AND (AVP.INVOICE_ID = AIA.INVOICE_ID) AND (AVP.VENDOR_ID = AIA.VENDOR_ID) AND AVP.ACCOUNTING_DATE BETWEEN NVL(:B3 , AVP.ACCOUNTING_DATE) AND NVL(:B2 , AVP.ACCOUNTING_DATE)) + (SELECT NVL(SUM(AIP.AMOUNT), 0) FROM AP_INVOICE_PAYMENTS_ALL AIP WHERE AIP.ACCOUNTING_DATE BETWEEN NVL(:B3 , AIP.ACCOUNTING_DATE) AND NVL(:B2 , AIP.ACCOUNTING_DATE) AND AIP.INVOICE_ID = AIA.INVOICE_ID), AIA.INVOICE_AMOUNT) / AIA.INVOICE_AMOUNT)) REMAING_AMOUNT, AILA.ATTRIBUTE6 ORDER_NUMBER, AILA.ATTRIBUTE7 RELATE_VENDOR_NAME, FLVV.DESCRIPTION CITY, MOACT.ORGANIZATION_ID FROM AP_INVOICES_ALL AIA, AP_INVOICE_DISTRIBUTIONS_ALL AIDA, AP_INVOICE_LINES_ALL AILA, GL_CODE_COMBINATIONS GCC, FND_FLEX_VALUES_VL FLVV, FND_FLEX_VALUE_SETS FLVS, MO_GLOB_ORG_ACCESS_TMP MOACT WHERE 1 = 1 AND AILA.INVOICE_ID = AIA.INVOICE_ID AND AIA.INVOICE_ID = AIDA.INVOICE_ID AND AIDA.INVOICE_LINE_NUMBER = AILA.LINE_NUMBER AND AIDA.DIST_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID AND AP_INVOICES_PKG.GET_APPROVAL_STATUS(AIA.INVOICE_ID, AIA.INVOICE_AMOUNT, AIA.PAYMENT_STATUS_FLAG, AIA.INVOICE_TYPE_LOOKUP_CODE) IN ('APPROVED') AND GCC.SEGMENT4 = '25105' AND GCC.SEGMENT7 = 'F200' AND FLVV.FLEX_VALUE_SET_ID = FLVS.FLEX_VALUE_SET_ID AND FLVS.FLEX_VALUE_SET_NAME = 'SOHU_GL_BL' AND FLVV.FLEX_VALUE = GCC.SEGMENT6 AND (EXISTS (SELECT 1 FROM AP_INVOICE_PAYMENTS_ALL AIP WHERE 1 = 1 AND AIP.ACCOUNTING_DATE BETWEEN NVL(:B3 , AIP.ACCOUNTING_DATE) AND NVL(:B2 , AIP.ACCOUNTING_DATE) AND AIP.INVOICE_ID = AIA.INVOICE_ID) OR EXISTS (SELECT 1 FROM AP_VIEW_PREPAYS_V AVP WHERE (AVP.INVOICE_ID = AIA.INVOICE_ID) AND (AVP.INVOICE_ID = AIA.INVOICE_ID) AND (AVP.VENDOR_ID = AIA.VENDOR_ID) AND AVP.ACCOUNTING_DATE BETWEEN NVL(:B3 , AVP.ACCOUNTING_DATE) AND NVL(:B2 , AVP.ACCOUNTING_DATE))) AND MOACT.ORGANIZATION_ID = AIA.ORG_ID AND (MOACT.ORGANIZATION_ID = :B1 OR :B1 IS NULL) GROUP BY MOACT.ORGANIZATION_ID, AILA.ATTRIBUTE6, AILA.ATTRIBUTE7, FLVV.DESCRIPTION ORDER BY AILA.ATTRIBUTE7 DESC
6842742n5dmp6	SELECT DECODE(:B4 , 0, FLV.MEANING, FLV.DESCRIPTION) FROM FND_LOOKUP_VALUES_VL FLV WHERE (FLV.VIEW_APPLICATION_ID = :B3 OR :B3 IS NULL) AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE, FLV.VIEW_APPLICATION_ID) AND FLV.LOOKUP_TYPE = :B2 AND FLV.LOOKUP_CODE = :B1
6mcpb06rctk0x	call dbms_space.auto_space_advisor_job_proc ( )
6u0g70q4fv48u	SELECT ASSET_NUMBER, DESCRIPTION, TAG_NUMBER, SERIAL_NUMBER, ASSET_TYPE, CURRENT_UNITS, PARENT_ASSET, PARENT_DESCRIPTION, ATTRIBUTE15, MANUFACTURER_NAME, MODEL_NUMBER, LEASE_NUMBER, LESSOR, LEASE_DESC, PROPERTY_TYPE_CODE, PROPERTY_TYPE_MEANING, OWNED_LEASED, PROPERTY_1245_1250_CODE, PROPERTY_1245_1250_MEANING, NEW_USED, IN_USE_FLAG, INVENTORIAL, ROW_ID, ASSET_ID, ASSET_KEY_CCID, ASSET_CATEGORY_ID, PARENT_ASSET_ID, LEASE_ID, UNIT_ADJUSTMENT_FLAG, ADD_COST_JE_FLAG, CATEGORY_TYPE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, CONTEXT, LS_ATTRIBUTE1, LS_ATTRIBUTE2, LS_ATTRIBUTE3, LS_ATTRIBUTE4, LS_ATTRIBUTE5, LS_ATTRIBUTE6, LS_ATTRIBUTE7, LS_ATTRIBUTE8, LS_ATTRIBUTE9, LS_ATTRIBUTE10, LS_ATTRIBUTE11, LS_ATTRIBUTE12, LS_ATTRIBUTE13, LS_ATTRIBUTE14, LS_ATTRIBUTE15, LS_ATTRIBUTE_CATEGORY_CODE FROM FA_ADDITIONS_V WHERE ((:1 is null) or (:2 = 'N' and asset_type <> 'GROUP')) AND -1=-1 and (ASSET_ID in (select ASSET_ID from FA_BOOKS fb, FA_BOOK_CONTROLS_SEC sec where fb.BOOK_TYPE_CODE LIKE 'FA_BOOK_SOHU' and DATE_PLACED_IN_SERVICE BETWEEN to_date('2015/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS') AND to_date('2015/01/31 23:59:59', 'YYYY/MM/DD HH24:MI:SS') and NVL(DISABLED_FLAG, 'N') = 'N' and transaction_header_id_out is null and fb.BOOK_TYPE_CODE = sec.BOOK_TYPE_CODE)) order by asset_number
7aw21806wpgzp	select null from all_synonyms where 1=0
7czrpqy2krgbt	SELECT ASSET_NUMBER, DESCRIPTION, TAG_NUMBER, SERIAL_NUMBER, ASSET_TYPE, CURRENT_UNITS, PARENT_ASSET, PARENT_DESCRIPTION, ATTRIBUTE15, MANUFACTURER_NAME, MODEL_NUMBER, LEASE_NUMBER, LESSOR, LEASE_DESC, PROPERTY_TYPE_CODE, PROPERTY_TYPE_MEANING, OWNED_LEASED, PROPERTY_1245_1250_CODE, PROPERTY_1245_1250_MEANING, NEW_USED, IN_USE_FLAG, INVENTORIAL, ROW_ID, ASSET_ID, ASSET_KEY_CCID, ASSET_CATEGORY_ID, PARENT_ASSET_ID, LEASE_ID, UNIT_ADJUSTMENT_FLAG, ADD_COST_JE_FLAG, CATEGORY_TYPE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, CONTEXT, LS_ATTRIBUTE1, LS_ATTRIBUTE2, LS_ATTRIBUTE3, LS_ATTRIBUTE4, LS_ATTRIBUTE5, LS_ATTRIBUTE6, LS_ATTRIBUTE7, LS_ATTRIBUTE8, LS_ATTRIBUTE9, LS_ATTRIBUTE10, LS_ATTRIBUTE11, LS_ATTRIBUTE12, LS_ATTRIBUTE13, LS_ATTRIBUTE14, LS_ATTRIBUTE15, LS_ATTRIBUTE_CATEGORY_CODE FROM FA_ADDITIONS_V WHERE ((:1 is null) or (:2 = 'N' and asset_type <> 'GROUP')) AND -1=-1 and (ASSET_ID in (select ASSET_ID from FA_BOOKS fb, FA_BOOK_CONTROLS_SEC sec where fb.BOOK_TYPE_CODE LIKE 'FA_BOOK_FOCUS' and NVL(DISABLED_FLAG, 'N') = 'N' and transaction_header_id_out is null and fb.BOOK_TYPE_CODE = sec.BOOK_TYPE_CODE)) order by asset_number
7dcng30ptmf6p	BEGIN cux_ar_op_account_balance.main(:errbuf, :rc, :A0, :A1, :A2); END;
7jaczgtmn2px1	SELECT CUSTOMER_ID, CUSTOMER_NUMBER, CUSTOMER_NAME FROM CRM_ERP_CUSTOMER_V WHERE LAST_UPDATE_DATE > (SYSDATE -7) AND STATUS <> 'I'
7qs7fx89194u1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
89ym8793uy005	SELECT CT_REFERENCE, ORDER_NUMBER, AMOUNT, RECEIPT_DATE, GL_DATE FROM CERP.CRM_ERP_AR_REMAINING_V WHERE LI_TYPE <> 'TRX' AND (ORDER_NUMBER='SOHU-SH-15-00013' OR CT_REFERENCE='SOHU-SH-15-00013')
8w57t3xaxs89k	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS
9n126p922amjm	SELECT /*+ PARALLEL(wf_item_activity_statuses) */ ITEM_TYPE, COUNT(DISTINCT(ITEM_KEY)) CNT FROM WF_ITEM_ACTIVITY_STATUSES WHERE ACTIVITY_STATUS IN ('ACTIVE', 'NOTIFIED', 'WAITING') GROUP BY ITEM_TYPE ORDER BY ITEM_TYPE
9ykq90d7n0cnk	SELECT T.ATTRIBUTE4 FROM PER_PEOPLE_V7 T WHERE T.EMPLOYEE_NUMBER = :B1 AND SYSDATE BETWEEN NVL(T.EFFECTIVE_START_DATE, SYSDATE) AND NVL(T.EFFECTIVE_END_DATE, SYSDATE)
a43828ypr1gwq	SELECT ORG_ID, NAME FROM CRM_ERP_ORG_V
a4v5gubsxy067	BEGIN cux_gl_batch_post_pkg.main(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13); END;
a9u0s3g93f47z	select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj#
afgtq0pjrr2pz	begin cuX_HR_EMP_IMP_pvt.validate_iface(x_return_status=>:return_status, x_msg_data=>:msg_data, p_commit=>:commit, p_interface_run_id=>:interface_run_id); end;
azq1tta3d5snk	SELECT POL.ORGANIZATION_ID FROM PER_ORGANIZATION_LIST POL, FND_PROFILE_OPTION_VALUES POV, FND_PROFILE_OPTIONS FPO WHERE POL.SECURITY_PROFILE_ID = POV.PROFILE_OPTION_VALUE AND POV.PROFILE_OPTION_ID = FPO.PROFILE_OPTION_ID AND POV.APPLICATION_ID = FPO.APPLICATION_ID AND POL.ORGANIZATION_ID != 0 AND POV.LEVEL_ID = 10003 AND POV.LEVEL_VALUE = :B1 AND FPO.PROFILE_OPTION_NAME = 'XLA_MO_SECURITY_PROFILE_LEVEL' AND ROWNUM = 1
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
bqzutt5g7maz0	select distinct furg.responsibility_id, furg.responsibility_application_id, furg.security_group_id, furg.start_date, furg.end_date from fnd_user_resp_groups furg, fnd_responsibility fr where furg.user_id = :1 and furg.responsibility_id = fr.responsibility_id and furg.responsibility_application_id = fr.application_id and furg.start_date <= sysdate and (furg.end_date is null or furg.end_date >= sysdate) and fr.start_date <= sysdate and (fr.end_date is null or fr.end_date >= sysdate) order by furg.responsibility_id, furg.responsibility_application_id, furg.security_group_id
buryzywggrg95	SELECT USER_ID, RESPONSIBILITY_ID, RESPONSIBILITY_NAME, ORG_ID FROM CRM_ERP_USER_RESP_GROUPS_V
cb21bacyh3c7d	select metadata from kopm$ where name='DB_FDO'
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d9vzc65hg8krf	SELECT nvl(sum(apply_amount), 0) as collectionPrice from cux_collection_detail_crm t where line_number =:1 and batch_name=:2
dawf7hvg1ym94	select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3
dku5xcn9a01wt	SELECT CONTRACT_NUMBER, BILL_NUMBER, RECEIPT_DATE, APPLY_AMOUNT, RECEIPT_TYPE FROM CUX_RM_LINE_REV_V WHERE STATUS <> '已撤销' AND STATUS <> '已冲销' AND (BILL_NUMBER='SOHU-SH-15-00013' OR CONTRACT_NUMBER='SOHU-SH-15-00013')
f48dwvqfu83pt	SELECT MSV.VALUE_CONSTANT FROM XLA_MAPPING_SET_VALUES MSV, XLA_MAPPING_SETS_B MS WHERE MSV.AMB_CONTEXT_CODE = MS.AMB_CONTEXT_CODE AND MSV.MAPPING_SET_CODE = MS.MAPPING_SET_CODE AND MS.ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN MSV.EFFECTIVE_DATE_FROM AND NVL(MSV.EFFECTIVE_DATE_TO, SYSDATE) AND MSV.INPUT_VALUE_TYPE_CODE = 'I' AND MSV.INPUT_VALUE_CONSTANT = :B2 AND MS.AMB_CONTEXT_CODE = 'DEFAULT' AND MS.MAPPING_SET_CODE = :B1
f7tt0t5wxq04y	/*begin fnd_global.APPS_INITIALIZE(1885, 50674, 20003); mo_global.init('M'); end;*/ SELECT --nvl(rctla.attribute1, '无') vendor_name, rctla.attribute1 vendor_name, rcta.interface_header_attribute6 exe_number, rcta.interface_header_attribute14 contact_number, flvv.DESCRIPTION city, moact.organization_id, sum(rctla.quantity_invoiced * UNIT_SELLING_PRICE) amount FROM Ra_Customer_Trx_All rcta, RA_CUSTOMER_TRX_LINES_ALL rctla, RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd, gl_code_combinations gcc, FND_FLEX_VALUES_VL flvv, FND_FLEX_VALUE_SETS flvs, AR_MEMO_LINES_ALL_VL amla, mo_glob_org_access_tmp moact---Added By Hand@20150323 parameter p_org_Id is optional where 1 = 1 and rctla.customer_trx_id = rcta.customer_trx_id and rctlgd.customer_trx_line_id = rctla.customer_trx_line_id and rctlgd.customer_trx_id = rcta.customer_trx_id and rctlgd.code_combination_id = gcc.code_combination_id and flvv.FLEX_VALUE_SET_ID = flvs.flex_value_set_id and flvs.flex_value_set_name = 'SOHU_GL_BL' and flvv.FLEX_VALUE = gcc.segment6 --and rcta.org_id = p_org_id---Remarked By Hand@20150323 parameter p_org_Id is optional and rcta.trx_date BETWEEN nvl(null, rcta.trx_date) AND nvl(to_date('20150324', 'yyyy-mm-dd'), rcta.trx_date) ----验证行上的OP信息，只是去OP的金额 AND rctla.memo_line_id = amla.memo_line_id and amla.NAME like 'OP%' and rcta.complete_flag = 'Y' ---and rcta.trx_number = 'JS14-FC00527#001-4' ---Added By Hand@20150323 parameter p_org_Id is optional<Begin> and moact.organization_id = rcta.org_id and (moact.organization_id = NULL or NULL is null) ---Added By Hand@20150323 parameter p_org_Id is optional<Begin> and exists (SELECT 1 FROM RA_CUSTOMER_TRX_LINES_ALL rctl, AR_MEMO_LINES_ALL_VL arml where 1 = 1 and rctl.customer_trx_id = rcta.customer_trx_id AND arml.memo_line_id = rctl.memo_line_id and arml.NAME like 'OP%') group by moact.organization_id, moact.organization_name , --Added By Hand@20150323 rctla.attribute1, rcta.interface_header_attribute6, rcta.interface_header_attribute14, flvv.DESCRIPTION order by moact.organization_id , --Added By Hand@20150323 --nvl(rctla.attribute1, '无') desc; rctla.attribute1
fh7xtfp2uknqx	begin fnd_file_private.open (:l, :o); end;
g0h8ufvuqk7kq	SELECT COUNT(ITEM_KEY) FROM (SELECT /*+ PARALLEL(wf_item_activity_statuses) */ DISTINCT ITEM_TYPE, ITEM_KEY FROM WF_ITEM_ACTIVITY_STATUSES WHERE ACTIVITY_STATUS IN ('ACTIVE', 'NOTIFIED', 'WAITING'))
g2k2kv5jf7yzb	SELECT "VENDOR_ID", "VENDOR_NAME" FROM "PR_ERP_VENDORS_V" "V"
g5hk4ahh13uk3	SELECT DISTINCT PARTY_SITE_NUMBER, ORG_ID, CUSTOMER_ID FROM CRM_ERP_CUST_SITE_V WHERE LAST_UPDATE_DATE > (SYSDATE -7)
guvty8k6k8bbj	SELECT ASSET_NUMBER, DESCRIPTION, TAG_NUMBER, SERIAL_NUMBER, ASSET_TYPE, CURRENT_UNITS, PARENT_ASSET, PARENT_DESCRIPTION, ATTRIBUTE15, MANUFACTURER_NAME, MODEL_NUMBER, LEASE_NUMBER, LESSOR, LEASE_DESC, PROPERTY_TYPE_CODE, PROPERTY_TYPE_MEANING, OWNED_LEASED, PROPERTY_1245_1250_CODE, PROPERTY_1245_1250_MEANING, NEW_USED, IN_USE_FLAG, INVENTORIAL, ROW_ID, ASSET_ID, ASSET_KEY_CCID, ASSET_CATEGORY_ID, PARENT_ASSET_ID, LEASE_ID, UNIT_ADJUSTMENT_FLAG, ADD_COST_JE_FLAG, CATEGORY_TYPE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, CONTEXT, LS_ATTRIBUTE1, LS_ATTRIBUTE2, LS_ATTRIBUTE3, LS_ATTRIBUTE4, LS_ATTRIBUTE5, LS_ATTRIBUTE6, LS_ATTRIBUTE7, LS_ATTRIBUTE8, LS_ATTRIBUTE9, LS_ATTRIBUTE10, LS_ATTRIBUTE11, LS_ATTRIBUTE12, LS_ATTRIBUTE13, LS_ATTRIBUTE14, LS_ATTRIBUTE15, LS_ATTRIBUTE_CATEGORY_CODE FROM FA_ADDITIONS_V WHERE ((:1 is null) or (:2 = 'N' and asset_type <> 'GROUP')) AND -1=-1 and (ASSET_ID in (select ASSET_ID from FA_BOOKS where DATE_PLACED_IN_SERVICE >= to_date('2012/03/24 00:00:00', 'YYYY/MM/DD HH24:MI:SS') and NVL(DISABLED_FLAG, 'N') = 'N' and transaction_header_id_out is null)) order by asset_number
gxwx0sf361cmj	/*begin fnd_global.APPS_INITIALIZE(1885, 50674, 20003); mo_global.init('M'); end;*/ SELECT --nvl(rctla.attribute1, '无') vendor_name, rctla.attribute1 vendor_name, rcta.interface_header_attribute6 exe_number, rcta.interface_header_attribute14 contact_number, flvv.DESCRIPTION city, moact.organization_id, sum(rctla.quantity_invoiced * UNIT_SELLING_PRICE) amount FROM Ra_Customer_Trx_All rcta, RA_CUSTOMER_TRX_LINES_ALL rctla, RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd, gl_code_combinations gcc, FND_FLEX_VALUES_VL flvv, FND_FLEX_VALUE_SETS flvs, AR_MEMO_LINES_ALL_VL amla, mo_glob_org_access_tmp moact---Added By Hand@20150323 parameter p_org_Id is optional where 1 = 1 and rctla.customer_trx_id = rcta.customer_trx_id and rctlgd.customer_trx_line_id = rctla.customer_trx_line_id and rctlgd.customer_trx_id = rcta.customer_trx_id and rctlgd.code_combination_id = gcc.code_combination_id and flvv.FLEX_VALUE_SET_ID = flvs.flex_value_set_id and flvs.flex_value_set_name = 'SOHU_GL_BL' and flvv.FLEX_VALUE = gcc.segment6 --and rcta.org_id = p_org_id---Remarked By Hand@20150323 parameter p_org_Id is optional and rcta.trx_date BETWEEN nvl(null, rcta.trx_date) AND nvl(to_date('20150324', 'yyyy-mm-dd'), rcta.trx_date) ----验证行上的OP信息，只是去OP的金额 AND rctla.memo_line_id = amla.memo_line_id and amla.NAME like 'OP%' and rcta.complete_flag = 'Y' ---and rcta.trx_number = 'JS14-FC00527#001-4' ---Added By Hand@20150323 parameter p_org_Id is optional<Begin> and moact.organization_id = rcta.org_id and (moact.organization_id = 474 or 474 is null) ---Added By Hand@20150323 parameter p_org_Id is optional<Begin> and exists (SELECT 1 FROM RA_CUSTOMER_TRX_LINES_ALL rctl, AR_MEMO_LINES_ALL_VL arml where 1 = 1 and rctl.customer_trx_id = rcta.customer_trx_id AND arml.memo_line_id = rctl.memo_line_id and arml.NAME like 'OP%') group by moact.organization_id, moact.organization_name , --Added By Hand@20150323 rctla.attribute1, rcta.interface_header_attribute6, rcta.interface_header_attribute14, flvv.DESCRIPTION order by moact.organization_id , --Added By Hand@20150323 --nvl(rctla.attribute1, '无') desc; rctla.attribute1
gyrjxz29hwsw2	SELECT /* DS_SVC */ /*+ cursor_sharing_exact dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) */ SUM(C1) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "H") */ 1 AS C1 FROM "GL"."GL_JE_HEADERS" SAMPLE BLOCK(0.745448, 8) SEED(1) "H" WHERE ("H"."NAME" LIKE :B1) AND ("H"."DISPLAY_ALC_JOURNAL_FLAG" IS NULL OR "H"."DISPLAY_ALC_JOURNAL_FLAG"='Y')) innerQuery

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Back to Instance Activity Statistics
Back to Top

IO Stats

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

IOStat by Function summary

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

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File