OraFAQ Forum: Performance Tuning » Retreiving from the Data is slow

Home » RDBMS Server » Performance Tuning » Retreiving from the Data is slow (Oracle 11g, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Retreiving from the Data is slow [message #488967]

Wed, 12 January 2011 09:13

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.

Report message to a moderator

Re: Retreiving from the Data is slow [message #488968 is a reply to message #488967]

Wed, 12 January 2011 09:18

cookiemonster
Messages: 13965
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.

Report message to a moderator

Re: Retreiving from the Data is slow [message #488969 is a reply to message #488968]

Wed, 12 January 2011 09:21

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

2 internet cents on different hardware Wink

Report message to a moderator

Re: Retreiving the Data is slow [message #488975 is a reply to message #488969]

Wed, 12 January 2011 09:50

tariqdba
Messages: 8
Registered: January 2011
Location: Riyadh

Junior Member

Yes, they have same tables and they are also in same Network.

Report message to a moderator

Re: Retreiving the Data is slow [message #488976 is a reply to message #488975]

Wed, 12 January 2011 09:52

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

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/

Report message to a moderator

Re: Retreiving the Data is slow [message #489366 is a reply to message #488977]

Sat, 15 January 2011 03:13

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.

Report message to a moderator

Previous Topic:	Query Perfomance
Next Topic:	Confusion over Keep Cache (2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 20 17:06:13 CST 2025