Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Udump
"Vijays" <vbaskar_at_indiatimes.com> wrote in message
news:65a7c6c4.0312150343.60fca6cc_at_posting.google.com...
> Hi All,
>
> My Version is
>
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> PL/SQL Release 9.2.0.1.0 - Production
> CORE 9.2.0.1.0 Production
> TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
> NLSRTL Version 9.2.0.1.0 - Production
>
>
> Offlate there are numerous amount of Trace Files that are getting
> created under the UDUMP directory and the file size is going to
> whopping 3-4 GB.
If the parameter SQL_TRACE is set to TRUE then you will get a trace file in
UDUMP for every session that connects to the database. This would be a bad
thing. It would also be worth seeing if there are any logon triggers etc
that set sql_trace or diagnostic events such as 10046 for particular
application users.
Finally as Rob suggests can you look at a few example trace files and see
how they were generated -- the information is normally at the top of the
trace file.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Mon Dec 15 2003 - 07:19:58 CST