R: What has your experience been with 8.1.6?

From: MARCOTULLI ARMANDO <AMarcotulli_at_grupposiac.it>
Date: Fri, 27 Oct 2000 15:50:41 +0200
Message-Id: <10662.120436@fatcity.com>

Bad experience with 8162.
I posted some days ago an email "unlike upgrade" where I described our upgrade from 805 to 8162 as a nightmare. We had to wait for 40 days to know the solution. If you use CBO and have any full table space scan you may to tune them. Take a look to bug 1421166 and see the:=20 Oracle8i Designing and Tuning for Performance Release 2 (8.1.6)
A76992-01
ORDERED_PREDICATES hint, 7-35.

Our environment:
Solaris 2.6 16bit
EMC disks - 250Gb
Veritas FS

Good luck!!!
Armando

 =20
> -----Messaggio originale-----
> Da: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com]
> Inviato: marted=EC 24 ottobre 2000 20.26
> A: Multiple recipients of list ORACLE-L
> Oggetto: What has your experience been with 8.1.6?

>=20
>=20

> Sorry... I forgot to mention that we use Sun Solaris 2.6 16-bit
> architecture. We use EMC disks, Veritas and RMAN. No parallel
> server, no materialized views, no multi-threaded server,
> no need for Intermedia.

>=20

> We do have lots of home-grown apps. We have lots
> of medium-size databases, a 150Gig datawarehouse,
> and an 80Gig datamart. We are using cost-based
> optimizer, partitioned tables, and local and global
> partitioned indexes.

>=20

> Hope that helps set the stage for my previous question.

>=20

> TIA,

>=20

> Cherie

>=20
>=20

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author:=20
> INET: Cherie_Machler_at_gelco.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Oct 27 2000 - 08:50:41 CDT