Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> max_dump_file_size for session
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