how to check the hidden parameter for specific session.
Da HaiNov 1 2010 — edited Nov 1 2010I made a trigger, like
create or replace trigger ignite_logon_trg after logon on database
declare
session_user varchar2(30);
begin
select sys_context('USERENV','SESSION_USER') into session_user from dual;
if session_user = 'SYSTEM2' then
execute immediate 'ALTER SESSION SET "_cursor_plan_unparse_enabled" = FALSE';
end if;
end;
/
if user SYSTEM2 log in, it will change "_cursor_plan_unparse_enabled to false;
so I log in as system2, how can I check if it is "false"
thanks