Re: DB slow after bounce (Windows)
- From: David Ramírez Reyes <dramirezr@xxxxxxxxx>
- To: "Mark W. Farnham" <mwf@xxxxxxxx>
- Date: Sat, 18 Jan 2014 00:15:00 -0600
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@xxxxxxxx> 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@xxxxxxxxxxxxx <javascript:_e({}, 'cvml',
> 'oracle-l-bounce@xxxxxxxxxxxxx');>
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx<javascript:_e({}, 'cvml',
> 'oracle-l-bounce@xxxxxxxxxxxxx');>]
> *On Behalf Of *TJ Kiernan
> *Sent:* Friday, January 17, 2014 6:18 PM
> *To:* 'David Ramírez Reyes'
> *Cc:* 'oracle-l@xxxxxxxxxxxxx <javascript:_e({}, 'cvml',
> 'oracle-l@xxxxxxxxxxxxx');>' (oracle-l@xxxxxxxxxxxxx <javascript:_e({},
> 'cvml', 'oracle-l@xxxxxxxxxxxxx');>); 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@xxxxxxxxx]
> *Sent:* Friday, January 17, 2014 5:14 PM
> *To:* TJ Kiernan
> *Cc:* 'oracle-l@xxxxxxxxxxxxx' (oracle-l@xxxxxxxxxxxxx)
> *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@xxxxxxxxxxx> 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@xxxxxxxxx]
> *Sent:* Friday, January 17, 2014 5:04 PM
> *To:* TJ Kiernan
> *Cc:* 'oracle-l@xxxxxxxxxxxxx' (oracle-l@xxxxxxxxxxxxx)
> *Subject:* Re: DB slow after bounce (Windows)
>
--
David Ramírez Reyes
Profesión: Padre de Familia
Other related posts:
