金仓数据库常用sql-1

1.查看数据库的隔离级别
select name,setting from sys_settings where name = 'default_transaction_isolation';
select  current_setting('default_transaction_isolation');

2.修改全局隔离级别
修改参数文件中的default_transaction_isolation
alter system set default_transaction_isolation to 'repeatable read';

3.设置当前会话隔离级别
set session characteristics as transaction isolation level read uncommitted;

4.设置当前事务隔离级别
start transaction isolation level read uncommitted;
begin isolation level read uncommited read write;