Re: Udump

Vijays wrote:
>
> 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

You can limit the size of trace files with the MAX_DUMP_FILE_SIZE init parameter, but then it will probably go and truncate something useful!

Would probably be useful to post what was in the trace files (just the jist, not the whole thing!). Have a look in your alert log to see if errors are occuring and trace files being written to support diagnosing those. Received on Mon Dec 15 2003 - 06:04:22 CST