Or indeed level 8 would do
Niall
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Niall Litchfield
> Sent: 14 July 2003 21:49
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Performance problems VMS 8i
>
>
Hi!
One of first thing I'd check when migrating from 7 to 8i, is settings for
optimizer_index_* parameters. And of course, your tables&indexes should be
analyzed (if not still explicitly using RBO).
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]
Hi Barbara
> After an upgrade from Oracle 7.3.4 to 8.1.7.4 on
> OpenVMS, some (but not all) of our batch jobs are
> suffering severe performance degradation. One of our
> critical jobs went from 3 hours to 9 hours elapsed
> time.
>
> The reason is obvious. The solution is not. One of
> our jobs
I'm going to ask the obvious question:
Have statistics been generated for the schemas in question?
It's assumed that you're now using CBO, and if stats have
not been generated, then CBO is making assumptions about the
nature of your data.
Jared
On Monday 14 July 2003 07:54, Barbara Baker wrote