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
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: 64152
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.

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


Current Time: Sat Dec 10 07:09:59 CST 2016

Total time taken to generate the page: 0.07998 seconds