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 -> Exp in 8.0.6.1.1 vs 7.3.4.3

Exp in 8.0.6.1.1 vs 7.3.4.3

From: binoy <binoyjames_at_my-deja.com>
Date: Wed, 16 Aug 2000 21:42:13 GMT
Message-ID: <8nf1rh$qev$1@nnrp1.deja.com>

Hi,

We are running a complete export of our 1.5Tb database.

We ran it on 7.3.4 in 20 hrs. After the migration, it is taking 45 hrs and still going.

After some investigation, we see the select statements as follows:

7.3.4:
select * from acctit;

8.0.6.1.1:
select /*+ NESTED_TABLE_GET_REFS +*/ acctit.* from acctit;

The same script is being used. Any info will be appreciated.

Thanks,
binoy
binoy1_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 16 2000 - 16:42:13 CDT

Original text of this message

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