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: 619
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: query taking lot of time
Next Topic: Subpartitions number
Goto Forum:
  


Current Time: Sat Aug 19 02:33:24 CDT 2017

Total time taken to generate the page: 0.07231 seconds