Re: Udump

vbaskar_at_indiatimes.com (Vijays) 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.
>
> a) How can i disable this, the reason is the application is becoming
> slow ?
>
> This is my content of Listener.
>
> # LISTENER.ORA Network Configuration File:
> E:\oracle\ora92\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = Relics)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = E:\oracle\ora92)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = ninei)
> (ORACLE_HOME = e:\oracle\ora92)
> (SID_NAME = ninei)
> )
> )
>
> Any help is highly appreciated

The udump directory is the user_dump_dest directory. It has nothing to do with the Listener. If your sql_trace init.ora parameter is true (which you can check from sql*plus), you can set the parameter to false and bounce the instance. No more trace files will be generated automatically.
However, trace files will be automatically generated when unexpected errors occur. So when sql_trace is already false, you'd better examine your trace files, and resolve the problems you are having, as opposed as closing your eyes for it.

Sybrand Bakker
Senior Oracle DBA Received on Mon Dec 15 2003 - 08:58:14 CST