Overriding default max_dump_file_size

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Mon, 3 May 2004 19:22:22 -0500
Message-ID: <358728A276824E419580403633AABFD0021F6168@INDYSMAIL03.am.thmulti.com>

Any ideas why the following does not work? I don't get an error message, but the trace
file size will always max out at the database default of 5M. EXEC sys.dbms_system.set_int_param_in_session (&&sid, &&serial, 'max_dump_file_size', 1073741824);

Thanks.   

---

Jeffery D Thomas
DBA
Thomson Information Services
Thomson, Inc.

Email: jeff.thomas_at_thomson.net

Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba

---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Mon May 03 2004 - 19:20:01 CDT