-
Hello Guys:
Every minute I am generating about 10 trace files in my udump directory since yesterday afternoon.
I TKPROFed a few file but does not make much sense, to know how to stop trace files getting generated..
An average trace file is like this.. when i checked randomly for the last few hours
TKPROF: Release 8.1.7.1.0 - Production on Fri Aug 16 10:29:28 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Trace file: ././ora_48758_odbmsprd.trc
Sort options: default
********************************************************************************
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
0 statements EXPLAINed in this session.
********************************************************************************
Trace file: ././ora_48758_odbmsprd.trc
Trace file compatibility: 8.00.04
Sort options: default
1 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
22 lines in trace file.
Thanks, Sashi
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|