Re: Oracle 817 freezing

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