select @@session.tx_isolation; 查询事务隔离级别
show variables like 'binlog_format%'; 查询日志格式
show variables like 'sync_binlog%'; 查询binlog 什么时候刷新到磁盘的参数
select open_mode from v$database; 检查数据库状态读写(READ WRITE)或只读(READ ONLY)[只读情况下写操作会报错:java.sql.SQLException: ORA-01552: cannot use system rollback segment for non-system tablespace '***']
select @@read_only 查询数据库上read_only参数的值。1只读 ; 0 读写
1.登录的mysql:mysql –u root –p
mysql> set global read_only=0;(关掉只读属性)
flush privileges;
2.修改mysql配置文件my.cnf,该文件在/etc目录下 设置read_only=0