Confessions of an Oracle Database Junkie - Arup Nanda
The opinions expressed here are mine and mine alone. They may not necessarily reflect that of my employers and customers - both past or present. The comments left by the reviewers are theirs alone and may not reflect my opinion whether implied or not. None of the advice is warranted to be free of errors and ommision. Please use at your own risk and after thorough testing in your environment.
It was a great session. Its always a pleasure to attend session of experienced DBAs like you. I have a question. It might sound silly but its better to ask. How did you display sid & serial# before SQL prompt. I tried changing something in Glogin.sql and tried writing after logon trigger also but could not. It would be great of you if you can help me understand that.
col formatted_text new_value sqlprompt_text noprint set sqlprompt sqlprompt_text>
select sys_context('userenv','INSTANCE')||':'||s.sid||':'||s.serial#||':'||p.spid formatted_text from v$session s, v$process p where s.paddr = p.addr and s.audsid = sys_context('userenv','sessionid') /
Excellent post. I was checking constantly this blog and I’m inspired! Very helpful info specially the closing phase Ideal with such information a lot. I used to be looking for this certain information for a long time. Thanks and best of luck…
sir,
ReplyDeleteIt was a great session. Its always a pleasure to attend session of experienced DBAs like you. I have a question. It might sound silly but its better to ask. How did you display sid & serial# before SQL prompt. I tried changing something in Glogin.sql and tried writing after logon trigger also but could not. It would be great of you if you can help me understand that.
Thanks,
-Onkar
Try something like this.
ReplyDeletecol formatted_text new_value sqlprompt_text noprint
set sqlprompt sqlprompt_text>
select sys_context('userenv','INSTANCE')||':'||s.sid||':'||s.serial#||':'||p.spid formatted_text from v$session s, v$process p
where s.paddr = p.addr
and s.audsid = sys_context('userenv','sessionid')
/
Excellent post. I was checking constantly this blog and I’m inspired! Very helpful info specially the closing phase Ideal with such information a lot. I used to be looking for this certain information for a long time. Thanks and best of luck…
ReplyDelete