Re: DB slow after bounce (Windows)

From: David Ramírez Reyes <dramirezr_at_gmail.com>
Date: Sat, 18 Jan 2014 00:15:00 -0600
Message-ID: <CAJt=wvU=78JsfaR55N-LzsnG6fPUbLRBOAU_TbvjudKDBSMCUQ_at_mail.gmail.com>

There's no other process running, the db continue slow and one more memory error appeared, seems like the server bounce is now mandatory...

On Friday, 17 January 2014, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> This also seems likely to me. See if there is an extra oracle.exe still
> running.
>
> Take a look at the performance monitor on windows and gen up the memory
> view to see if there are two oracle.exe jobs (not threads within one job)
> running and duplicating occupation of memory. If this is true and you were
> previously sized to use most of the machine it makes total sense that the
> second (and active) oracle.exe is thrashing like crazy.
>
>
>
> Quite possibly if you can figure out the older one and zap it you’ll be
> fine. Otherwise a server bounce should handle it.
>
>
>
> mwf
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <javascript:_e({}, 'cvml',
> 'oracle-l-bounce_at_freelists.org');> [mailto:oracle-l-bounce_at_freelists.org<javascript:_e({}, 'cvml', 'oracle-l-bounce_at_freelists.org');>]
> *On Behalf Of *TJ Kiernan
> *Sent:* Friday, January 17, 2014 6:18 PM
> *To:* 'David Ramírez Reyes'
> *Cc:* 'oracle-l_at_freelists.org <javascript:_e({}, 'cvml',
> 'oracle-l_at_freelists.org');>' (oracle-l_at_freelists.org <javascript:_e({},
> 'cvml', 'oracle-l_at_freelists.org');>); TJ Kiernan
> *Subject:* RE: DB slow after bounce (Windows)
>
>
>
> This feels like maybe the old oracle.exe may still be holding on to memory
> – like it wasn’t freed when it crashed. I haven’t had a 4031 since moving
> to 64-bit windows, but the virtual memory paging would point me to a
> restart of the machine.
>
>
>
> Thanks,
>
> T. J.
>
>
>
>
>
> *From:* David Ramírez Reyes [mailto:dramirezr_at_gmail.com]
> *Sent:* Friday, January 17, 2014 5:14 PM
> *To:* TJ Kiernan
> *Cc:* 'oracle-l_at_freelists.org' (oracle-l_at_freelists.org)
> *Subject:* Re: DB slow after bounce (Windows)
>
>
>
> Actually, the dbconsole had crashed before the db (caused by the same ora
> error)...
>
> On Friday, 17 January 2014, TJ Kiernan <tkiernan_at_pti-nps.com> wrote:
>
> If the machine wasn’t started, then my theory is wrong.
>
>
>
> Restarting the service would have restarted the db, but you may want to
> bounce dbconsole as well. The service name is OracleDbConsole<sid>
>
>
>
> If that doesn’t help, then Sys Internals may help diagnose further,
> depending on how much you care about getting to the bottom of the problem
> vs getting it fixed (which the 3-finger salute is still an option)
>
>
>
> Thanks,
>
> T. J.
>
>
>
>
>
> *From:* David Ramírez Reyes [mailto:dramirezr_at_gmail.com]
> *Sent:* Friday, January 17, 2014 5:04 PM
> *To:* TJ Kiernan
> *Cc:* 'oracle-l_at_freelists.org' (oracle-l_at_freelists.org)
> *Subject:* Re: DB slow after bounce (Windows)
>

-- 
David Ramírez Reyes
Profesión: Padre de Familia

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

Received on Sat Jan 18 2014 - 07:15:00 CET