Friday, February 24, 2012

The Arup Nanda Blog: AIOUG Webcast:Methodical Performance Tuning Part 2

The Arup Nanda Blog: AIOUG Webcast:Methodical Performance Tuning Part 2

3 comments:

Onkar said...

sir,

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.

Thanks,
-Onkar

Rajaram Subramanian said...

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')
/

data recovery irvine said...

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…

Translate