Menu
Is it possible to display the current isolation config set in Sybase Adaptive Server Enterprise 12.5.4?
If so, then how can I display it?
896
To check the isolation level(s) present in the statement, the simplest way is to look at the T-SQL itself and see if any hints are present. If not, it is operating at the isolation level of the connection.
InnoDB offers all four transaction isolation levels described by the SQL:1992 standard: READ UNCOMMITTED , READ COMMITTED , REPEATABLE READ , and SERIALIZABLE .
Isolation levels are described for which concurrency side effects are allowed, such as dirty reads or phantom reads. Transaction isolation levels control the following effects: Whether locks are taken when data is read, and what type of locks are requested.
Try select from @@isolation variable :
select @@isolation
You can also read this. It says:
The current isolation level for a session
can be determined with the global variable @@isolation.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
