RE: SQL*Loader performance
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 Jan 2008 13:10:30 -0500
What about row triggers? Were any row triggers added to any of the
tables. If a row trigger exists on a table that you attempt to direct
load I believe that you just converted the direct load into a
conventional load.
Also I take it that VPD (RLS) was not just implemented on any of the
objects.
-- Mark D Powell --
Phone (313) 592-5148
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
genegurevich@xxxxxxxxxxxx
Sent: Thursday, January 17, 2008 11:46 AM
To: Jared Still
Cc: oracle-l
Subject: Re: SQL*Loader performance
Jared,
There were no new indices added. I am pretty sure of that since I was
the one who applied the changes.
I have also compared the list of indices on the tables before and after
the changes and they are the same.
I am very positive that the indices were dropped prior to the load, but
I need to check for that during the upcoming load. There were no LOB
columns added. There were several date , char and number columns added.
I also think that couple of columns were removed. There were nothing
else.
thank you
Gene Gurevich
"Jared Still"
<jkstill@xxxxxxxx
m>
To
genegurevich@xxxxxxxxxxxx
01/17/2008 10:35
cc
AM oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject
Re: SQL*Loader performance
On Jan 17, 2008 8:12 AM, <genegurevich@xxxxxxxxxxxx> wrote:
Jared,
What would you be looking for in the DDLs for old and new tables? I
can
post them here, but the are very very
So there have been a number of changes?
New indexes that may be enabled during data load.
LOB columns , etc.
You really need to narrow it down to a test case.
You're right, no one here is going to look at a huge DDL section.
But without a test case, everything is guessing.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
