Raj:
SQL trace or the event 10046 is NOT the right to trace the PL/SQL
executions. You need to either use the dbms package dbms_trace or
event 10938 to populate the SYS table PLSQL_TRACE_EVENTs and select
from that table.
SQL_TRACE is just SQL Trace. NOT PL/SQL Trace..
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
- "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
> I thought the very same Tim ...
> But ...
>
> oraclei_at_elara-ABC1> sys
>
> SQL*Plus: Release 9.2.0.2.0 - Production on Thu Dec 26 13:14:58 2002
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Connected.
> SQL> alter session set sql_trace=true;
>
> Session altered.
>
> SQL> declare
> 2 a date;
> 3 begin
> 4 dbms_output.enable(100000);
> 5 a := sysdate;
> 6 dbms_output.put_line(to_char(a, 'MM-DD-YYYY HH24:MI:SS'));
> 7 end;
> 8 /
>
> PL/SQL procedure successfully completed.
>
> SQL> exit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
> 64bit
> Production
> With the Partitioning, Real Application Clusters, OLAP and Oracle
> Data
> Mining options
> JServer Release 9.2.0.2.0 - Production
> oraclei_at_elara-ABC1>
>
> and
>
> /var/opt/oracle/logs/ABC/abc1_ora_9511050.trc
> Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
> With the Partitioning, Real Application Clusters, OLAP and Oracle
> Data
> Mining options
> JServer Release 9.2.0.2.0 - Production
> ORACLE_HOME = /usr/opt/oracle/current
> System name: AIX
> Node name: elara
> Release: 1
> Version: 5
> Machine: 0023565A4C00
> Instance name: ABC1
> Redo thread mounted by this instance: 1
> Oracle process number: 30
> Unix process pid: 9511050, image: oracle_at_elara (TNS V1-V3)
>
> *** SESSION ID:(36.2802) 2002-12-26 13:15:08.044
> APPNAME mod='sqlplus_at_elara (TNS V1-V3)' mh=0 act='' ah=0
> =====================
> PARSING IN CURSOR #1 len=32 dep=0 uid=0 oct=42 lid=0
> tim=1016529793013758
> hv=3943786303 ad='32ae5788'
> alter session set sql_trace=true
> END OF STMT
> EXEC
> #1:c=0,e=108,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1016529793011934
> *** 2002-12-26 13:15:54.498
> =====================
> PARSING IN CURSOR #1 len=127 dep=0 uid=0 oct=47 lid=0
> tim=1016529838377159
> hv=174346551 ad='301694f8'
> declare
> a date;
> begin
> dbms_output.enable(100000);
> a := sysdate;
> dbms_output.put_line(to_char(a, 'MM-DD-YYYY HH24:MI:SS'));
> end;
> END OF STMT
> PARSE
> #1:c=0,e=8986,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1016529838377153
> EXEC
> #1:c=0,e=443,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=1016529838377721
> XCTEND rlbk=0, rd_only=1
>
> ???
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of
> ESPN Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
>
> -----Original Message-----
> Sent: Thursday, December 26, 2002 12:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> In PL/SQL, every statement which references SYSDATE or USER
> or USERENV or similar functions (such as your second
> suggestion) is automatically translated into an individual
> SELECT xxx FROM DUAL statement, behind the scenes.
>
> You don't have a choice. Call it a weakness of PL/SQL...
> >
********************************************************************This
> e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law.
> If you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank
>
you.*********************************************************************2
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
INET: kaygopal_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Dec 26 2002 - 13:19:03 CST