Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is Oracle slower than sql server

Re: Is Oracle slower than sql server

From: Papa Piquillo <oraclejva_at_yahoo.es>
Date: 27 Jul 2006 00:22:11 -0700
Message-ID: <1153984931.654386.255860@i42g2000cwa.googlegroups.com>


Faisal:
1) If the procs are not related there is no reason to put them together in a package and it can affect performance because when you call a proc into a package the hole package will be loaded in RAM. 2) You can consider using external tables instead of sqlldr. See:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6611962171229 for details.
Best regards. Received on Thu Jul 27 2006 - 02:22:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US