Re: Identify blocking session for cursor: pin S wait on X when database is hung
From: Tanel Poder <tanel_at_poderc.com>
Date: Tue, 1 Mar 2011 15:44:22 +0200
Message-ID: <AANLkTinEutYKD3qn2kAMe0XzM2=K_jDPcDdJvKH=g8=C_at_mail.gmail.com>
Yeah, -prelim is awesome. I first learned about this parameter from Jeremiah's blog too.
Date: Tue, 1 Mar 2011 15:44:22 +0200
Message-ID: <AANLkTinEutYKD3qn2kAMe0XzM2=K_jDPcDdJvKH=g8=C_at_mail.gmail.com>
Yeah, -prelim is awesome. I first learned about this parameter from Jeremiah's blog too.
Btw, what was used before -prelim - people attached to an existing (and ideally idle) server process using a debugger and called ksdhng(), ksudps(), ksudss() functions directly to dump hanganalyze, process-state or systemstate information... This sounds crazy, it actually is crazy, but can at least allow you to dump diagnostic info from a database whic is already hopelessly hung anyway... this used to be documented in metalink as well...
-- Tanel Poder Oracle Troubleshooting Blog - http://blog.tanelpoder.com Online Troubleshooting Seminars - http://tech.e2sn.com/oracle-training-seminars On Tue, Mar 1, 2011 at 2:49 PM, Pavel <ocp.pauler_at_gmail.com> wrote:Received on Tue Mar 01 2011 - 07:44:22 CST
> Hi
> Didn't hear about _prelim before. Thanks Mark!
>
> Best regards,
> Pavel.
>
> 2011/2/28 Bobak, Mark <Mark.Bobak_at_proquest.com>
>
> Hopefully, the MOS document adequately covers how to track down blocking
>> session.
>>
>>
>>
>> However, what is one to do when you cannot connect to the database?
>>
>>
>>
>> Well, you might try the ‘-prelim’ option to SQL*Plus.
>>
>>
>>
>> You can read about how it works, here:
>>
>>
>>
>> http://oradeblog.blogspot.com/2007/10/sqlplus-prelim-connection.html
>>
>>
>>
>> -Mark
>>
>> *
>> *
>>
>
-- http://www.freelists.org/webpage/oracle-l