Home » RDBMS Server » Performance Tuning » Trailing issue during processing huge data (Oracle 9i)
Trailing issue during processing huge data [message #484837] Fri, 03 December 2010 01:34 Go to next message
adi_bbay
Messages: 1
Registered: December 2010
Junior Member
1) Table A, B, C, D having huge data
A- 8 mn rows
B- 80 mn
C- 11 mn
D- 100 mn
2) During processing
Apprx 4 mn records will be deleted and populated in A
B -40 mn records will be deleted and populated
C - 4 mn records will be populated
D 40 mn records will be populated
3) Each table is having an index
Facing trailing issue while running process. 75-90% processing does not take time but last 10-15% takes more time.
What is the best way/practice while populating these tables to gain performance? Already using bulk collect,/insert in the existing process

Report message to a moderator

Re: Trailing issue during processing huge data [message #484840 is a reply to message #484837] Fri, 03 December 2010 02:01 Go to previous message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Insufficient data to compute.
First determine what is the reason of this.
What are the wait events?
Have you dictionary managed or locally managed tablespace?
Is there any object size modification?
...

ALWAYS post your Oracle version, with 4 decimals.

Regards
Michel

[Updated on: Fri, 03 December 2010 02:02]

Report message to a moderator

Previous Topic: Confusion about Partitioning
Next Topic: SQL query performance tuning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 14:02:37 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.