Re: Help: Can we alter session for other sessions

From about 8.1.6, dbms_system allowed for setting integer and boolean parameters in other sessions.

e.g.

    (sid, serial#,. parameter, value)

begin

    dbms_system.set_int_param_in_session(

        16, 161, 'max_dump_file_size', 1048576     );
end;

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



charlie.peltier wrote in message ...


>I am trying to study the effect of init parameter optimizer_index_cost_adj,

>which can be changed by alter session.

>

>How can I change the session for others, like the one for sql_navigator,

>which I use for explain plan?

>Is there any way we can do that?

>

>Thanks

>

>