Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 817 freezing

Re: Oracle 817 freezing

From: Sergey Popov <sspopov_at_gmail.com>
Date: Mon, 22 Jan 2007 20:01:17 -0500
Message-ID: <d9f8ed890701221701v74fd5dc1xa6eca0de6e4af78c@mail.gmail.com>


Is database running in archivelog mode? Check you alert.log file on error messages.
Check log_archive_start parameter value, log_archive_dest location on space available.
Everything you are talking about is pointing on this problem.

Sergey

On 1/22/07, Richard J. Goulet <rgoulet_at_kanbay.com> wrote:
>
> Brandon,
>
> One of the problems we're having is that we can't execute anything
> except "shutdown abort". Anything else just runs off into lala land.
>
>
>
> Dick Goulet, Senior Oracle DBA
>
> 45 Bartlett St Marlborough, Ma 01752, USA
> *Tel.:* 598.573.1978 |F*ax: * 508.229.2019 | Cell:508.742.5795
>
> RGoulet_at_kanbay.com
>
> : POWERING TRANSFORMATION
>
>
> ------------------------------
> *From:* Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com]
> *Sent:* Monday, January 22, 2007 2:57 PM
> *To:* Richard J. Goulet; oracle-l_at_freelists.org
> *Subject:* RE: Oracle 817 freezing
>
> Is there a large transaction rolling back?
>
> Try this query:
>
> select s.username, s.sid, t.addr, t.status, t.used_ublk, decode(bitand(
> t.flag,128),0,'NO','YES') rolling_back from v$session s, v$transaction t
> where s.taddr=t.addr;
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Richard J. Goulet
>
> 3: Database will not shutdown immediate even after half an hour of
> waiting. Must use shutdown abort.
>
> 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
Received on Mon Jan 22 2007 - 19:01:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US