参数

cursor_sharing:

提示：强制SQL硬解析，避免children cursor过多还来的负面性能影响

cursor_sharing_exact

例

sqlplus "/as sysdba"

create user dbusrgfc101 identified by hhgfc;

grant connect,resource,dba to dbusrgfc101

connect dbusrgfc101/hhgfc

create table ebin as select * from dba_usrs;

alter session set cursor_sharing=similar

select count(*) from ebin where username='DBUSRGFC101';

select count(*) ebin where suername='SYS'

ITPub博客

绑定变量