OraFAQ Forum: Performance Tuning » Trailing issue during processing huge data

Home » RDBMS Server » Performance Tuning » Trailing issue during processing huge data (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trailing issue during processing huge data [message #484837]

Fri, 03 December 2010 01:34

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

Michel Cadot
Messages: 68756
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 07:04:41 CDT 2025