1

Topic: What request it is possible to learn current isolation level of Oracle Database 11g

Actually a question in a subject.
Thanks!

2

Re: What request it is possible to learn current isolation level of Oracle Database 11g

Actually ...

3

Re: What request it is possible to learn current isolation level of Oracle Database 11g

Viewer;
To campaign of the rights is not present - writes  or the user does not exist
Same it is possible to learn:
SELECT s.sid, s.serial#;
CASE BITAND (t.flag, POWER (2, 28))
WHEN 0 THEN ' READ COMMITTED'
ELSE ' SERIALIZABLE'
END AS isolation_level
FROM v$transaction t, v$session s
WHERE t.addr = s.taddr
AND s.sid = ' myShema ';

4

Re: What request it is possible to learn current isolation level of Oracle Database 11g

Somewhere here it already sounded [spoiler trans_level]

create table trans_check as select * from dual
/
create package trans_level as
function is_readonly return boolean;
function is_serialize return boolean;
function level_name return varchar2;
end;
/
create package body trans_level as
DB_readonly exception;
cant_serialize exception;
pragma exception_init (DB_readonly,-1456);
pragma exception_init (cant_serialize,-8177);
function is_readonly return boolean is
begin
savepoint a;
update trans_check set dummy=dummy;
rollback to a;
return false;
exception
when DB_readonly then
return true;
end;
function is_serialize return boolean is
val trans_check.dummy%type;
procedure try_upd is
pragma autonomous_transaction;
begin
update trans_check set dummy=dummy;
commit;
end;
begin
savepoint a;
select dummy into val from trans_check;
try_upd;
update trans_check set dummy=dummy;
rollback to a;
return false;
exception
when cant_serialize then
return true;
when DB_readonly then
return false;
end;
function level_name return varchar2 is
begin
return case when is_readonly then ' READ ONLY'
when is_serialize then ' SERIALIZABLE'
else ' READ COMMITED'
end;
end;
end;
/

[/spoiler]