OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Udmp Traces

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Udmp Traces [message #188718]

Mon, 21 August 2006 05:29

wahdany60
Messages: 17
Registered: April 2006

Junior Member

Dear all:
i want to disable traces generated in Udmp folder
C:\oracle\admin\ORCL\udump.

Report message to a moderator

Re: Udmp Traces [message #189012 is a reply to message #188718]

Tue, 22 August 2006 15:08

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.

Report message to a moderator

Re: Udmp Traces [message #189018 is a reply to message #188718]

Tue, 22 August 2006 15:35

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 .

Report message to a moderator

Re: Udmp Traces [message #189019 is a reply to message #188718]

Tue, 22 August 2006 15:53

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

alter session set sql_trace=false;
THis statement should disable user traces.

Report message to a moderator

Re: Udmp Traces [message #189020 is a reply to message #188718]

Tue, 22 August 2006 15:57

wahdany60
Messages: 17
Registered: April 2006

Junior Member

it is already false
the trace included memory dumps not sql

Report message to a moderator

Re: Udmp Traces [message #189021 is a reply to message #188718]

Tue, 22 August 2006 16:16

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

wahdany60
Messages: 17
Registered: April 2006

Junior Member

it gives error must specify path

Report message to a moderator

Re: Udmp Traces [message #189024 is a reply to message #188718]

Tue, 22 August 2006 16:43

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

how did you change the location?

Report message to a moderator

Re: Udmp Traces [message #189025 is a reply to message #188718]

Tue, 22 August 2006 17:07

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

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?

Report message to a moderator

Re: Udmp Traces [message #189185 is a reply to message #188718]

Wed, 23 August 2006 09:47

wahdany60
Messages: 17
Registered: April 2006

Junior Member

no it is win2k
this value generate error .

Report message to a moderator

Previous Topic:	Index Use and Renaming Partitions
Next Topic:	Shared Pool sizing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 02 08:35:20 CDT 2026