Re: Udump

Look in the doc (on tahiti.oracle.com) about the parameter MAX_DUMP_FILE_SIZE. But note that the log files wrap in order for the file to stay your desired size, and log info is therefore often lost. You might also want to find out which user processes, and why, produce these log files (you could find this in SQLNET.ORA or your INIT file, probably. Or it could be that tracing or a tracing event was enabled by someone in SQL*Plus).

HTH Daniel

>
> 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
Received on Mon Dec 15 2003 - 09:26:11 CST