Re: DUMP FILE SIZE

Check Oracle MetaLink Note 108723.1. There seems to be a problem when a numeric value is specified for max_dump_file_size, rather than a K or M at the end. In short, change max_dump_file_size to 10K from 10240, bounce it and retry.

HTH. Arup Nanda
----- Original Message -----
To: Multiple recipients of list ORACLE-L Sent: Tuesday, March 04, 2003 9:49 PM

Dear all,

There's a line in .trc file:
"DUMP FILE SIZE IS LIMITED TO 0 BYTES".

"show parameter dump" in sqlplus output:

NAME                                 TYPE    VALUE
------------------------------------ ------- ------------------------------
background_core_dump                 string  partial
background_dump_dest                 string  $ORACLE_HOME/rdbms/trace
core_dump_dest                       string  ?/dbs
max_dump_file_size                   string  10240
shadow_core_dump                     string  PARTIAL
user_dump_dest                       string  $ORACLE_HOME/rdbms/trace

The value for max_dump_file_size is exactly same as 10240. So what's wrong with that?
The directory permission for the dump destination is drwxr-xr-x

By the way,
I'm using Oracle 8.1.6 on Redhat 7.2

Thanks in advance.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).