Home » RDBMS Server » Performance Tuning » Retreiving from the Data is slow (Oracle 11g, Linux)
Retreiving from the Data is slow [message #488967] Wed, 12 January 2011 09:13 Go to next message
tariqdba
Messages: 8
Registered: January 2011
Location: Riyadh
Junior Member

Hi,

I'm extracting/retrieving the data from the oracle database using Java application it's bit slow. However, when I retrieve from the SQL server it's faster than oracle.


Please help me to fix this.

Thanks,
Tariq.
Re: Retreiving from the Data is slow [message #488968 is a reply to message #488967] Wed, 12 January 2011 09:18 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You're comparing two different DBs? Do they have the same tables? data?

Trace the session and see where the time is being spent.
Re: Retreiving from the Data is slow [message #488969 is a reply to message #488968] Wed, 12 January 2011 09:21 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
2 internet cents on different hardware Wink
Re: Retreiving the Data is slow [message #488975 is a reply to message #488969] Wed, 12 January 2011 09:50 Go to previous messageGo to next message
tariqdba
Messages: 8
Registered: January 2011
Location: Riyadh
Junior Member
Yes, they have same tables and they are also in same Network.
Re: Retreiving the Data is slow [message #488976 is a reply to message #488975] Wed, 12 January 2011 09:52 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
More seriously, are you use the same app? Its notoriously difficult to optimize a single app for two different databases, could it be the app is optimized for SQL server architecture?

[Updated on: Wed, 12 January 2011 09:52]

Report message to a moderator

Re: Retreiving the Data is slow [message #488977 is a reply to message #488976] Wed, 12 January 2011 09:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Since NOBODY can optimize SQL just by looking at it, we need a few more details.
http://www.orafaq.com/forum/m/433888/136107/#msg_433888
Please refer to URL above & be sure to provide the details requested:

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Retreiving the Data is slow [message #489366 is a reply to message #488977] Sat, 15 January 2011 03:13 Go to previous message
tariqdba
Messages: 8
Registered: January 2011
Location: Riyadh
Junior Member
Thanks for your replies....I'm using same application and it is not optimized to sql server. I will try to get the information.
Previous Topic: Query Perfomance
Next Topic: Confusion over Keep Cache (2 Merged)
Goto Forum:
  


Current Time: Thu Mar 28 09:49:50 CDT 2024