SQL> alter session set session_cached_cursors=0;
会话已更改。
SQL> show parameter session_cached_cursors
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
session_cached_cursors integer
0
SQL> select sid,user_name,hash_value,sql_text from v$open_cursor;
SID USER_NAME
---------- ------------------------------------------------------------
HASH_VALUE
----------
SQL_TEXT
--------------------------------------------------------------------------------
13 SYS
326321512
select sid,user_name,hash_value,sql_text from v$open_cursor
SQL> select count(*) from scott.emp;
COUNT(*)
----------
14
SQL> select sid,user_name,hash_value,sql_text from v$open_cursor;
SID USER_NAME
---------- ------------------------------------------------------------
HASH_VALUE
----------
SQL_TEXT
--------------------------------------------------------------------------------
13 SYS
326321512
select sid,user_name,hash_value,sql_text from v$open_cursor
SQL> alter session set session_cached_cursors=100;
会话已更改。
SQL> show parameter session_cached_cursors
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
session_cached_cursors integer
100
SQL> select count(*) from scott.emp;
COUNT(*)
----------
14
SQL> select sid,user_name,hash_value,sql_text from v$open_cursor;
SID USER_NAME
---------- ------------------------------------------------------------
HASH_VALUE
----------
SQL_TEXT
--------------------------------------------------------------------------------
13 SYS
326321512
select sid,user_name,hash_value,sql_text from v$open_cursor
13 SYS
4207091507
select count(*) from scott.emp
SID USER_NAME
---------- ------------------------------------------------------------
HASH_VALUE
----------
SQL_TEXT
--------------------------------------------------------------------------------
13 SYS
2723518973
SELECT NAME name_col_plus_show_param,DECODE(TYPE,1,'boolean'
SQL> select sal from scott.emp;
SAL
----------
800
1600
1250
2975
1250
2850
2450
3000
5000
1500
1100
SAL
----------
950
3000
1300
已选择14行。
SQL> select sid,user_name,hash_value,sql_text from v$open_cursor;
SID USER_NAME
---------- ------------------------------------------------------------
HASH_VALUE
----------
SQL_TEXT
--------------------------------------------------------------------------------
13 SYS
326321512
select sid,user_name,hash_value,sql_text from v$open_cursor
13 SYS
4207091507
select count(*) from scott.emp
SID USER_NAME
---------- ------------------------------------------------------------
HASH_VALUE
----------
SQL_TEXT
--------------------------------------------------------------------------------
13 SYS
2723518973
SELECT NAME name_col_plus_show_param,DECODE(TYPE,1,'boolean'
SQL> select sal from scott.emp;
SAL
----------
800
1600
1250
2975
1250
2850
2450
3000
5000
1500
1100
SAL
----------
950
3000
1300
已选择14行。
SQL> select sal from scott.emp;
SAL
----------
800
1600
1250
2975
1250
2850
2450
3000
5000
1500
1100
SAL
----------
950
3000
1300
已选择14行。
SQL> select sal from scott.emp;
SAL
----------
800
1600
1250
2975
1250
2850
2450
3000
5000
1500
1100
SAL
----------
950
3000
1300
已选择14行。
SQL> select sid,user_name,hash_value,sql_text from v$open_cursor;
SID USER_NAME
---------- ------------------------------------------------------------
HASH_VALUE
----------
SQL_TEXT
--------------------------------------------------------------------------------
13 SYS
1079182559
select sal from scott.emp
13 SYS
326321512
select sid,user_name,hash_value,sql_text from v$open_cursor
SID USER_NAME
---------- ------------------------------------------------------------
HASH_VALUE
----------
SQL_TEXT
--------------------------------------------------------------------------------
13 SYS
4207091507
select count(*) from scott.emp
13 SYS
2723518973
SID USER_NAME
---------- ------------------------------------------------------------
HASH_VALUE
----------
SQL_TEXT
--------------------------------------------------------------------------------
SELECT NAME name_col_plus_show_param,DECODE(TYPE,1,'boolean'
[本帖最后由 laojiu9 于 2009-11-1 00:58 编辑]