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: 66
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

Report message to a moderator

Re: Slow performance [message #279156 is a reply to message #279152] Wed, 07 November 2007 02:49 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Check IO time at OS and Oracle level (see StatsPack and v$filestat).

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 20:20:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.