SirLZF的博客

查看session：　　select * from v$session where username is not null　　select username,count(username) from v$session where username is not null group by username　　当前连接数：　　select count(*) from v$process　　查看连接数参数的设置情况　　select value from v$parameter whe

sqlplus "/ as sysdba"SQL> SHUTDOWN IMMEDIATE;SQL> STARTUP MOUNT;SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;SQL> ALTER DATABASE OPEN;SQL> AL...

1.指定开启资源限制。该改变对密码资源无效，密码资源总是可用。alter system set resource_limit=true;(默认不打开)2.创建PROFILEcreate profile testlimitidle_time 30connect_time 480;注：必须要有create profile 权限，才能创建profile。3.指定用户PROFILEalter user test profile test;4.修改PROFILEalter pro

/*第1步：创建临时表空间 */create temporary tablespace user_temp tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf'size 50m autoextend on next 50m maxsize 20480m extent management local; /*第2步：创建数据表空间 */create tablespace user_data logg...

判断回滚段竞争的SQL语句：（当Ratio大于2时存在回滚段竞争，需要增加更多的回滚段）select rn.name, rs.GETS, rs.WAITS, (rs.WAITS / rs.GETS) * 100 ratiofrom v$rollstat rs, v$rollname rnwhere rs.USN = rn.usn 判断恢复日志竞争的SQL语句：（imme