RE: Overriding default max_dump_file

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Tue, 4 May 2004 08:41:42 -0500
Message-ID: <358728A276824E419580403633AABFD0031E130D@INDYSMAIL03.am.thmulti.com>

Thanks for the reply -- but it still does not work. Only alter system set will work, something
I hate to do.

The script is like this (bummed from Tim Gorman/Cary M):

UNDEF sid
UNDEF serial

ACCEPT sid NUMBER prompt 'Enter SID of process to trace: ' ACCEPT serial NUMBER prompt 'Enter Serial# of process to trace: '

EXEC sys.dbms_system.set_int_param_in_session (&&sid, &&serial, 'max_dump_file_size', 1073741824);
EXEC sys.dbms_system.set_ev(&&sid, &&serial, 10046, 12, '');

SELECT RTRIM(c.value,'/') || '/' || LOWER(d.instance_name) || '_ora_' ||

to_char(a.spid,'fm00000000') || '.trc' "Trace File Name"

  FROM v$process a,
       v$session b,
       v$parameter c,
       v$instance d
 WHERE a.addr =3D b.paddr
   AND b.audsid =3D sys_context('userenv', 'sessionid')
   AND c.name =3D 'user_dump_dest';                               =20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of zhu chao Sent: Monday, May 03, 2004 7:54 PM
To: oracle-l_at_freelists.org
Subject: Re: Overriding default max_dump_file_size

Hi,

Just try to Change it to MAX_DUMP_FILE_SIZE and maybe it works. I tested it on solaris/8174.
Another point, in one long running SQL, you changed the init parameter using dbms_system, it won't change. You have to wait for the session doing other SQL so that the change take effect. Regards Zhu Chao.

Original Message -----=20 From: "Thomas Jeff" <jeff.thomas_at_thomson.net> To: <oracle-l_at_freelists.org> Sent: Tuesday, May 04, 2004 8:22 AM Subject: Overriding default max_dump_file_size

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

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
-----------------------------------------------------------------
----------------------------------------------------------------
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 Tue May 04 2004 - 08:39:21 CDT

RE: Overriding default max_dump_file_size