Using the report name ashrpt_2_1205_1045.html Summary of All User Input ------------------------- Format : HTML DB Id : 2699934982 Inst num : 2 Begin time : 05-Dec-16 10:30:00 End time : 05-Dec-16 10:45:00 Slot width : Default Report targets : 0 Report name : ashrpt_2_1205_1045.html ASH Report - From 05-Dec-16 10:30:00 To 05-Dec-16 10:45:00

ASH Report For APPDBC/appdbc2

DB NameDB IdInstanceInst numReleaseRACHost
APPDBC2699934982appdbc2210.2.0.4.0YESerpdb-m9k-d01

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
6473,728M (100%)29,136M (39.5%)44,129M (59.9%)68.0M (0.1%)

Sample TimeData Source
Analysis Begin Time:05-Dec-16 10:30:00V$ACTIVE_SESSION_HISTORY
Analysis End Time:05-Dec-16 10:45:00V$ACTIVE_SESSION_HISTORY
Elapsed Time: 15.0 (mins)  
Sample Count: 5,686 
Average Active Sessions: 6.32 
Avg. Active Session per CPU: 0.10 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPU CPU 87.85 5.55
db file sequential read User I/O 4.91 0.31
SQL*Net more data from client Network 1.02 0.06
direct path read User I/O 1.02 0.06

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPU CPU 2.06 0.13

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
db file sequential read 4.96 "3","42777","1" 0.02 file# block# blocks
SQL*Net more data from client 1.02 "1413697536","38","0" 0.25 driver id #bytes NOT DEFINED
direct path read 1.02 "235","275344","16" 0.02 file number first dba block cnt

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
eas UNNAMED 82.73 UNNAMED 82.73
  JDBC Thin Client 9.88 UNNAMED 9.88
SYS$USERS UNNAMED 3.15 UNNAMED 3.15
SYS$BACKGROUND UNNAMED 2.60 UNNAMED 2.60

Back to Load Profile
Back to Top

