[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

out trace is ba

Posted on 2013-06-12
2
Medium Priority
?
377 Views
Last Modified: 2013-06-13
SQL> SELECT username, sid, serial#, program FROM v$session WHERE username = 'SYS';

USERNAME                              SID    SERIAL#
------------------------------ ---------- ----------
PROGRAM
------------------------------------------------
SYS                                    17          3
sqlplus@term1.localdomain (TNS V1-V3)



SQL> EXECUTE dbms_system.set_sql_trace_in_session 17,3,true;
BEGIN dbms_system.set_sql_trace_in_session 17,3,true; END;

                                           *
ERROR at line 1:
ORA-06550: line 1, column 44:
PLS-00103: Encountered the symbol "17" when expecting one of the following:
:= . ( @ % ;
The symbol "(" was substituted for "17" to continue.
ORA-06550: line 1, column 53:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
. ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || multise


SQL>
0
Comment
Question by:walkerdba
2 Comments
 
LVL 35

Accepted Solution

by:
johnsone earned 2000 total points
ID: 39244191
EXECUTE dbms_system.set_sql_trace_in_session(17,3,true);

Open in new window

0
 

Author Closing Comment

by:walkerdba
ID: 39245873
good sir
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses
Course of the Month18 days, 3 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question