Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> max_dump_file_size for session

max_dump_file_size for session

From: Ben <balvey_at_comcast.net>
Date: 26 Sep 2006 10:17:38 -0700
Message-ID: <1159291058.172889.182530@i3g2000cwc.googlegroups.com>


Running 9.2.0.5 Ent Ed, AIX5L
I ran the following in preparation of tracing a users process but the trace stopped with the file size being restricted to the init.ora setting of 10000.

execute
dbms_system.set_int_param_in_session(362,42675,'max_dump_file_size' , 500000000);

I would think that maybe i entered the wrong sid, serial# but I used the same values for setting the 10046 event and the trace file was created.

execute dbms_system.set_ev(362,42675, 10046, 8, '');

what are some other reasons why the dump file would resort back to the init setting?

any help is appreciated. Received on Tue Sep 26 2006 - 12:17:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US