查看句柄使用情况

select sql_text,state,n_stmt  "句柄的容量",n_used_stmt as "使用的句柄数",curr_sch,user_name,trx_id,create_time,clnt_type,clnt_ip,run_status from v$sessions;

修改句柄上限

ALTER SYSTEM SET 'MAX_SESSION_STATEMENT' =1000

Q.E.D.