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_at_oneneck.com> 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.
>

--
http://www.freelists.org/webpage/oracle-l