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
  • Attachment: io_vmstat.txt
    (Size: 1.30KB, Downloaded 1189 times)

Report message to a moderator

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: 621
Registered: July 2006
Senior Member
It's still possible that the problem is within your application.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 11:51:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.