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: 52
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

Report message to a moderator

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: 9090
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/

Report message to a moderator

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: 621
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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 15:59:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.