[20180927]修改sql prompt提示.txt

[20180927]修改sql prompt提示.txt

--//工作測試需要,需要修改sql propmt提示加入sid,serial#,instance_number.
--//以前做過加入入sid,serial#,以此為藍本修改如下:
--//連結:http://blog.itpub.net/267265/viewspace-2058608/ => [20160317]sqlplus提示上顯示sid,serial#

$ cat ssrac.sql
--SET SQLPROMPT '&_USER.@&_CONNECT_IDENTIFIER.> '
set feedback off
set termout off
column v_sid new_value v_sid format a15
select s.sid||','||s.serial#||'@'||(select INSTANCE_number from v$instance) v_sid from v$session s where s.sid in (select sid from v$mystat where rownum=1) ;
SET SQLPROMPT '&_USER.@&_CONNECT_IDENTIFIER.(&v_sid)> '
column v_sid clear
set termout on
set feedback 6

--//測試:
SCOTT@test01p> @ver1
PORT_STRING                    VERSION        BANNER                                                                               CON_ID
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
IBMPC/WIN_NT64-9.1.0           12.1.0.1.0     Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production              0

SCOTT@test01p> @ spid
       SID    SERIAL# PROCESS                  SERVER    SPID                     PID  P_SERIAL# C50
---------- ---------- ------------------------ --------- -------------------- ------- ---------- --------------------------------------------------
       153        213 6964:4400                DEDICATED 4300                      22         40 alter system kill session '153,213' immediate;

SCOTT@test01p> @ ssrac
SCOTT@test01p(153,213@1)>