[color=darkred]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'; [/color]
[color=blue]很重要的东东哦，
是测试一个程序性能的重要指标[/color]
相关资源：Oracle完全学习手册.pdf
