Is it just me or is there an error in the Reference Manual? We were having a problem with enormous trace files being generated, so wanted to limit the size system-wide. Although I’m generally used to specifying this in blocks, I thought I would try specifying it in Mb.
920> show parameter max_dump
NAME TYPE VALUE
------------------------------------ ----------- -----------------------
max_dump_file_size string UNLIMITED
920> alter system set max_dump_file_size=20m;
alter system set max_dump_file_size=20m
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
920> alter system set max_dump_file_size=40960;
System altered.
I’ve tried it on a few different versions now and haven’t found an example yet where I can get it to work. Maybe it’s just lack of sleep or something.
Updated later – based on comment from Thomazzo
920> alter system set max_dump_file_size='20m';
System altered.
I still think the syntax description could be a little clearer.
Try putting single quotes around the ’20m’
if the value is number only, that means how many OS blocks to be set for it
if the value is a string, such as ’10M’
,then it means 10 megabytes..
clear?
Cheers for that 😉
I’ll update the main blog. I’ve just never done it this way – always used o/s blocks – but this way is clearer when others come to look at the value.
You’re welcome, Doug 😉
Dear Doug,
I am Product Development Director in a company delivering sites to PDAs and smrtphones.
We are interested in delivering your site for our international audience.
PLz give me a short feedback.
We are a free service to our users and providers.
Thank you,
Roman