Pegando Cinturas

TKPROF: Release 10.2.0.4.0 - Production on Tue Jul 2 07:40:48 2013

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Trace file: prd500_2_ora_8632.trc

Sort options: exeela fchela prsela

********************************************************************************

count = number of times OCI procedure was executed

cpu = cpu time in seconds executing

elapsed = elapsed time in seconds executing

disk = number of physical reads of buffers from disk

query = number of buffers gotten for consistent read

current = number of buffers gotten in current mode (usually for update)

rows = number of rows processed by the fetch or execute call

********************************************************************************

begin Fnd_Concurrent.Init_Request; end;

call count cpu elapsed disk query current rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse 0 0.00 0.00 0 0 0 0

Execute 1 0.01 1.00 0 32 3 1

Fetch 0 0.00 0.00 0 0 0 0

------- ------ -------- ---------- ---------- ---------- ---------- ----------

total 1 0.01 1.00 0 32 3 1

Misses in library cache during parse: 0

Optimizer mode: ALL_ROWS

Parsing user id: 183

********************************************************************************

SELECT S.SID,S.SERIAL#,P.SPID

FROM

V$SESSION S, V$PROCESS P WHERE S.PADDR=P.ADDR AND AUDSID=USERENV('SESSIONID')

call count cpu elapsed disk query current rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse 1 0.00 0.00 0 0 0 0

Execute 1 0.00 0.00 0 0 0 0

Fetch 1 0.01 0.02 0 0 0 1

------- ------ -------- ---------- ---------- ---------- ---------- ----------

total 3 0.01 0.02 0 0 0 1

Misses in library cache during parse: 0

Optimizer mode: ALL_ROWS

Parsing user id: 183 (recursive depth: 1)

********************************************************************************

SELECT 'TRACE_USER_DETAILS: TIMESTAMP=28-JUN-13:12:45:00: USER_NAME=

CORTIZ709_CO: CONC_REQUEST_ID=219373453: OLTP_OPT_MODE= : CONC_OPT_MODE= :

CONC_PROG_EXE=CVJZZCSTAPEPAC: CONC_PROG_NAME=CVJ ZZ Apertura Costos PAC:

RESPONSIBILITY=CARPAK_CO_CST_SOPORTE: APPL_NAME=BOM'

FROM

DUAL

call count cpu elapsed disk query current rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse 1 0.01 0.00 0 0 0 0

Execute 1 0.00 0.00 0 0 0 0

Fetch 0 0.00 0.00 0 0 0 0

------- ------ -------- ---------- ---------- ---------- ---------- ----------

total 2 0.01 0.00 0 0 0 0

Misses in library cache during parse: 1

Optimizer mode: ALL_ROWS

Parsing user id: 183 (recursive depth: 1)

********************************************************************************

SELECT TO_CHAR(SYSDATE,'DD-MON-YY:HH24:MI:SS')

FROM

SYS.DUAL

call count cpu elapsed disk query current rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse 1 0.00 0.00 0 0 0 0

Execute 1 0.00 0.00 0 0 0 0

Fetch 1 0.00 0.00 0 0 0 1

------- ------ -------- ---------- ---------- ---------- ---------- ----------

total 3 0.00 0.00 0 0 0 1

Misses in library cache during parse: 0

Optimizer mode: ALL_ROWS

Parsing user id: 183 (recursive depth: 1)

********************************************************************************

begin fnd_conc_global.initialize( conc_hold => :hold, conc_copies =>

:copies, conc_priority => :priority, conc_save_output => :save,

conc_single_thread => :single, printer => :printer,

conc_priority_request => :prireq, conc_print_together => :together,

conc_print_output => :print, request_data => :reqdat, db_temp_dir =>

:dbtemp); end;

call count cpu elapsed disk query current rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse 1 0.00 0.00 0 0 0 0

Execute 1 0.00 0.00 0 0 0 1

Fetch 0 0.00 0.00 0 0 0 0

------- ------ -------- ---------- ---------- ---------- ---------- ----------

total 2 0.00 0.00 0 0 0 1

Misses in library cache during parse: 0

Optimizer mode: ALL_ROWS

Parsing user id: 183

********************************************************************************

DELETE FROM FND_DEBUG_RULES

WHERE

(START_TIME IS NOT NULL AND END_TIME < SYSDATE) OR (REPEATION_COUNTER = 0)

call count cpu elapsed disk query current rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse 1 0.00 0.00 0 0 0 0

Execute 1 0.00 0.00 0 62 0 0

Fetch 0 0.00

...