Re: Performance Issues doing exports 8.0.4 to 7.3.3

In article <395CA652.65FF76C2_at_theALLIEDgroup.com>,   Ted Viadella <ted_at_theALLIEDgroup.com> wrote:
> You shouldn't be able to do an export of an 8.0.4 database and import
 to a
> 7.3.3. db. there were many changes to the database in Oracle 8. I
 know
> Oracle will not support going backwards.
>

sure we do.

you run catexp7.sql in the 8.x database. you use exp from v7 over sqlnet to do the export. it only gets things that v7 can understand.

So the export / import works just fine.

The problem below sounds like they might be using CBO and have forgotten to analyze the tables in the 7.x instance.

> jamora_at_my-deja.com wrote:
>
> > Hello
> >
> > I would like to see if someone can help us with this situation we
 are
> > facing.
> >
> > We have two servers one for production and one for testing, in
> > production we are running Oracle 8.0.4 and in testing we are running
> > 7.3.3 both PCs are NT machines with 512Mb of memory, the database is
> > our payroll and it is barely 7GB.
> >
> > We use the test server just to test the user queries, and programs
 just
> > to see if they work and not stress our production server.
> >
> > We just installed 8.0.4 about 1 month ago, and when we started
> > exporting from 8.0.4 to 7.3.3 the performance on the test databases
 got
> > really bad, we ran explain plans on the same query on both servers
 and
> > in the 7.3.3 we get full table scans while in 8.0.4 we get accesses
 by
> > rowid etc. We checked the indexes and they have the same indexes,
 same
> > tablespaces, only thing is the move from 8.0.4 to 7.3.3
> >
> > Any ideas?
> >
> > Thank you Very Much
> >
> > Angel Mora
> > jamora_at_my-deja.com
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.