Home » RDBMS Server » Performance Tuning » Slow performance (Oracle, Solaris 5.8)
Slow performance [message #279152] Wed, 07 November 2007 02:30 Go to next message
Messages: 66
Registered: May 2005
Location: Delhi
I have installed oracle 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
Re: Slow performance [message #279156 is a reply to message #279152] Wed, 07 November 2007 02:49 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check IO time at OS and Oracle level (see StatsPack and v$filestat).

Previous Topic: IN Sub-query select performing poorly
Next Topic: How to improve a group by sql stmt (merged)
Goto Forum:

Current Time: Sat Aug 19 08:16:39 CDT 2017

Total time taken to generate the page: 0.47614 seconds