Top Client IDs

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT 1,655 92.00 5.81

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
35pmx958q1h2r 40765479 8.83 CPU + Wait for CPU 8.78 select * from ( select fbpjobs...
23z3nvmqbf4a0 1363035765 3.97 CPU + Wait for CPU 3.97 select h.boe_header_id, i.oid...
d4rcn2r3afbwr 2326964793 3.36 CPU + Wait for CPU 3.36 select count(*) as col_0_0_ fr...
7m2ja89w4tmz7 1440912187 2.99 CPU + Wait for CPU 2.99 select * from ( select sieboeh...
fg4tjgjct11fc 1171711158 1.97 CPU + Wait for CPU 1.93 SELECT boe_header_id FROM (SEL...

Back to Top SQL
Back to Top

Top SQL using literals

Plan Hash% Activity# of Sampled SQL VersionsExample SQL 1Example SQL TEXT 1Example SQL 2Example SQL TEXT 2
3130075977 6.67 379 000jnzghtgpu9 select sieboehead0_.BOE_HEADER... gzxws80hft8da select sieboehead0_.BOE_HEADER...

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
000jnzghtgpu9 select sieboehead0_.BOE_HEADER_ID as BOE1_605_, sieboehead0_.LAST_UPDATE_DATE as LAST2_605_, sieboehead0_.LAST_UPDATED_BY as LAST3_605_, sieboehead0_.CREATION_DATE as CREATION4_605_, sieboehead0_.CREATED_BY as CREATED5_605_, sieboehead0_.CREATED_NUMBER as CREATED6_605_, sieboehead0_.CREATED_NAME as CREATED7_605_, sieboehead0_.ERRAND_TYPE_CODE as ERRAND8_605_, sieboehead0_.LAST_UPDATE_LOGIN as LAST9_605_, sieboehead0_.BOE_NUM as BOE10_605_, sieboehead0_.BOE_TYPE_ID as BOE11_605_, siebo ehead0_.BOE_TYPE_CODE as BOE12_605_, sieboehead0_.BOE_TYPE_NAME as BOE13_605_, sieboehead0_.ORG_ID as ORG14_605_, sieboehead0_.CHECK_UNIT as CHECK15_605_, sieboehead0_.CHECK_UNIT_NAME as CHECK16_605_, sieboehead0_.OPERATION_TYPE_ID as OPERATION17_605_, sieboehead0_.OPERATION_TYPE_NAME as OPERATION18_605_, sieboehead0_.EMPLOYEE_ID as EMPLOYEE19_605_, sieboehead0_.EMPLOYEE_NUMBER as EMPLOYEE20_605_, sieboehead0_.EMPLOYEE_NAME as EMPLOYEE21_605_, sieboehead0_.DEPT_NAME as DEPT22_605_, si eboehead0_.DEPT_LONG_NAME as DEPT23_605_, sieboehead0_.BOE_DATE as BOE24_605_, sieboehead0_.EMAIL as EMAIL605_, sieboehead0_.MOBILE_PHONE as MOBILE26_605_, sieboehead0_.ACTION_DATE as ACTION27_605_, sieboehead0_.PAYMENT_STATUS_CODE as PAYMENT28_605_, sieboehead0_.PAYMENT_STATUS as PAYMENT29_605_, sieboehead0_.IS_URGENT_FLAG as IS30_605_, sieboehead0_.IS_PROJECT_FLAG as IS31_605_, sieboehead0_.HAS_CONTRACT_FLAG as HAS32_605_, sieboehead0_.HAS_REVERSE_ACCRUED_FLAG as HAS33_605_, sieboeh ead0_.HAS_ACCESSORY_FLAG as HAS34_605_, sieboehead0_.IS_ACCRUED_FLAG as IS35_605_, sieboehead0_.CURRENCY_CODE as CURRENCY36_605_, sieboehead0_.CURRENCY_UNIT as CURRENCY37_605_, sieboehead0_.EXCHANGE_RATE as EXCHANGE38_605_, sieboehead0_.REVERSE_ACCRUED_CODE as REVERSE39_605_, sieboehead0_.REVERSE_ACCRUED_NAME as REVERSE40_605_, sieboehead0_.BOE_ABSTRACT as BOE41_605_, sieboehead0_.BP_NUMBER as BP42_605_, sieboehead0_.BP_COUNT as BP43_605_, sieboehead0_.CUSTOMER_BRAND as CUSTOMER44_605_ , sieboehead0_.CUSTOMER_BRAND_NAME as CUSTOMER45_605_, sieboehead0_.NET_ATTRIBUTE as NET46_605_, sieboehead0_.NET_ATTRIBUTE_NAME as NET47_605_, sieboehead0_.APPLY_AMOUNT as APPLY48_605_, sieboehead0_.FINANCE_AUDIT_AMOUNT as FINANCE49_605_, sieboehead0_.MULTI_APPROAL_AMOUNT as MULTI50_605_, sieboehead0_.BALANCE_AMOUNT as BALANCE51_605_, sieboehead0_.STRIKE_BALANCE_AMOUNT as STRIKE52_605_, sieboehead0_.BOE_TOTAL_AMOUNT as BOE53_605_, sieboehead0_.CAV_TOTAL_AMOUNT as CAV54_605_, sieboehe ad0_.CAV_AMOUNTS as CAV55_605_, sieboehead0_.USEABLE_AMOUNTS as USEABLE56_605_, sieboehead0_.FI_CHANGE_REASON as FI57_605_, sieboehead0_.FI_CHANGE_REASON_NAME as FI58_605_, sieboehead0_.UNIFY_DEPT_ID as UNIFY59_605_, sieboehead0_.UNIFY_DEPT_NAME as UNIFY60_605_, sieboehead0_.CONTRACT_HEADER_ID as CONTRACT61_605_, sieboehead0_.CONTRACT_NUMBER as CONTRACT62_605_, sieboehead0_.CONTRACT_NAME as CONTRACT63_605_, sieboehead0_.CON_TOTAL_AMOUNT as CON64_605_, sieboehead0_.CON_PAYED_AMOUNT as C ON65_605_, sieboehead0_.VENDOR_ID as VENDOR66_605_, sieboehead0_.VENDOR_NUMBER as VENDOR67_605_, sieboehead0_.VENDOR_NAME as VENDOR68_605_, sieboehead0_.VENDOR_SITE_ID as VENDOR69_605_, sieboehead0_.VENDOR_SITE_CODE as VENDOR70_605_, sieboehead0_.PO_HEADER_ID as PO71_605_, sieboehead0_.PO_NUMBER as PO72_605_, sieboehead0_.COST_DEPT_ID as COST73_605_, sieboehead0_.COST_DEPT_CODE as COST74_605_, sieboehead0_.COST_DEPT_NAME as COST75_605_, sieboehead0_.CUSTOMER_ID as CUSTOMER76_605_, si eboehead0_.CUSTOMER_NUMBER as CUSTOMER77_605_, sieboehead0_.CUSTOMER_NAME as CUSTOMER78_605_, sieboehead0_.CUSTOMER_SITE_ID as CUSTOMER79_605_, sieboehead0_.SITE_NUMBER as SITE80_605_, sieboehead0_.SITE_USE_MEANING as SITE81_605_, sieboehead0_.TASK_ID as TASK82_605_, sieboehead0_.TASK_NUMBER as TASK83_605_, sieboehead0_.TASK_NAME as TASK84_605_, sieboehead0_.RECEIVABLES_ORG_ID as RECEIVA85_605_, sieboehead0_.RECEIVABLES_TRX_ID as RECEIVA86_605_, sieboehead0_.RECEIVABLES_NAME as RECEIVA 87_605_, sieboehead0_.RECEIPT_METHOD_ID as RECEIPT88_605_, sieboehead0_.RECEIPT_METHOD as RECEIPT89_605_, sieboehead0_.RECEIPT_BANK_ACCOUNT_ID as RECEIPT90_605_, sieboehead0_.BANK_ACCOUNT_NUM as BANK91_605_, sieboehead0_.BANK_ACCOUNT_NAME as BANK92_605_, sieboehead0_.ERP_ORG_ID as ERP93_605_, sieboehead0_.ERP_ORG_NAME as ERP94_605_, sieboehead0_.BRAND_ID as BRAND95_605_, sieboehead0_.CUST_TRX_TYPE_ORG_ID as CUST96_605_, sieboehead0_.CUST_TRX_TYPE_ID as CUST97_605_, sieboehead0_.CUST_T RX_NAME as CUST98_605_, sieboehead0_.PROJECT_CODE as PROJECT99_605_, sieboehead0_.PROJECT_NAME as PROJECT100_605_, sieboehead0_.BUDGET_ITEMS_CODE as BUDGET101_605_, sieboehead0_.BUDGET_ITEM_NAME as BUDGET102_605_, sieboehead0_.MIS_AMOUNT as MIS103_605_, sieboehead0_.STATUS_CHANGE_REASON as STATUS104_605_, sieboehead0_.PAYMENT_FLAG as PAYMENT105_605_, sieboehead0_.INVOICE_NUMBER as INVOICE106_605_, sieboehead0_.NEED_BILL_FLAG as NEED107_605_, sieboehead0_.SUBMIT_CANCEL_CODE as SUBMIT108 _605_, sieboehead0_.SUBMIT_CANCEL_NAME as SUBMIT109_605_, sieboehead0_.SUBMIT_CANCEL_REASON as SUBMIT110_605_, sieboehead0_.CHECK_REOPEN_FLAG as CHECK111_605_, sieboehead0_.FA_ENABLED_FLAG as FA112_605_, sieboehead0_.PAYMENT_TYPE as PAYMENT113_605_, sieboehead0_.REGION_CODE as REGION114_605_, sieboehead0_.PAY_HEADER_ID as PAY115_605_, sieboehead0_.PAY_BOE_NUM as PAY116_605_, sieboehead0_.BOE_CATEGORY_CODE as BOE117_605_, sieboehead0_.BOE_CATEGORY_NAME as BOE118_605_, sieboehead0_.RECE IPT_TYPE_CODE as RECEIPT119_605_, sieboehead0_.RECEIPT_TYPE_NAME as RECEIPT120_605_, sieboehead0_.BILL_ACCEPTER as BILL121_605_, sieboehead0_.SOURCE as SOURCE605_, sieboehead0_.SOURCE_BOE_NUM as SOURCE123_605_, sieboehead0_.ATTRIBUTE_CATEGORY as ATTRIBUTE124_605_, sieboehead0_.ATTRIBUTE1 as ATTRIBUTE125_605_, sieboehead0_.ATTRIBUTE2 as ATTRIBUTE126_605_, sieboehead0_.ATTRIBUTE3 as ATTRIBUTE127_605_, sieboehead0_.ATTRIBUTE4 as ATTRIBUTE128_605_, sieboehead0_.ATTRIBUTE5 as ATTRIBUTE129_6 05_, sieboehead0_.ATTRIBUTE6 as ATTRIBUTE130_605_, sieboehead0_.ATTRIBUTE7 as ATTRIBUTE131_605_, sieboehead0_.ATTRIBUTE8 as ATTRIBUTE132_605_, sieboehead0_.ATTRIBUTE9 as ATTRIBUTE133_605_, sieboehead0_.ATTRIBUTE10 as ATTRIBUTE134_605_, sieboehead0_.ATTRIBUTE11 as ATTRIBUTE135_605_, sieboehead0_.ATTRIBUTE12 as ATTRIBUTE136_605_, sieboehead0_.ATTRIBUTE13 as ATTRIBUTE137_605_, sieboehead0_.ATTRIBUTE14 as ATTRIBUTE138_605_, sieboehead0_.ATTRIBUTE15 as ATTRIBUTE139_605_, sieboehead0_.ATTRI BUTE16 as ATTRIBUTE140_605_, sieboehead0_.ATTRIBUTE17 as ATTRIBUTE141_605_, sieboehead0_.ATTRIBUTE18 as ATTRIBUTE142_605_, sieboehead0_.ATTRIBUTE19 as ATTRIBUTE143_605_, sieboehead0_.ATTRIBUTE20 as ATTRIBUTE144_605_, sieboehead0_.NUMBER_ATTRIBUTE1 as NUMBER145_605_, sieboehead0_.NUMBER_ATTRIBUTE2 as NUMBER146_605_, sieboehead0_.NUMBER_ATTRIBUTE3 as NUMBER147_605_, sieboehead0_.NUMBER_ATTRIBUTE4 as NUMBER148_605_, sieboehead0_.NUMBER_ATTRIBUTE5 as NUMBER149_605_, sieboehead0_.NUMBER_ATT RIBUTE6 as NUMBER150_605_, sieboehead0_.NUMBER_ATTRIBUTE7 as NUMBER151_605_, sieboehead0_.NUMBER_ATTRIBUTE8 as NUMBER152_605_, sieboehead0_.NUMBER_ATTRIBUTE9 as NUMBER153_605_, sieboehead0_.NUMBER_ATTRIBUTE10 as NUMBER154_605_, sieboehead0_.NUMBER_ATTRIBUTE11 as NUMBER155_605_, sieboehead0_.NUMBER_ATTRIBUTE12 as NUMBER156_605_, sieboehead0_.NUMBER_ATTRIBUTE13 as NUMBER157_605_, sieboehead0_.NUMBER_ATTRIBUTE14 as NUMBER158_605_, sieboehead0_.NUMBER_ATTRIBUTE15 as NUMBER159_605_, sieboeh ead0_.DATE_ATTRIBUTE1 as DATE160_605_, sieboehead0_.DATE_ATTRIBUTE2 as DATE161_605_, sieboehead0_.DATE_ATTRIBUTE3 as DATE162_605_, sieboehead0_.DATE_ATTRIBUTE4 as DATE163_605_, sieboehead0_.DATE_ATTRIBUTE5 as DATE164_605_, sieboehead0_.DATE_ATTRIBUTE6 as DATE165_605_, sieboehead0_.DATE_ATTRIBUTE7 as DATE166_605_, sieboehead0_.DATE_ATTRIBUTE8 as DATE167_605_, sieboehead0_.DATE_ATTRIBUTE9 as DATE168_605_, sieboehead0_.DATE_ATTRIBUTE10 as DATE169_605_, sieboehead0_.VERSION_NUM as VERSION1 70_605_, sieboehead0_.ENABLED_FLAG as ENABLED171_605_, sieboehead0_.BOE_DEPT_ID as BOE172_605_, sieboehead0_.RECEIPT_CATEGORY_CODE as RECEIPT173_605_, sieboehead0_.RECEIPT_CATEGORY_NAME as RECEIPT174_605_, sieboehead0_.brand_code as brand175_605_, sieboehead0_.brand_name as brand176_605_, sieboehead0_.PAYMENT_TYPE_NAME as PAYMENT177_605_, sieboehead0_.ASSET_FROM_ORG_ID as ASSET178_605_, sieboehead0_.ASSET_FROM_ORG_NAME as ASSET179_605_, sieboehead0_.ASSET_TO_ORG_ID as ASSET180_605_, s ieboehead0_.ASSET_TO_ORG_NAME as ASSET181_605_, sieboehead0_.ASSET_TO_DEPT_ID as ASSET182_605_, sieboehead0_.ASSET_TO_DEPT_NAME as ASSET183_605_, sieboehead0_.DESCRIPTION as DESCRI184_605_, sieboehead0_.APPRAISE_PROJECT_CODE as APPRAISE185_605_, sieboehead0_.APPRAISE_PROJECT_NAME as APPRAISE186_605_, sieboehead0_.CON_VENDOR_ID as CON187_605_, sieboehead0_.SALARY_FLAG as SALARY188_605_, sieboehead0_.CONTRACT_URL as CONTRACT189_605_, sieboehead0_.ACC_CM_AMOUNT as ACC190_605_, sieboehead0 _.CM_ADD_AMOUNT as CM191_605_, sieboehead0_.ACC_CM_PAY as ACC192_605_, sieboehead0_.COMPANY_CODE as COMPANY193_605_, sieboehead0_.TAX_AMOUNT as TAX194_605_, sieboehead0_.DOCUMENT_AMOUNT as DOCUMENT195_605_, sieboehead0_.HAS_VAT_FLAG as HAS196_605_, sieboehead0_.OUTPUT_TAX_AMOUNT as OUTPUT197_605_, sieboehead0_.VAT_FLAG as VAT198_605_, sieboehead0_.CONTRACTTAXAMOUNT as CONTRA199_605_, sieboehead0_.CONTRACTAMOUNTTOTAL as CONTRA200_605_, sieboehead0_.IS_CONTRACT_FLAG as IS201_605_, siebo ehead0_.NO_CONTRACT_DESCRIPTION as NO202_605_, sieboehead0_.offset_Flags_Head as offset203_605_, sieboehead0_.COST_INVESTMENT as COST204_605_, sieboehead0_.SOURCE_URL as SOURCE205_605_, sieboehead0_.DEPTH_TRADE as DEPTH206_605_, sieboehead0_.DEPTH_TRADE_MARK as DEPTH207_605_, sieboehead0_.BOE_STATUS as BOE208_605_, sieboehead0_.BOE_STATUS_NAME as BOE209_605_, sieboehead0_.ALLOCATE_TYPE as ALLOCATE210_605_, sieboehead0_.ALLOCATE_TYPE_NAME as ALLOCATE211_605_, sieboehead0_.TRANS_VAT_AMOU NT as TRANS212_605_, sieboehead0_.CARRIED_VAT_AMOUNT as CARRIED213_605_, sieboehead0_.IS_ELECTRONIC_INVOICE as IS214_605_, sieboehead0_.IMMOVABLE_PROPERTY as IMMOVABLE215_605_ from SIE_BOE_HEADERS_ALL_V sieboehead0_ where sieboehead0_.BOE_HEADER_ID=4280189
23z3nvmqbf4a0select h.boe_header_id, i.oid from sie_boe_headers h, mas_trans_info i where h.boe_header_id = i.boe_header_id and exists (select 1 from wfr_bill_histories bh, wfr_bill_his_persons p where bh.wf_histories_id = p.wf_histories_id and bh.boe_header_id = h.boe_header_id and bh.pre_workflow_status = i.boe_status and p.operate_employee_id = :1 and bh.creation_date >= :2 and bh.creation_date < :3) and i.sync_flag = 'N' and i.employee_id = :4
35pmx958q1h2rselect * from ( select fbpjobsv0_.JOB_ID as JOB1_405_, fbpjobsv0_.LAST_UPDATE_DATE as LAST2_405_, fbpjobsv0_.LAST_UPDATED_BY as LAST3_405_, fbpjobsv0_.CREATION_DATE as CREATION4_405_, fbpjobsv0_.CREATED_BY as CREATED5_405_, fbpjobsv0_.LAST_UPDATE_LOGIN as LAST6_405_, fbpjobsv0_.JOB_CODE as JOB7_405_, fbpjobsv0_.JOB_NAME as JOB8_405_, fbpjobsv0_.POSITION_ID as POSITION9_405_, fbpjobsv0_.ATTRIB UTE1 as ATTRIBUTE10_405_, fbpjobsv0_.ATTRIBUTE2 as ATTRIBUTE11_405_, fbpjobsv0_.ATTRIBUTE3 as ATTRIBUTE12_405_, fbpjobsv0_.ATTRIBUTE4 as ATTRIBUTE13_405_, fbpjobsv0_.ATTRIBUTE5 as ATTRIBUTE14_405_, fbpjobsv0_.ATTRIBUTE6 as ATTRIBUTE15_405_, fbpjobsv0_.ATTRIBUTE7 as ATTRIBUTE16_405_, fbpjobsv0_.ATTRIBUTE8 as ATTRIBUTE17_405_, fbpjobsv0_.ATTRIBUTE9 as ATTRIBUTE18_405_, fbpjobsv0_.ATTRIBUTE10 as ATTRIBUTE19_405_, fbpjobsv0_.MEMO as MEMO405_, fbpjobsv0_.ENABLED_FLAG as ENABLED21_405_, fb pjobsv0_.POSITION_NAME as POSITION22_405_, fbpjobsv0_.DEPT_FULL_NAME as DEPT23_405_, fbpjobsv0_.DEPT_FULL_ID as DEPT24_405_, fbpjobsv0_.OPERATION_TYPE_FULL_ID as OPERATION25_405_, fbpjobsv0_.OPERATION_TYPE_FULL_NAME as OPERATION26_405_ from FBP_JOBS_V fbpjobsv0_ where 1=1 order by fbpjobsv0_.LAST_UPDATE_DATE DESC ) where rownum <= :1
7m2ja89w4tmz7 select * from ( select sieboehead0_.BOE_HEADER_ID as BOE1_317_, sieboehead0_.LAST_UPDATE_DATE as LAST2_317_, sieboehead0_.LAST_UPDATED_BY as LAST3_317_, sieboehead0_.CREATION_DATE as CREATION4_317_, sieboehead0_.CREATED_BY as CREATED5_317_, sieboehead0_.CREATED_BY_NAME as CREATED6_317_, sieboehead0_.CHECK_UNIT as CHECK7_317_, sieboehead0_.CREATED_BY_FULL_NAME as CREATED8_317_, sieboehead0_.LAST_UPDATE_LOGIN as LAST9_317_, sieboehead0_.EMPLOYEE_ID as EMPLOYEE10_317_, sieboehead0_.EMPLOY EE_NUMBER as EMPLOYEE11_317_, sieboehead0_.EMPLOYEE_NAME as EMPLOYEE12_317_, sieboehead0_.EMPLOYEE_FULL_NAME as EMPLOYEE13_317_, sieboehead0_.BOE_NUM as BOE14_317_, sieboehead0_.BOE_TYPE_ID as BOE15_317_, sieboehead0_.BOE_TYPE_CODE as BOE16_317_, sieboehead0_.BOE_TYPE_NAME as BOE17_317_, sieboehead0_.TRANSACTION_TYPE as TRANSAC18_317_, sieboehead0_.BOE_STATUS as BOE19_317_, sieboehead0_.BOE_STATUS_NAME as BOE20_317_, sieboehead0_.OPERATION_TYPE_ID as OPERATION21_317_, sieboehead0_.OPE RATION_TYPE_NAME as OPERATION22_317_, sieboehead0_.BUDGET_ITEMS_CODE as BUDGET23_317_, sieboehead0_.BUDGET_ITEM_NAME as BUDGET24_317_, sieboehead0_.BOE_DATE as BOE25_317_, sieboehead0_.IS_URGENT_FLAG as IS26_317_, sieboehead0_.BOE_ABSTRACT as BOE27_317_, sieboehead0_.APPLY_AMOUNT as APPLY28_317_, sieboehead0_.FINANCE_AUDIT_AMOUNT as FINANCE29_317_, sieboehead0_.FA_ENABLED_FLAG as FA30_317_, sieboehead0_.ENABLED_FLAG as ENABLED31_317_, sieboehead0_.PAYMENT_STATUS_CODE as PAYMENT32_317_, sieboehead0_.RESERVED_BUDGET_FLAG as RESERVED33_317_, sieboehead0_.SALARY_FLAG as SALARY34_317_, sieboehead0_.TAX_AMOUNT as TAX35_317_, sieboehead0_.CLAIM_RESULT as CLAIM36_317_, sieboehead0_.DOCUMENT_AMOUNT as DOCUMENT37_317_, sieboehead0_.SOURCE as SOURCE317_, sieboehead0_.EMAIL as EMAIL317_, sieboehead0_.MOBILE_PHONE as MOBILE40_317_, sieboehead0_.BOE_DEPT_ID as BOE41_317_, sieboehead0_.DEPT_NAME as DEPT42_317_, sieboehead0_.CHECK_UNIT_NAME as CHECK43_317_, sieboehead0_.CREATED_N UMBER as CREATED44_317_, sieboehead0_.CREATED_NAME as CREATED45_317_ from SIE_BOE_HEADERS_QRY_COMMON_V sieboehead0_ where 1=1 and sieboehead0_.ENABLED_FLAG='Y' and (sieboehead0_.BOE_STATUS in ('100_BOE_DRAFT')) and sieboehead0_.CREATED_BY=:1 order by sieboehead0_.BOE_HEADER_ID DESC ) where rownum <= :2
d4rcn2r3afbwrselect count(*) as col_0_0_ from SIE_BOE_HEADERS_QRY_V sieboehead0_ where 1=1 and (sieboehead0_.BOE_NUM like :1) and sieboehead0_.BOE_STATUS<>:2 and (sieboehead0_.BOE_DATE is not null) and (sieboehead0_.EMPLOYEE_ID=:3 or sieboehead0_.CREATED_BY=:4)
fg4tjgjct11fcSELECT boe_header_id FROM (SELECT /*+ INDEX(si SIE_INVOICES_N3) */ si.boe_header_id FROM sie_invoices si, wfr_bill_status bs, sie_boe_headers h where si.boe_header_id = bs.boe_header_id and si.sie_invoice_type = :1 AND si.import_failed_reason is null AND (si.imp_into_mis_flag is NULL OR si.imp_into_mis_flag = 'N') AND (si.sie_invoice_type != 'GL_VOUCHER' OR si.batch_number IS NOT NULL) AND bs.cur rent_status = '300_HAS_APPROVED' and si.boe_header_id = h.boe_header_id order by h.last_approve_date) WHERE rownum < :2
gzxws80hft8da select sieboehead0_.BOE_HEADER_ID as BOE1_605_, sieboehead0_.LAST_UPDATE_DATE as LAST2_605_, sieboehead0_.LAST_UPDATED_BY as LAST3_605_, sieboehead0_.CREATION_DATE as CREATION4_605_, sieboehead0_.CREATED_BY as CREATED5_605_, sieboehead0_.CREATED_NUMBER as CREATED6_605_, sieboehead0_.CREATED_NAME as CREATED7_605_, sieboehead0_.ERRAND_TYPE_CODE as ERRAND8_605_, sieboehead0_.LAST_UPDATE_LOGIN as LAST9_605_, sieboehead0_.BOE_NUM as BOE10_605_, sieboehead0_.BOE_TYPE_ID as BOE11_605_, siebo ehead0_.BOE_TYPE_CODE as BOE12_605_, sieboehead0_.BOE_TYPE_NAME as BOE13_605_, sieboehead0_.ORG_ID as ORG14_605_, sieboehead0_.CHECK_UNIT as CHECK15_605_, sieboehead0_.CHECK_UNIT_NAME as CHECK16_605_, sieboehead0_.OPERATION_TYPE_ID as OPERATION17_605_, sieboehead0_.OPERATION_TYPE_NAME as OPERATION18_605_, sieboehead0_.EMPLOYEE_ID as EMPLOYEE19_605_, sieboehead0_.EMPLOYEE_NUMBER as EMPLOYEE20_605_, sieboehead0_.EMPLOYEE_NAME as EMPLOYEE21_605_, sieboehead0_.DEPT_NAME as DEPT22_605_, si eboehead0_.DEPT_LONG_NAME as DEPT23_605_, sieboehead0_.BOE_DATE as BOE24_605_, sieboehead0_.EMAIL as EMAIL605_, sieboehead0_.MOBILE_PHONE as MOBILE26_605_, sieboehead0_.ACTION_DATE as ACTION27_605_, sieboehead0_.PAYMENT_STATUS_CODE as PAYMENT28_605_, sieboehead0_.PAYMENT_STATUS as PAYMENT29_605_, sieboehead0_.IS_URGENT_FLAG as IS30_605_, sieboehead0_.IS_PROJECT_FLAG as IS31_605_, sieboehead0_.HAS_CONTRACT_FLAG as HAS32_605_, sieboehead0_.HAS_REVERSE_ACCRUED_FLAG as HAS33_605_, sieboeh ead0_.HAS_ACCESSORY_FLAG as HAS34_605_, sieboehead0_.IS_ACCRUED_FLAG as IS35_605_, sieboehead0_.CURRENCY_CODE as CURRENCY36_605_, sieboehead0_.CURRENCY_UNIT as CURRENCY37_605_, sieboehead0_.EXCHANGE_RATE as EXCHANGE38_605_, sieboehead0_.REVERSE_ACCRUED_CODE as REVERSE39_605_, sieboehead0_.REVERSE_ACCRUED_NAME as REVERSE40_605_, sieboehead0_.BOE_ABSTRACT as BOE41_605_, sieboehead0_.BP_NUMBER as BP42_605_, sieboehead0_.BP_COUNT as BP43_605_, sieboehead0_.CUSTOMER_BRAND as CUSTOMER44_605_ , sieboehead0_.CUSTOMER_BRAND_NAME as CUSTOMER45_605_, sieboehead0_.NET_ATTRIBUTE as NET46_605_, sieboehead0_.NET_ATTRIBUTE_NAME as NET47_605_, sieboehead0_.APPLY_AMOUNT as APPLY48_605_, sieboehead0_.FINANCE_AUDIT_AMOUNT as FINANCE49_605_, sieboehead0_.MULTI_APPROAL_AMOUNT as MULTI50_605_, sieboehead0_.BALANCE_AMOUNT as BALANCE51_605_, sieboehead0_.STRIKE_BALANCE_AMOUNT as STRIKE52_605_, sieboehead0_.BOE_TOTAL_AMOUNT as BOE53_605_, sieboehead0_.CAV_TOTAL_AMOUNT as CAV54_605_, sieboehe ad0_.CAV_AMOUNTS as CAV55_605_, sieboehead0_.USEABLE_AMOUNTS as USEABLE56_605_, sieboehead0_.FI_CHANGE_REASON as FI57_605_, sieboehead0_.FI_CHANGE_REASON_NAME as FI58_605_, sieboehead0_.UNIFY_DEPT_ID as UNIFY59_605_, sieboehead0_.UNIFY_DEPT_NAME as UNIFY60_605_, sieboehead0_.CONTRACT_HEADER_ID as CONTRACT61_605_, sieboehead0_.CONTRACT_NUMBER as CONTRACT62_605_, sieboehead0_.CONTRACT_NAME as CONTRACT63_605_, sieboehead0_.CON_TOTAL_AMOUNT as CON64_605_, sieboehead0_.CON_PAYED_AMOUNT as C ON65_605_, sieboehead0_.VENDOR_ID as VENDOR66_605_, sieboehead0_.VENDOR_NUMBER as VENDOR67_605_, sieboehead0_.VENDOR_NAME as VENDOR68_605_, sieboehead0_.VENDOR_SITE_ID as VENDOR69_605_, sieboehead0_.VENDOR_SITE_CODE as VENDOR70_605_, sieboehead0_.PO_HEADER_ID as PO71_605_, sieboehead0_.PO_NUMBER as PO72_605_, sieboehead0_.COST_DEPT_ID as COST73_605_, sieboehead0_.COST_DEPT_CODE as COST74_605_, sieboehead0_.COST_DEPT_NAME as COST75_605_, sieboehead0_.CUSTOMER_ID as CUSTOMER76_605_, si eboehead0_.CUSTOMER_NUMBER as CUSTOMER77_605_, sieboehead0_.CUSTOMER_NAME as CUSTOMER78_605_, sieboehead0_.CUSTOMER_SITE_ID as CUSTOMER79_605_, sieboehead0_.SITE_NUMBER as SITE80_605_, sieboehead0_.SITE_USE_MEANING as SITE81_605_, sieboehead0_.TASK_ID as TASK82_605_, sieboehead0_.TASK_NUMBER as TASK83_605_, sieboehead0_.TASK_NAME as TASK84_605_, sieboehead0_.RECEIVABLES_ORG_ID as RECEIVA85_605_, sieboehead0_.RECEIVABLES_TRX_ID as RECEIVA86_605_, sieboehead0_.RECEIVABLES_NAME as RECEIVA 87_605_, sieboehead0_.RECEIPT_METHOD_ID as RECEIPT88_605_, sieboehead0_.RECEIPT_METHOD as RECEIPT89_605_, sieboehead0_.RECEIPT_BANK_ACCOUNT_ID as RECEIPT90_605_, sieboehead0_.BANK_ACCOUNT_NUM as BANK91_605_, sieboehead0_.BANK_ACCOUNT_NAME as BANK92_605_, sieboehead0_.ERP_ORG_ID as ERP93_605_, sieboehead0_.ERP_ORG_NAME as ERP94_605_, sieboehead0_.BRAND_ID as BRAND95_605_, sieboehead0_.CUST_TRX_TYPE_ORG_ID as CUST96_605_, sieboehead0_.CUST_TRX_TYPE_ID as CUST97_605_, sieboehead0_.CUST_T RX_NAME as CUST98_605_, sieboehead0_.PROJECT_CODE as PROJECT99_605_, sieboehead0_.PROJECT_NAME as PROJECT100_605_, sieboehead0_.BUDGET_ITEMS_CODE as BUDGET101_605_, sieboehead0_.BUDGET_ITEM_NAME as BUDGET102_605_, sieboehead0_.MIS_AMOUNT as MIS103_605_, sieboehead0_.STATUS_CHANGE_REASON as STATUS104_605_, sieboehead0_.PAYMENT_FLAG as PAYMENT105_605_, sieboehead0_.INVOICE_NUMBER as INVOICE106_605_, sieboehead0_.NEED_BILL_FLAG as NEED107_605_, sieboehead0_.SUBMIT_CANCEL_CODE as SUBMIT108 _605_, sieboehead0_.SUBMIT_CANCEL_NAME as SUBMIT109_605_, sieboehead0_.SUBMIT_CANCEL_REASON as SUBMIT110_605_, sieboehead0_.CHECK_REOPEN_FLAG as CHECK111_605_, sieboehead0_.FA_ENABLED_FLAG as FA112_605_, sieboehead0_.PAYMENT_TYPE as PAYMENT113_605_, sieboehead0_.REGION_CODE as REGION114_605_, sieboehead0_.PAY_HEADER_ID as PAY115_605_, sieboehead0_.PAY_BOE_NUM as PAY116_605_, sieboehead0_.BOE_CATEGORY_CODE as BOE117_605_, sieboehead0_.BOE_CATEGORY_NAME as BOE118_605_, sieboehead0_.RECE IPT_TYPE_CODE as RECEIPT119_605_, sieboehead0_.RECEIPT_TYPE_NAME as RECEIPT120_605_, sieboehead0_.BILL_ACCEPTER as BILL121_605_, sieboehead0_.SOURCE as SOURCE605_, sieboehead0_.SOURCE_BOE_NUM as SOURCE123_605_, sieboehead0_.ATTRIBUTE_CATEGORY as ATTRIBUTE124_605_, sieboehead0_.ATTRIBUTE1 as ATTRIBUTE125_605_, sieboehead0_.ATTRIBUTE2 as ATTRIBUTE126_605_, sieboehead0_.ATTRIBUTE3 as ATTRIBUTE127_605_, sieboehead0_.ATTRIBUTE4 as ATTRIBUTE128_605_, sieboehead0_.ATTRIBUTE5 as ATTRIBUTE129_6 05_, sieboehead0_.ATTRIBUTE6 as ATTRIBUTE130_605_, sieboehead0_.ATTRIBUTE7 as ATTRIBUTE131_605_, sieboehead0_.ATTRIBUTE8 as ATTRIBUTE132_605_, sieboehead0_.ATTRIBUTE9 as ATTRIBUTE133_605_, sieboehead0_.ATTRIBUTE10 as ATTRIBUTE134_605_, sieboehead0_.ATTRIBUTE11 as ATTRIBUTE135_605_, sieboehead0_.ATTRIBUTE12 as ATTRIBUTE136_605_, sieboehead0_.ATTRIBUTE13 as ATTRIBUTE137_605_, sieboehead0_.ATTRIBUTE14 as ATTRIBUTE138_605_, sieboehead0_.ATTRIBUTE15 as ATTRIBUTE139_605_, sieboehead0_.ATTRI BUTE16 as ATTRIBUTE140_605_, sieboehead0_.ATTRIBUTE17 as ATTRIBUTE141_605_, sieboehead0_.ATTRIBUTE18 as ATTRIBUTE142_605_, sieboehead0_.ATTRIBUTE19 as ATTRIBUTE143_605_, sieboehead0_.ATTRIBUTE20 as ATTRIBUTE144_605_, sieboehead0_.NUMBER_ATTRIBUTE1 as NUMBER145_605_, sieboehead0_.NUMBER_ATTRIBUTE2 as NUMBER146_605_, sieboehead0_.NUMBER_ATTRIBUTE3 as NUMBER147_605_, sieboehead0_.NUMBER_ATTRIBUTE4 as NUMBER148_605_, sieboehead0_.NUMBER_ATTRIBUTE5 as NUMBER149_605_, sieboehead0_.NUMBER_ATT RIBUTE6 as NUMBER150_605_, sieboehead0_.NUMBER_ATTRIBUTE7 as NUMBER151_605_, sieboehead0_.NUMBER_ATTRIBUTE8 as NUMBER152_605_, sieboehead0_.NUMBER_ATTRIBUTE9 as NUMBER153_605_, sieboehead0_.NUMBER_ATTRIBUTE10 as NUMBER154_605_, sieboehead0_.NUMBER_ATTRIBUTE11 as NUMBER155_605_, sieboehead0_.NUMBER_ATTRIBUTE12 as NUMBER156_605_, sieboehead0_.NUMBER_ATTRIBUTE13 as NUMBER157_605_, sieboehead0_.NUMBER_ATTRIBUTE14 as NUMBER158_605_, sieboehead0_.NUMBER_ATTRIBUTE15 as NUMBER159_605_, sieboeh ead0_.DATE_ATTRIBUTE1 as DATE160_605_, sieboehead0_.DATE_ATTRIBUTE2 as DATE161_605_, sieboehead0_.DATE_ATTRIBUTE3 as DATE162_605_, sieboehead0_.DATE_ATTRIBUTE4 as DATE163_605_, sieboehead0_.DATE_ATTRIBUTE5 as DATE164_605_, sieboehead0_.DATE_ATTRIBUTE6 as DATE165_605_, sieboehead0_.DATE_ATTRIBUTE7 as DATE166_605_, sieboehead0_.DATE_ATTRIBUTE8 as DATE167_605_, sieboehead0_.DATE_ATTRIBUTE9 as DATE168_605_, sieboehead0_.DATE_ATTRIBUTE10 as DATE169_605_, sieboehead0_.VERSION_NUM as VERSION1 70_605_, sieboehead0_.ENABLED_FLAG as ENABLED171_605_, sieboehead0_.BOE_DEPT_ID as BOE172_605_, sieboehead0_.RECEIPT_CATEGORY_CODE as RECEIPT173_605_, sieboehead0_.RECEIPT_CATEGORY_NAME as RECEIPT174_605_, sieboehead0_.brand_code as brand175_605_, sieboehead0_.brand_name as brand176_605_, sieboehead0_.PAYMENT_TYPE_NAME as PAYMENT177_605_, sieboehead0_.ASSET_FROM_ORG_ID as ASSET178_605_, sieboehead0_.ASSET_FROM_ORG_NAME as ASSET179_605_, sieboehead0_.ASSET_TO_ORG_ID as ASSET180_605_, s ieboehead0_.ASSET_TO_ORG_NAME as ASSET181_605_, sieboehead0_.ASSET_TO_DEPT_ID as ASSET182_605_, sieboehead0_.ASSET_TO_DEPT_NAME as ASSET183_605_, sieboehead0_.DESCRIPTION as DESCRI184_605_, sieboehead0_.APPRAISE_PROJECT_CODE as APPRAISE185_605_, sieboehead0_.APPRAISE_PROJECT_NAME as APPRAISE186_605_, sieboehead0_.CON_VENDOR_ID as CON187_605_, sieboehead0_.SALARY_FLAG as SALARY188_605_, sieboehead0_.CONTRACT_URL as CONTRACT189_605_, sieboehead0_.ACC_CM_AMOUNT as ACC190_605_, sieboehead0 _.CM_ADD_AMOUNT as CM191_605_, sieboehead0_.ACC_CM_PAY as ACC192_605_, sieboehead0_.COMPANY_CODE as COMPANY193_605_, sieboehead0_.TAX_AMOUNT as TAX194_605_, sieboehead0_.DOCUMENT_AMOUNT as DOCUMENT195_605_, sieboehead0_.HAS_VAT_FLAG as HAS196_605_, sieboehead0_.OUTPUT_TAX_AMOUNT as OUTPUT197_605_, sieboehead0_.VAT_FLAG as VAT198_605_, sieboehead0_.CONTRACTTAXAMOUNT as CONTRA199_605_, sieboehead0_.CONTRACTAMOUNTTOTAL as CONTRA200_605_, sieboehead0_.IS_CONTRACT_FLAG as IS201_605_, siebo ehead0_.NO_CONTRACT_DESCRIPTION as NO202_605_, sieboehead0_.offset_Flags_Head as offset203_605_, sieboehead0_.COST_INVESTMENT as COST204_605_, sieboehead0_.SOURCE_URL as SOURCE205_605_, sieboehead0_.DEPTH_TRADE as DEPTH206_605_, sieboehead0_.DEPTH_TRADE_MARK as DEPTH207_605_, sieboehead0_.BOE_STATUS as BOE208_605_, sieboehead0_.BOE_STATUS_NAME as BOE209_605_, sieboehead0_.ALLOCATE_TYPE as ALLOCATE210_605_, sieboehead0_.ALLOCATE_TYPE_NAME as ALLOCATE211_605_, sieboehead0_.TRANS_VAT_AMOU NT as TRANS212_605_, sieboehead0_.CARRIED_VAT_AMOUNT as CARRIED213_605_, sieboehead0_.IS_ELECTRONIC_INVOICE as IS214_605_, sieboehead0_.IMMOVABLE_PROPERTY as IMMOVABLE215_605_ from SIE_BOE_HEADERS_ALL_V sieboehead0_ where sieboehead0_.BOE_HEADER_ID=4277411

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
APPS.FBP_FUNCTION_PKG.GET_JOB_DEPT_ID 8.34 APPS.FBP_FUNCTION_PKG.GET_JOB_DEPT_ID 8.13
SYS.DBMS_REFRESH.REFRESH 3.06 SQL 2.99
APPS.CBM_RES_BALANCES_UTIL_PKG.GET_PARENT_CCID_TOTAL_AMOUNT 1.00 SQL 0.93


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
2610,26517 3.06 CPU + Wait for CPU 3.01 APPS oracle@erpdb-m9k-d01 (J003) 171/900 [ 19%] 1
1262,23285 2.15 CPU + Wait for CPU 2.13 APPS   121/900 [ 13%] 0
2466,41149 2.04 CPU + Wait for CPU 2.02 APPS   115/900 [ 13%] 0
2680, 1403 2.00 CPU + Wait for CPU 1.99 APPS   113/900 [ 13%] 0
1271,48227 1.99 CPU + Wait for CPU 1.92 APPS   109/900 [ 12%] 0

Back to Top Sessions
Back to Top

Top Blocking Sessions

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Sessions running PQs

Sid,Srl# (Inst)% ActivitySQL IDEvent% EventUserProgramSQL Text
2581,UNKNOWN(2) 1.53 anu24kgway0k7 direct path read 1.02 UserID:   select cd.item_Header_Id , nvl...

Back to Top Sessions
Back to Top

Top Objects/Files/Latches

Back to Top

Top DB Objects

Object ID% ActivityEvent% EventObject Name (Type)Tablespace
58100 4.13 db file sequential read 2.74 CBMS.CBM_COST_DETAILS (TABLE) EAS_DATA_NEW
    direct path read 1.02    

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top Latches

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEventEvent Count% Event
10:30:00 (2.0 min) 849 CPU + Wait for CPU 696 12.24
    db file sequential read 102 1.79
    gc cr block busy 11 0.19
10:32:00 (2.0 min) 789 CPU + Wait for CPU 718 12.63
    db file sequential read 44 0.77
    SQL*Net more data from client 7 0.12
10:34:00 (2.0 min) 927 CPU + Wait for CPU 889 15.63
    db file sequential read 22 0.39
    log file sync 4 0.07
10:36:00 (2.0 min) 437 CPU + Wait for CPU 366 6.44
    SQL*Net more data from client 38 0.67
    db file scattered read 8 0.14
10:38:00 (2.0 min) 606 CPU + Wait for CPU 585 10.29
    db file sequential read 5 0.09
    wait for scn ack 5 0.09
10:40:00 (2.0 min) 856 CPU + Wait for CPU 704 12.38
    db file sequential read 58 1.02
    direct path read 58 1.02
10:42:00 (2.0 min) 975 CPU + Wait for CPU 930 16.36
    db file sequential read 31 0.55
    log file sync 5 0.09
10:44:00 (60 secs) 247 CPU + Wait for CPU 224 3.94
    db file sequential read 14 0.25
    log file sync 3 0.05


Back to Top

End of Report Report written to ashrpt_2_1205_1045.html Prod:user=sys,db=appdbc SQL>