Home » RDBMS Server » Performance Tuning » Methods to do tuning (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit)
Methods to do tuning [message #342986] Mon, 25 August 2008 14:33 Go to next message
pdhayan@qwest.com
Messages: 6
Registered: August 2008
Junior Member
Hi,
I'm working on an ETL Datamart application. We get data from 2 Oracle DBs & put into my DB. I've been asked to tune the load scripts. We have issues in Extract (remote DB to local stage tables) & Load (local stage to actual local tables) sides.
All the load scripts are anonymous PL/SQLs basically does insert into select from tables.
What are your suggestions to improve the perf of the loads, I'm thinkin of doing Bulk collect/Forall insert. Could you advice me with tuning methods/ways

Thanks in Advance,
Channa

Report message to a moderator

Re: Methods to do tuning [message #343039 is a reply to message #342986] Tue, 26 August 2008 00:49 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

You can also have a look at Database Performance Tuning Guide.

Regards
Michel

Report message to a moderator

Previous Topic: explain plan and autotrace
Next Topic: Query taking different time in tqo schemas
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 22:40:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.