Trial8 Ora 5551 Inform View Comments.trc

Transcript

  TKPROF: Release 11.2.0.4.0 - Development on Wed Sep 17 00:40:58 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Trace file: trial8_ora_5551_INFORM_VIEW_COMMENTS.trcSort options: prsela exeela fchela ********************************************************************************count = number of times OCI procedure was executedcpu = cpu time in seconds executing elapsed = elapsed time in seconds executingdisk = number of physical reads of buffers from diskquery = number of buffers gotten for consistent readcurrent = number of buffers gotten in current mode (usually for update)rows = number of rows processed by the fetch or execute call********************************************************************************SQL ID: b81xr3ntp943n Plan Hash: 0BEGIN EXECUTE IMMEDIATE 'alter session set timed_statistics=TRUE'; EXECUTE IMMEDIATE 'alter session set max_dump_file_size=UNLIMITED'; EXECUTE immediate 'alter session set tracefile_identifier = ''INFORM_VIEW_COMMENTS''' ; EXECUTE IMMEDIATE 'alter session set events ''10046 trace name context forever, level 12'''; END Logon_Inform_Trigger;call count cpu elapsed disk query current rows------- ------ -------- ---------- ---------- ---------- ---------- ----------Parse 0 0.00 0.00 0 0 0 0Execute 1 0.00 0.00 0 0 0 1Fetch 0 0.00 0.00 0 0 0 0------- ------ -------- ---------- ---------- ---------- ---------- ----------total 1 0.00 0.00 0 0 0 1Misses in library cache during parse: 0Optimizer mode: CHOOSEParsing user id: SYS (recursive depth: 1)********************************************************************************SQL ID: csud46x3hpvbj Plan Hash: 415205717SELECT PARAMETER, VALUE FROM SYS.NLS_DATABASE_PARAMETERS WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET')call count cpu elapsed disk query current rows------- ------ -------- ---------- ---------- ---------- ---------- ----------Parse 1 0.00 0.00 0 0 0 0Execute 1 0.00 0.00 0 0 0 0Fetch 1 0.00 0.00 0 2 0 2------- ------ -------- ---------- ---------- ---------- ---------- ----------total 3 0.00 0.00 0 2 0 2  Misses in library cache during parse: 0Optimizer mode: ALL_ROWSParsing user id: 66 Number of plan statistics captured: 1Rows (1st) Rows (avg) Rows (max) Row Source Operation---------- ---------- ---------- --------------------------------------------------- 2 2 2 TABLE ACCESS FULL PROPS$ (cr=2 pr=0 pw=0 time=32 us cost=2 size=28 card=1)Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00********************************************************************************OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTScall count cpu elapsed disk query current rows------- ------ -------- ---------- ---------- ---------- ---------- ----------Parse 1 0.00 0.00 0 0 0 0Execute 1 0.00 0.00 0 0 0 0Fetch 1 0.00 0.00 0 2 0 2------- ------ -------- ---------- ---------- ---------- ---------- ----------total 3 0.00 0.00 0 2 0 2Misses in library cache during parse: 0Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 1 0.00 0.00OVERALL TOTALS FOR ALL RECURSIVE STATEMENTScall count cpu elapsed disk query current rows------- ------ -------- ---------- ---------- ---------- ---------- ----------Parse 0 0.00 0.00 0 0 0 0Execute 1 0.00 0.00 0 0 0 1Fetch 0 0.00 0.00 0 0 0 0------- ------ -------- ---------- ---------- ---------- ---------- ----------total 1 0.00 0.00 0 0 0 1Misses in library cache during parse: 0 1 user SQL statements in session. 1 internal SQL statements in session. 2 SQL statements in session.********************************************************************************Trace file: trial8_ora_5551_INFORM_VIEW_COMMENTS.trcTrace file compatibility: 11.1.0.7Sort options: prsela exeela fchela   1 session in tracefile. 1 user SQL statements in trace file. 1 internal SQL statements in trace file. 2 SQL statements in trace file. 2 unique SQL statements in trace file. 45 lines in trace file. 0 elapsed seconds in trace file.