DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=qRohOkOoRCFv+fnuQawQb6k7rKySkQGyYqNdJBbI2fMvEFjVlfzrGYL/FBP3adFIfgM6g3txphxAktuco4KAiW0sy9FDKgjgymj3tbDsdjVe+nRcNdpiRQYe2QP8qVO04LAlT4Z+NpUefYhStKDz7GetwGYurusIYykIp0U20ao=
Message-ID: <ad3aa4c90711291109i4e10632h2b1dc75ead5c3c4a@mail.gmail.com>
Date: Thu, 29 Nov 2007 13:09:04 -0600
From: "Andrew Kerber" <andrew.kerber@gmail.com>
To: mason@blisses.org
Subject: Re: Mysterious failure!
Cc: oracle-l@freelists.org
In-Reply-To: <20071129172640.GB4549@blisses.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_10851_16890189.1196363344441"
References: <20071129161831.GB4324@blisses.org>
	 <17E4CDE8F84DC44A992E8C00767402E0860D20@spobmexc02.adprod.directory>
	 <20071129172640.GB4549@blisses.org>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: andrew.kerber@gmail.com
------=_Part_10851_16890189.1196363344441
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Do you know what you had running at the time?  For example, were you
gathering dictionary statistic?

On Nov 29, 2007 11:26 AM, Mason Loring Bliss <mason@blisses.org> wrote:

> On Thu, Nov 29, 2007 at 10:36:57AM -0600, Taylor, Chris David wrote:
>
> > Sounds like a semaphore issue
> >
> > I believe when you use the kill or abort a process the semaphores don't
> > get cleaned up.  Though I'm a little surprised the db would start back
> > up if it was indeed a semaphore issue.
>
> Is there a way to find out? Does Oracle log its use of semaphores, or at
> least timeouts to obtain a semaphore?
>
> Also, are you suggesting that this is what made the database unresponsive
> initially? That's what I'm most after. I want to know why it became
> unresponsive, and I'm hoping someone can direct me to something that's
> been
> logged that I've overlooked.
>
> --
>    Mason Loring Bliss     mason@blisses.org       They also surf who
> awake ? sleep : dream;     http://blisses.org/     only stand on waves.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

------=_Part_10851_16890189.1196363344441
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Do you know what you had running at the time?&nbsp; For example, were you gathering dictionary statistic?<br><br><div class="gmail_quote">On Nov 29, 2007 11:26 AM, Mason Loring Bliss &lt;<a href="mailto:mason@blisses.org">mason@blisses.org
</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On Thu, Nov 29, 2007 at 10:36:57AM -0600, Taylor, Chris David wrote:
<br><br>&gt; Sounds like a semaphore issue<br>&gt;<br>&gt; I believe when you use the kill or abort a process the semaphores don&#39;t<br>&gt; get cleaned up. &nbsp;Though I&#39;m a little surprised the db would start back<br>
&gt; up if it was indeed a semaphore issue.<br><br></div>Is there a way to find out? Does Oracle log its use of semaphores, or at<br>least timeouts to obtain a semaphore?<br><br>Also, are you suggesting that this is what made the database unresponsive
<br>initially? That&#39;s what I&#39;m most after. I want to know why it became<br>unresponsive, and I&#39;m hoping someone can direct me to something that&#39;s been<br>logged that I&#39;ve overlooked.<br><div><div></div>
<div class="Wj3C7c"><br>--<br> &nbsp; &nbsp;Mason Loring Bliss &nbsp; &nbsp; <a href="mailto:mason@blisses.org">mason@blisses.org</a> &nbsp; &nbsp; &nbsp; They also surf who<br>awake ? sleep : dream; &nbsp; &nbsp; <a href="http://blisses.org/" target="_blank">http://blisses.org/
</a> &nbsp; &nbsp; only stand on waves.<br>--<br><a href="http://www.freelists.org/webpage/oracle-l" target="_blank">http://www.freelists.org/webpage/oracle-l</a><br><br><br></div></div></blockquote></div><br><br clear="all"><br>-- 
<br>Andrew W. Kerber<br><br>&#39;If at first you dont succeed, dont take up skydiving.&#39;

------=_Part_10851_16890189.1196363344441--
--
http://www.freelists.org/webpage/oracle-l