Home » SQL & PL/SQL » SQL & PL/SQL » Process very slow while retrieving large amount of data..... (Oracle10g,Winodws)
Process very slow while retrieving large amount of data..... [message #334249] Wed, 16 July 2008 00:00 Go to next message
sagar.d012
Messages: 1
Registered: July 2008
Location: Pondicherry
Junior Member

Hi all,
While retrieving more than 1500/2000 records from Oracle10g database the process takes minimum 10 minutes.
Still I am a newbie i don't know where the error lies. Please help me to resolve the issue.
Re: Process very slow while retrieving large amount of data..... [message #334252 is a reply to message #334249] Wed, 16 July 2008 00:03 Go to previous messageGo to next message
BlackSwan
Messages: 25282
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above
Re: Process very slow while retrieving large amount of data..... [message #334274 is a reply to message #334249] Wed, 16 July 2008 01:12 Go to previous message
Michel Cadot
Messages: 64603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It could take from a couple of microseconds to a couple of centuries depending on what you ask.

Regards
Michel
Previous Topic: It's stoped while a table was creating.
Next Topic: Index By Table
Goto Forum:
  


Current Time: Thu Mar 23 21:16:29 CDT 2017

Total time taken to generate the page: 0.07129 seconds