oracle学习

select t.*, t.rowid from categorie t

select * from v$parameter where name = 'processes'
select count(*) from v$process

alter system set processes = 500 scope = spfile;

alter system set open_cursors=30000 scope=both

select count(*)    from v$session   where status = 'INACTIVE'   

select count(*) from v$open_cursor

SELECT v.name, v.value value FROM V$PARAMETER v WHERE name = 'open_cursors';


很重要的东东哦，
是测试一个程序性能的重要指标