Re: Long running roll back
- From: "Ram Raman" <veeeraman@xxxxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Oct 2008 10:03:23 -0500
It is Unix.
The Unix process was still running this morning. I killed it from from the
OS. Thanks for your help.
On 10/15/08, Mercadante, Thomas F (LABOR) <
Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:
>
> Ram,
>
>
>
> Is this on Unix? Do you see a unix process # 19385 still active? This is
> the spid value from your query. Kill -9 that process and see if this
> session goes away.
>
>
>
> Tom
>
>
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Ram Raman
> *Sent:* Tuesday, October 14, 2008 6:53 PM
> *To:* Allen, Brandon
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Re: Long running roll back
>
>
>
> Thanks.
>
>
>
> When I saw it, it was a very long running Select. Could it be part of a
> transaction that probably had updates before this select? That is what is
> preventing me from killing it on the OS side. But then I dont see anything
> on v$transaction.
>
>
>
> It is a third party application that I dont know much about.
>
>
>
>
>
> On 10/14/08, *Allen, Brandon* <Brandon.Allen@xxxxxxxxxxx> wrote:
>
> If there is nothing in v$transaction, then why do you suspect rollback is
> taking place?
>
>
>
> Was it just a SELECT statement, or was it DML?
>
>
>
> Why don't you just kill the CPU hog from the OS?
>
>
>
>
> ------------------------------
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
>
>
Other related posts:
