Database Administration (MOSC)

MOSC Banner

max_dump_file_size set to empty string: What effective limit do you get then?

edited Jun 24, 2011 1:36AM in Database Administration (MOSC) 2 commentsAnswered
Contrary to documentation it's possible to set max_dump_file_size to empty string: SQL> alter session set max_dump_file_size='';
 
Session altered

This results in value=NULL in
select * from v$parameter where name='max_dump_file_size'

What is really the effective limit in this case?



Strangely enough when using NULL instead it fails:

alter session set max_dump_file_size=null
 
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04017: invalid value NULL (length = 4) for parameter max_dump_file_size
 
SQL>

Seems like this implicitly instead does a:

SQL> alter session set max_dump_file_size='null';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center