RE: SQL*Loader performance

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_at_eds.                                             
             com>                                                       To 
             Sent by:                  "oracle-l" <oracle-l_at_freelists.org> 
             oracle-l-bounce_at_f                                          cc 
             reelists.org                                                  
                                                                   Subject 
                                       RE: SQL*Loader performance          
             01/17/2008 12:10                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             mark.powell_at_eds.c                                             
                    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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
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_at_gmail.co

             m>
To

                                       genegurevich_at_discover.com

             01/17/2008 10:35
cc
             AM                        oracle-l <oracle-l_at_freelists.org>


Subject
                                       Re: SQL*Loader performance

On Jan 17, 2008 8:12 AM, <genegurevich_at_discover.com> 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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 17 2008 - 13:36:03 CST