TKPROF: Release 10.2.0.1.0 - Production on Tue Oct 12 14:01:13 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Trace file: rubikon_s002_3952.trc Sort options: exeela exerow ******************************************************************************** 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 ******************************************************************************** DELETE FROM GL_ACCOUNT WHERE GL_ACCT_ID IN (16908,16909,16456) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.13 0 0 0 0 Execute 1 0.03 0.26 0 6 221 3 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.04 0.40 0 6 221 3 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (OFFLINETESTDB) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE GL_ACCOUNT (cr=177742 pr=160538 pw=0 time=31518664 us) 3 INLIST ITERATOR (cr=6 pr=0 pw=0 time=103 us) 3 INDEX RANGE SCAN GL_ACCOUNT_PK (cr=6 pr=0 pw=0 time=86 us)(object id 65637) Rows Execution Plan ------- --------------------------------------------------- 0 DELETE STATEMENT MODE: ALL_ROWS 0 DELETE OF 'GL_ACCOUNT' 3 INLIST ITERATOR 3 INDEX MODE: ANALYZED (RANGE SCAN) OF 'GL_ACCOUNT_PK' (INDEX (UNIQUE)) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ACCOUNT_SUMMARY" where "GL_ACCT_ID" = :1 and "GL_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.06 0 0 0 0 Fetch 3 0.00 0.00 0 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.06 0 6 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=6 pr=0 pw=0 time=236 us) 0 VIEW index$_join$_001 (cr=6 pr=0 pw=0 time=185 us) 0 HASH JOIN (cr=6 pr=0 pw=0 time=172 us) 0 INDEX RANGE SCAN GL_ACCOUNT_SUMMARY_IX2 (cr=6 pr=0 pw=0 time=82 us)(object id 65648) 0 INDEX RANGE SCAN GL_ACCOUNT_SUMMARY_IX1 (cr=0 pr=0 pw=0 time=0 us)(object id 65647) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ACCOUNT_QUARTERLY_STAT" where "GL_ACCT_ID" = :1 and "GL_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.06 0 0 0 0 Fetch 3 1.64 20.79 108398 109500 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 1.64 20.86 108398 109500 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=109500 pr=108398 pw=0 time=20797344 us) 0 TABLE ACCESS FULL GL_ACCOUNT_QUARTERLY_STAT (cr=109500 pr=108398 pw=0 time=20797279 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ACCOUNT_MONTHLY_STAT" where "GL_ACCT_ID" = :1 and "GL_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 4 0.00 0.06 0 0 1 0 Fetch 3 0.75 10.11 52140 59532 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.75 10.18 52140 59532 1 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Parsing user id: SYS Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=59532 pr=52140 pw=0 time=10116280 us) 0 TABLE ACCESS FULL GL_ACCOUNT_MONTHLY_STAT (cr=59532 pr=52140 pw=0 time=10116221 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ACCOUNT_RECON_TXN_JOURNAL" where "GL_ACCT_ID" = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.02 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.02 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=138 us) 0 TABLE ACCESS FULL GL_ACCOUNT_RECON_TXN_JOURNAL (cr=9 pr=0 pw=0 time=97 us) ******************************************************************************** select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.01 0.00 0 0 0 0 Execute 3 0.01 0.00 0 0 2 0 Fetch 3 0.00 0.00 0 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.03 0.00 0 6 2 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=34 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_BULK_CRITERIA" where "GL_ACCT_ID" = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=109 us) 0 TABLE ACCESS FULL GL_BULK_CRITERIA (cr=9 pr=0 pw=0 time=71 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ACCOUNT_HISTORY" where "GL_ACCT_ID" = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.01 0.02 0 5070 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.01 0.02 0 5070 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=5070 pr=0 pw=0 time=22519 us) 0 TABLE ACCESS FULL GL_ACCOUNT_HISTORY (cr=5070 pr=0 pw=0 time=22472 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ACCOUNT_BULK_HISTORY" where "GL_ACCT_ID" = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=106 us) 0 TABLE ACCESS FULL GL_ACCOUNT_BULK_HISTORY (cr=9 pr=0 pw=0 time=69 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ALLOTMENT" where "POOL_ACCT_ID" = :1 and "POOL_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 3 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.02 0 3 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=3 pr=0 pw=0 time=113 us) 0 TABLE ACCESS BY INDEX ROWID GL_ALLOTMENT (cr=3 pr=0 pw=0 time=68 us) 0 INDEX RANGE SCAN GL_ALLOTMENT_IX1 (cr=3 pr=0 pw=0 time=50 us)(object id 65651) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ACCOUNT_YEARLY_STAT" where "GL_ACCT_ID" = :1 and "GL_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.01 0.01 0 3453 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.01 0.01 0 3453 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=3453 pr=0 pw=0 time=10485 us) 0 TABLE ACCESS FULL GL_ACCOUNT_YEARLY_STAT (cr=3453 pr=0 pw=0 time=10440 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."BU_GL_INTERFACE_ACCOUNT" where "CASH_GL_ACCT_ID" = :1 and "CASH_GL_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=110 us) 0 TABLE ACCESS FULL BU_GL_INTERFACE_ACCOUNT (cr=9 pr=0 pw=0 time=71 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."BU_GL_INTERFACE_ACCOUNT" where "DEPOT_GL_ACCT_ID" = :1 and "DEPOT_GL_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=107 us) 0 TABLE ACCESS FULL BU_GL_INTERFACE_ACCOUNT (cr=9 pr=0 pw=0 time=71 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_TXN_ALLOTTEE" where "GL_ALLOTTEE_ACCT_ID" = :1 and "GL_ALLOTTEE_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=122 us) 0 TABLE ACCESS FULL GL_TXN_ALLOTTEE (cr=9 pr=0 pw=0 time=84 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."BU_GL_INTERFACE_ACCOUNT" where "POSN_GL_ACCT_ID" = :1 and "POSN_GL_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=110 us) 0 TABLE ACCESS FULL BU_GL_INTERFACE_ACCOUNT (cr=9 pr=0 pw=0 time=69 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ALLOTTEE" where "RECIPIENT_ACCT_ID" = :1 and "RECIPIENT_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=155 us) 0 TABLE ACCESS FULL GL_ALLOTTEE (cr=9 pr=0 pw=0 time=119 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."BU_GL_INTERFACE_ACCOUNT" where "INTER_BU_GL_ACCT_ID" = :1 and "INTER_BU_GL_ACCT_NO" = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=102 us) 0 TABLE ACCESS FULL BU_GL_INTERFACE_ACCOUNT (cr=9 pr=0 pw=0 time=67 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_BUDGET_ITEM_DATA" where "GL_ACCT_ID" = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=151 us) 0 TABLE ACCESS FULL GL_BUDGET_ITEM_DATA (cr=9 pr=0 pw=0 time=108 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_TOTALLING_ACCOUNT_LINE" where "GL_ACCT_ID" = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.02 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=119 us) 0 TABLE ACCESS FULL GL_TOTALLING_ACCOUNT_LINE (cr=9 pr=0 pw=0 time=82 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."SWEEP_FUNDS_XFER" where "TO_GL_ACCT_ID" = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.01 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.01 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=123 us) 0 TABLE ACCESS FULL SWEEP_FUNDS_XFER (cr=9 pr=0 pw=0 time=84 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."GL_ACCESS_ACCOUNT_LIST" where "GL_ACCT_ID" = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=117 us) 0 TABLE ACCESS FULL GL_ACCESS_ACCOUNT_LIST (cr=9 pr=0 pw=0 time=79 us) ******************************************************************************** select /*+ all_rows */ count(1) from "OFFLINETESTDB"."SETTLEMENT_BANK_ACCOUNT" where "MIRROR_GL_ACCT_ID" = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT AGGREGATE (cr=9 pr=0 pw=0 time=121 us) 0 TABLE ACCESS FULL SETTLEMENT_BANK_ACCOUNT (cr=9 pr=0 pw=0 time=86 us) ******************************************************************************** select condition from cdef$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 25 0.00 0.00 0 0 0 0 Execute 25 0.00 0.00 0 0 0 0 Fetch 25 0.00 0.00 0 50 0 25 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 75 0.00 0.00 0 50 0 25 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID CDEF$ (cr=1 pr=0 pw=0 time=39 us) ******************************************************************************** alter session set sql_trace=true call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 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 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (OFFLINETESTDB) ******************************************************************************** alter session set sql_trace=false 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (OFFLINETESTDB) ******************************************************************************** select VALUE from nls_session_parameters where PARAMETER='NLS_DATE_FORMAT' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.04 0 0 2 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.04 0 0 2 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (OFFLINETESTDB) Rows Row Source Operation ------- --------------------------------------------------- 1 FIXED TABLE FULL X$NLS_PARAMETERS (cr=0 pr=0 pw=0 time=61 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 FIXED TABLE (FULL) OF 'X$NLS_PARAMETERS' (TABLE (FIXED)) ******************************************************************************** select VALUE from nls_session_parameters where PARAMETER='NLS_NUMERIC_CHARACTERS' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.04 0 0 2 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.04 0 0 2 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (OFFLINETESTDB) Rows Row Source Operation ------- --------------------------------------------------- 1 FIXED TABLE FULL X$NLS_PARAMETERS (cr=0 pr=0 pw=0 time=71 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 FIXED TABLE (FULL) OF 'X$NLS_PARAMETERS' (TABLE (FIXED)) ******************************************************************************** select VALUE from nls_session_parameters where PARAMETER='NLS_CURRENCY' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.05 0 0 2 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.05 0 0 2 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (OFFLINETESTDB) Rows Row Source Operation ------- --------------------------------------------------- 1 FIXED TABLE FULL X$NLS_PARAMETERS (cr=0 pr=0 pw=0 time=58 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 FIXED TABLE (FULL) OF 'X$NLS_PARAMETERS' (TABLE (FIXED)) ******************************************************************************** select to_char(9,'9C') from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 2 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 2 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (OFFLINETESTDB) Rows Row Source Operation ------- --------------------------------------------------- 1 FAST DUAL (cr=0 pr=0 pw=0 time=5 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 FAST DUAL ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.01 0.29 0 0 8 0 Execute 11 0.03 0.32 0 6 222 3 Fetch 7 0.75 10.11 52140 59532 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 26 0.79 10.73 52140 59538 230 10 Misses in library cache during parse: 7 Misses in library cache during execute: 2 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 47 0.01 0.06 0 0 0 0 Execute 85 0.03 0.18 0 0 2 0 Fetch 85 1.67 20.83 108398 118214 0 85 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 217 1.71 21.08 108398 118214 2 85 Misses in library cache during parse: 21 Misses in library cache during execute: 20 7 user SQL statements in session. 48 internal SQL statements in session. 55 SQL statements in session. 5 statements EXPLAINed in this session. ******************************************************************************** Trace file: rubikon_s002_3952.trc Trace file compatibility: 10.01.00 Sort options: exeela exerow 1 session in tracefile. 7 user SQL statements in trace file. 48 internal SQL statements in trace file. 55 SQL statements in trace file. 29 unique SQL statements in trace file. 5 SQL statements EXPLAINed using schema: OFFLINETESTDB.prof$plan_table Default table was used. Table was created. Table was dropped. 548 lines in trace file. 32 elapsed seconds in trace file.