At OracleWorld 2002 I participated on the DBA User Expert panel, and a person in the audience asked the following question: "I am designing an application that will need to load 10 to 12 million rows of data per hour into Oracle tables from flat files. What Oracle features and techniques should I be looking at to achieve this performance requirement?" I thought this was an excellent question–one that DBAs and developers on almost any project could relate to.
In this paper, we will look at some of the Oracle features and techniques that can be employed to speed up data loads from flat files into Oracle tables. Which method is ideal for a particular situation will depend on many factors–factors we will discuss throughout this paper. To demonstrate and compare data loading methods, we will load a sample data set using each of the techniques we discuss. We will compare elapsed time, CPU time, and caveats of each method, but please note that timings can vary from one run to the next and are provided for illustrative purposes only.
A few of these techniques require Oracle 9i, but most work with Oracle 7.3 and later. One tip requires the Enterprise Edition of the database software, but the rest can be used with Standard Edition or Enterprise Edition. We will be looking at a few popular ways to load data into Oracle, but remember that there are many other tips and tricks available–this is not an exhaustive list!
Read the rest of the white paper here.
No comments:
Post a Comment