[PR]
Posted on Saturday, Sep 05, 2026 06:20
[PR]上記の広告は3ヶ月以上新規記事投稿のないブログに表示されています。新しい記事を書く事で広告が消えます。
SQLPlus CLOBデータ確認方法
Posted on Friday, Apr 04, 2008 10:19
SQLPlus> set lobof 1
SQLPlus> set long 50000
set lobof 1----------------------> データ表示開始位置の指定
set long 50000 --------------->データ表示範囲 (1から2000000000)
session強制切断
Posted on Friday, Mar 28, 2008 18:17
書式：alter system kill session 'sid, serial#'
sidとserial# は、v$sessionで確認。
それから、v$sessionのSelect権限は必要。
日付書式を変更
Posted on Friday, Mar 28, 2008 17:58
sqlplus> alter session set nls_date_format='YYYY/MM/DD HH24:MI:SS';
DBサーバ側リスナー確認
Posted on Friday, Mar 28, 2008 17:45
$ lsnrctl status
LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 28-3月 -2008 15:52:19
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.1.0.5.0 - Production
Start Date 02-5月 -2007 12:07:51
Uptime 331 days 3 hr. 44 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora10gR1/oracle/product/10.1.0/network/admin/listener.ora
Listener Log File /ora10gR1/oracle/product/10.1.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "SMS" has 1 instance(s).
Instance "SMS", status READY, has 1 handler(s) for this service...
Service "SMSXDB" has 1 instance(s).
Instance "SMS", status READY, has 1 handler(s) for this service...
The command completed successfully
$
session確認スクリプト
Posted on Friday, Mar 28, 2008 17:32
alter session set nls_date_format='YYYY/MM/DD HH24:MI:SS';
set linesize 10000
set pagesize 10000
set trimspool on
set echo on
col USERNAME format a20
col OSUSER format a15
col MACHINE format a15
col PROGRAM format a30
col MODULE format a20
select SID , SERIAL# , USER# , USERNAME,
STATUS , OSUSER , MACHINE, PROGRAM,
MODULE , LOGON_TIME, STATE
from v$session
order by LOGON_TIME
/