Jump to content
SimonDBA

Recommended Option for Max_Dump_File_Size

Recommended Posts

The default setting for max_dump_file_size is set to 'Unlimited'. I am afraid that the Server might

run out of space due to the growing size of the Trace files. What do you recommend me? Should I set

the max_dump_file_size to some number (limit it)? What effects/disadvantages does it have?

Please forward me your recommendations.

Thank you in advance.

 

I am using Oracle 11g R2 (in production environment or live environment), licensed.

I am OCA and my responsibility is DBA.

 

 

Simon

Share this post


Link to post
Share on other sites
The default setting for max_dump_file_size is set to 'Unlimited'. I am afraid that the Server might

run out of space due to the growing size of the Trace files. What do you recommend me? Should I set

the max_dump_file_size to some number (limit it)? What effects/disadvantages does it have?

Please forward me your recommendations.

Thank you in advance.

 

I am using Oracle 11g R2 (in production environment or live environment), licensed.

I am OCA and my responsibility is DBA.

 

 

Simon

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×