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
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: 63923
Registered: March 2007
Location: Nanterre, France, http://...
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: explain plan and autotrace
Next Topic: Query taking different time in tqo schemas
Goto Forum:

Current Time: Tue Oct 25 16:27:18 CDT 2016

Total time taken to generate the page: 0.06484 seconds