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.
Subscribe to: Post Comments (Atom)
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.
Try something like this.
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…
I think this article is useful to everyone.
สล็อต xo ฝาก-ถอน ไม่มีขั้นต่ำ"
สล็อต คือ อะไร ทำไมถึงได้รับความนิยม"
Post a Comment