?
Solved

I don't know how to stop a trace from growing

Posted on 2012-09-18
2
Medium Priority
?
501 Views
Last Modified: 2012-09-18
Hi experts.
This was executed, but the trace continue to grow.

SQL> begin
  2  sys.dbms_monitor.SESSION_TRACE_ENABLE(207,553,true,true);
  3  end;
  4  /


-rw-r-----    1 oracle   dba      1544039625 Sep 18 14:51 finprd_ora_917676.trc

SQL> select * from dba_enabled_traces;

no rows selected

SQL>
0
Comment
Question by:LindaC
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 38411125
begin
sys.dbms_monitor.SESSION_TRACE_DISABLE(207,553);
end;
0
 
LVL 8

Author Closing Comment

by:LindaC
ID: 38411165
Thank you!
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month13 days, 18 hours left to enroll

807 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