Home » RDBMS Server » Server Administration » Slow databases on a Solaris server after flushing buffer cache of one database (Oracle 10.2.0.3 on Solaris 10)
Slow databases on a Solaris server after flushing buffer cache of one database [message #631754] Mon, 19 January 2015 09:16 Go to previous message
orausern
Messages: 826
Registered: December 2005
Senior Member
Hi,

I have 6 databases on Oracle 10.2.0.3 (didn't get OK to upgrade to 11g yet and that is a seperate and unrelated issue). Today I flushed buffer cache of one of this database. The command just hanged for more than 20 minutes.

Then I killed that session. Since then , all databases on the solaris server are very very slow. It takes like 15 seconds to start a new session. My guess is something related to memory has gone wrong. But I really don't know enough to be sure. CAn someone please review and suggest the needful?

Thanks,
OrauserN
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: 10g to 11g upgrade
Next Topic: Startup force and shutdown abort
Goto Forum:
  


Current Time: Thu Apr 18 19:56:08 CDT 2024