Re: DUMP FILE SIZE

[Arup Nanda]

 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 ----- From: shuan.tay(PCI鄭祺勛) To: Multiple recipients of list ORACLE-L Sent: Tuesday, March 04, 2003 9:49 PM Subject: DUMP FILE SIZE 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.