Home » RDBMS Server » Performance Tuning » faster processing of records needed: performance isue (oracle 9i/10g/11g)
faster processing of records needed: performance isue [message #496333] Sat, 26 February 2011 18:29 Go to next message
ashish_sun123
Messages: 45
Registered: November 2010
Location: Bangalore
Member
I have a table which is containing 20900000 records. Now pertaining to some joining condtions this table return around
400000 records.

Now these records are utilized by a report. This report takes 3-4 hours for reading almost 400000 records

We tried using pipe row clause so that the report start processing records as soon as it gets some records. Also tried to use bulk collect.


But it is not helping to a good extent. Please advice
Re: faster processing of records needed: performance isue [message #496334 is a reply to message #496333] Sat, 26 February 2011 18:34 Go to previous messageGo to next message
Barbara Boehmer
Messages: 7974
Registered: November 2002
Location: California, USA
Senior Member
Please click on the following link for things that might help and for what to post so that we can help you.

http://www.orafaq.com/forum/t/84315/43710/
Re: faster processing of records needed: performance isue [message #496474 is a reply to message #496333] Mon, 28 February 2011 08:01 Go to previous message
michael_bialik
Messages: 602
Registered: July 2006
Senior Member
You have about 21M records. IMHO - 3-4 hours to process that data is too much even using FULL table scan.
Probably your report performs some additional processing as well.

Post TKPROF.

Previous Topic: Wrong REDO log file location
Next Topic: Dynamic SQL performance
Goto Forum:
  


Current Time: Tue Sep 02 04:16:38 CDT 2014

Total time taken to generate the page: 0.21392 seconds