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;
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;
'기술관련 > Problem Solver' 카테고리의 다른 글
[PostgreSQL] Non-superuser connection limit exceeded (0) | 2005.02.25 |
---|---|
XA error: XAER_RMERR : A resource manager error has occur (0) | 2005.01.12 |
gzlog Shell (0) | 2005.01.04 |
ant eclipse memory parameter (0) | 2005.01.04 |
shell (0) | 2004.12.24 |