oracle open_cursor

xxx@XXXX0001[/apl/xxx]> sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on 火 Dec 21 16:30:59 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


SQL> connect sys/change_on_install@xxxdbxx as sysdba
接続されました。
SQL> show parameter open

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 300
open_links integer 4
open_links_per_instance integer 4
read_only_open_delayed boolean FALSE
session_max_open_files integer 10

SQL>select sql_text from v$open_cursor where user_name='xxx';
SQL>select * from v$session where username='xxx';
SQL>select sql_text,hash_value from v$open_cursor where user_name='xxx' order by HASH_VALUE;