Home » RDBMS Server » Performance Tuning » Methods to do tuning (Oracle Database 10g Enterprise Edition Release - 64bit)
Methods to do tuning [message #342986] Mon, 25 August 2008 14:33 Go to next message
Messages: 6
Registered: August 2008
Karma: 0
Junior Member
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,
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: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
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.

Previous Topic: Dead lock
Next Topic: unstable sort is inapprehensible (merged)
Goto Forum:

Current Time: Tue Aug 22 12:00:19 CDT 2017

Total time taken to generate the page: 0.02285 seconds