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: 25033
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: 64102
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: Fri Dec 02 20:52:43 CST 2016

Total time taken to generate the page: 0.19083 seconds