Home » RDBMS Server » Performance Tuning » Database slow after attaching new storage (9.2.0.6.0 on Solaris)
Database slow after attaching new storage [message #380707] Tue, 13 January 2009 01:25 Go to next message
ajaysharma2907
Messages: 14
Registered: June 2008
Location: Delhi
Junior Member

Hi Sir,

I have a query.
My database is on sun solaris 5.9 for sun sparc -64 bit.
Oracle version is 9.2.0.6..

The attached storage from SUN i.e. T3 was running out of space, so we had purchased a new SUN FIRE 2540 storage.
The moment we attached the new storage, we started experiencing heavy loads and slow performance of the database.

The vmstat and iostat results have been attached.

We experienced loads on 2 particular mount points and then moved the datafiles to another mount points, but that has also not solved the issue.
Can i expect help from this forum.


Regards,

Ajay
Re: Database slow after attaching new storage [message #380720 is a reply to message #380707] Tue, 13 January 2009 02:19 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
It's still possible that the problem is within your application.
Re: Database slow after attaching new storage [message #381122 is a reply to message #380707] Thu, 15 January 2009 05:57 Go to previous message
rakeshgj_36
Messages: 3
Registered: January 2009
Location: INDIA
Junior Member
Have you checked the SUN FIRE 2540 is certified with 9.2 oracle DB?

[Updated on: Thu, 15 January 2009 05:57]

Report message to a moderator

Previous Topic: Performance issues
Next Topic: Qurey taking much cost
Goto Forum:
  


Current Time: Sat Dec 10 18:44:38 CST 2016

Total time taken to generate the page: 0.25460 seconds