[PR]
Posted on Thursday, Apr 24, 2025 21:48
[PR]上記の広告は3ヶ月以上新規記事投稿のないブログに表示されています。新しい記事を書く事で広告が消えます。
ストアドソース確認
Posted on Friday, Apr 11, 2008 14:11
・all_source
・user_source
スクリプト例は以下のとおり。
長いソースの場合はspoolするとよい。
------------------------------------------------------------------------------------------------------
Sqlplus > set long 50000
Sqlplus > set pagesize 10000
Sqlplus > set linesize 10000
Sqlplus > select text from user_source where name='ストアドファイル名';
------------------------------------------------------------------------------------------------------
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
$