Home » RDBMS Server » Performance Tuning » Udmp Traces
Udmp Traces [message #188718] Mon, 21 August 2006 05:29 Go to next message
wahdany60
Messages: 17
Registered: April 2006
Junior Member
Dear all:
i want to disable traces generated in Udmp folder
C:\oracle\admin\ORCL\udump.
Re: Udmp Traces [message #189012 is a reply to message #188718] Tue, 22 August 2006 15:08 Go to previous messageGo to next message
tongucy
Messages: 8
Registered: August 2006
Junior Member
Why do you want this? Trace files include important information which may save you someday :)

Maybe you want to change the folder, do you? If so this is a database parameter and can be changed easily.

If you still insist on disabling you may change the parameter to /dev/null, not recomended as I mentioned above.
Re: Udmp Traces [message #189018 is a reply to message #188718] Tue, 22 August 2006 15:35 Go to previous messageGo to next message
wahdany60
Messages: 17
Registered: April 2006
Junior Member
do you mean change user_dump_dest to this value??
i need this because these dumps generated very big size and include hexadicemal dumps of memory .
Re: Udmp Traces [message #189019 is a reply to message #188718] Tue, 22 August 2006 15:53 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
alter session set sql_trace=false;
THis statement should disable user traces.
Re: Udmp Traces [message #189020 is a reply to message #188718] Tue, 22 August 2006 15:57 Go to previous messageGo to next message
wahdany60
Messages: 17
Registered: April 2006
Junior Member
it is already false
the trace included memory dumps not sql
Re: Udmp Traces [message #189021 is a reply to message #188718] Tue, 22 August 2006 16:16 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Since you are using windows change the location to empty as
user_dump_dest=' '

[Updated on: Tue, 22 August 2006 16:16]

Report message to a moderator

Re: Udmp Traces [message #189022 is a reply to message #188718] Tue, 22 August 2006 16:20 Go to previous messageGo to next message
wahdany60
Messages: 17
Registered: April 2006
Junior Member
it gives error must specify path
Re: Udmp Traces [message #189024 is a reply to message #188718] Tue, 22 August 2006 16:43 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
how did you change the location?
Re: Udmp Traces [message #189025 is a reply to message #188718] Tue, 22 August 2006 17:07 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Change it as user_dump_dest=' '.Provide space between

[Updated on: Tue, 22 August 2006 17:09]

Report message to a moderator

Re: Udmp Traces [message #189063 is a reply to message #188718] Wed, 23 August 2006 01:50 Go to previous messageGo to next message
tongucy
Messages: 8
Registered: August 2006
Junior Member
>> i need this because these dumps generated very big size and include hexadicemal dumps of memory .

this is an indication of problems, if you can take support from Oracle they will need these trace files.

is your operating system unix, did you try to change the parameter to /dev/null?
Re: Udmp Traces [message #189185 is a reply to message #188718] Wed, 23 August 2006 09:47 Go to previous message
wahdany60
Messages: 17
Registered: April 2006
Junior Member
no it is win2k
this value generate error .
Previous Topic: Index Use and Renaming Partitions
Next Topic: Shared Pool sizing
Goto Forum:
  


Current Time: Sat Dec 03 10:22:18 CST 2016

Total time taken to generate the page: 0.07420 seconds