Home » RDBMS Server » Performance Tuning » Slow performance (Oracle 10.2.0.2, Solaris 5.8)
Slow performance [message #279152] Wed, 07 November 2007 02:30 Go to next message
kamragulshan
Messages: 63
Registered: May 2005
Location: Delhi
Member
I have installed oracle 10.2.0.2 on Solaris 5.8. I have created one datafile that resides on NFS.
When the production trying to retrieve the data through application, then it retrieve the data with a very slow speed and take 7-8 min to fetch the data whereas for some projects they retrieve the data within 1 min.
But the query is same and data read rate is very slow.

I have checked, cpu ulilization is 1-2% only.

Please help me to find out the cause of this issue.

Thanks in Advance
Gulshan
Re: Slow performance [message #279156 is a reply to message #279152] Wed, 07 November 2007 02:49 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check IO time at OS and Oracle level (see StatsPack and v$filestat).

Regards
Michel
Previous Topic: IN Sub-query select performing poorly
Next Topic: INDEX CREATION
Goto Forum:
  


Current Time: Sat Dec 10 14:46:36 CST 2016

Total time taken to generate the page: 0.08989 seconds