Exploring initialization parameters

The initialization parameters can be set in the init.ora file. There are two common ways to find out to what value an initialization parameter is set: show parameter <param_name> in sql*plus, or select value from v$parameter where name = lower(‘param_name’) The parameters can be changed for the currently connectedsession with a alter session set … command. If a parameter should be set in another session,dbms_system.set_bool_param_in_session ordbms_system.set_int_param_in_session can ...

Get every new post delivered to your Inbox

Join other followers: