Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how does a S000 process' trace become 24GB?

Mustafa KALAYCIAug 8 2012 — edited Aug 11 2012
hi,

in our production database, S000 process (which is a shared server process) has produced 24GB trace file less then a 1 day. how can this happen ? unfortunately out DBA delete the file immediately so I don't have much information about it but I wonder what could be the reason ? Also there 25 shared server (S000 - S024) but just first one has this big trace file.

I know answers would be hypothetical but according to your experiences what could be the reason for that ?
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE	11.2.0.2.0	Production"
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Edited by: Mustafa KALAYCI on Aug 8, 2012 4:45 AM
This post has been answered by Billy Verreynne on Aug 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2012
Added on Aug 8 2012
9 comments
1,536 views