RE: DATABASE TUNING

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Mon, 18 Sep 2000 17:17:13 GMT
Message-Id: <10623.117270@fatcity.com>

it's new in 8.1.6 and you have to have compatible set to 8.1.6 in your init.ora

Cons? well, it doesn't keep each statement in the shared pool, so if you are repeating the EXACT statement (constants and all), it will still get changed.

so far, I haven't found any real problems with it.

Rachel

>From: Cherie_Machler_at_gelco.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: DATABASE TUNING
>Date: Mon, 18 Sep 2000 07:01:49 -0800
>
>Rachel,
>
>What version is this cursor_sharing parameter introduced in? What are the
>cons
>of using it?
>
>Thanks for specifically bringing this interesting feature up.
>
>Cherie
>
>
>--
>Author:
> INET: Cherie_Machler_at_gelco.com
>
>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).

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Mon Sep 18 2000 - 12:17:13 CDT