Mark, There are no triggers in this database; I am pretty sure of that What is VPD (RLS) - I am probably showing my ignorance here... thank you Gene Gurevich "Powell, Mark D" <mark.powell@eds. com> To Sent by: "oracle-l" <oracle-l@xxxxxxxxxxxxx> oracle-l-bounce@f cc reelists.org Subject RE: SQL*Loader performance 01/17/2008 12:10 PM Please respond to mark.powell@xxxxx om 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 -- //www.freelists.org/webpage/oracle-l