Only restart the oracle service, should I have restarted the db also after restarting the service?, didn't thought that could make a difference... On Friday, 17 January 2014, TJ Kiernan <tkiernan@xxxxxxxxxxx> wrote: > First impression, based on the virtual memory i/o – the assumption being > that it was set correctly and running fine ,then somebody (or Group Policy) > unset this and it took affect when the server was rebooted. > > > > http://docs.oracle.com/cd/B28359_01/win.111/b32010/tuning.htm#i1005721 > > > > HTH, > > T. J. > > > > > > *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 *David Ramírez Reyes > *Sent:* Friday, January 17, 2014 4:42 PM > *To:* 'oracle-l@xxxxxxxxxxxxx <javascript:_e({}, 'cvml', > 'oracle-l@xxxxxxxxxxxxx');>' (oracle-l@xxxxxxxxxxxxx <javascript:_e({}, > 'cvml', 'oracle-l@xxxxxxxxxxxxx');>) > *Subject:* DB slow after bounce (Windows) > > > > I have Oracle 11.0.1.0 over Windows 2008. > > > > Yesterday we had to bounce the instance due to an ora-04031 error caused > by the Automatic Memory Management system, the error is solved by patching > to 11.0.2.0 or higher (that's not the problem now). > > > > The main problem is that after bounce (I had to kill the oracle.exe > service as I couldn't even connect with sys account), the DB it's beeing so > slow. Checking the OEM Performance, I have found that the reason is a very > high I/O (virtual memory), but the difference in use is huge! > > > > The I/O was very low and constant before the bounce (at least on the last > 10 days), but now has growth about 3 or 4 times. > > > > I've found some high I/O queries that I have tuned, but they were running > faster before the bounce, any idea? > > > > I have red that some people has have similar problems but under Solaris, > seems like it's only solved after bouncing the server, not only the > instance. > > > > Any inputs are appreciated. > > > > > > David Ramírez Reyes > > > -- David Ramírez Reyes Profesión: Padre de Familia