Home » RDBMS Server » Server Administration » Finding out the value of max_dump_file_size
Finding out the value of max_dump_file_size [message #190877] Fri, 01 September 2006 16:25 Go to next message
madchaz
Messages: 65
Registered: October 2005
Member
Good day all,
As part of an issue we have found, I am trying to figure out what the default value for max_dump_file_size is when opening a session.

The issue, detailed in tar 5688219.992, is that when enabling trace using the program definition in the forms, this setting is set to unlimited. This occurs on ANY concurrent program that uses a pl/sql executable.

This can cause the mount the logs get generated on to fill out, causing all kinds of issues.

The current workaround would be to modify the oracle code that sets the parameter in FND_TRACE, commenting out the line. However, I don't want to do this without knowing what the value will be.

So I need to know where to get the default value for that variable.
Re: Finding out the value of max_dump_file_size [message #190886 is a reply to message #190877] Fri, 01 September 2006 20:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
select value from v$parameter where name = 'max_dump_file_size';
Re: Finding out the value of max_dump_file_size [message #191472 is a reply to message #190886] Wed, 06 September 2006 08:19 Go to previous message
madchaz
Messages: 65
Registered: October 2005
Member
d'oh!

Thanks. Guess I should have tought to look there. What I get for working when sick

Thanks Smile
Previous Topic: oracleorahome92agent
Next Topic: ORA-01653 unable to extend table error
Goto Forum:
  


Current Time: Fri Sep 20 09:23:32 CDT 2024