How to check the isolation level of session and database
824735Jan 20 2011 — edited Jan 21 2011Hi,
How can the isolation level for the session and database can be checked in Oracle 11g.Also I am getting can't serialize the access for the transaction error.And while searching for the session details with this query :-
SELECT
s.osuser, vp.spid as os_pid, S.BLOCKING_SESSION blocker,
S.SID, S.SERIAL#, S.USERNAME, S.MACHINE,
Q.SQL_FULLTEXT cur_sql, PQ.SQL_FULLTEXT prev_sql,
vt.used_urec, vt.start_date
FROM
v$session S
LEFT JOIN v$sqlarea Q on S.SQL_ID = Q.SQL_ID
LEFT JOIN v$sqlarea PQ on S.PREV_SQL_ID = PQ.SQL_ID
LEFT JOIN v$process vp on s.paddr = vp.addr
LEFT JOIN v$transaction vt on s.saddr = vt.ses_addr
WHERE
S.USERNAME = 'DATABASE_NAME'
ORDER BY
S.SID;
I am getting this value "transaction isolation level serializable" in the prev_sq column what can be the cause of this.
Thanks,