how do i explain this ?

list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as

Re: how do i explain this ?

by: Subject: how do i explain this ? [EMAIL PROTECTED] om

RE: how do i explain this ?

You can use CURSOR_SHARING = FORCE but be careful, it's initial implementation were quite buggy and it starts with 8.1.6 (don't remember exactly). HTH, Rajesh -Original Message- Sent: Thursday, July 26, 2001 1:37 PM To: Multiple recipients of list ORACLE-L list,

Re: how do i explain this ?

Is it possible that under 7.3.2 the optimizer was rule-based (I don't know when CBO was introduced) and that under 8.1.5 it is set to CHOOSE or FIRST_ROWS or ALL_ROWS? Also, is there anyway you could move to 8.1.6 and take advantage of the CURSOR_SHARING parameter? Jon Walthour - Original

RE: how do i explain this ?

this is 8.1.5, cursor_sharing starts with 8.1.6+ (i guess) -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED] ] Reply To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: how do i explain

RE: how do i explain this ?

] Sent: Thursday, July 26, 2001 5:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: how do i explain this ? Is it possible that under 7.3.2 the optimizer was rule-based (I don't know when CBO was introduced) and that under 8.1.5 it is set to CHOOSE or FIRST_ROWS

Re: how do i explain this ?

Did you try making time_statistics=FALSE cause this is a bug in 8.1.5 which causes lots of latch free waits if it is set as TRUE From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: how do i explain this ? Date: Thu, 26

RE: how do i explain this ?

Did you try cursor_sharing=force? Regards, Waleed -Original Message- Sent: Thursday, July 26, 2001 5:37 AM To: Multiple recipients of list ORACLE-L list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool

RE: how do i explain this ?

if it is set as TRUE From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: how do i explain this ? Date: Thu, 26 Jul 2001 01:37:18 -0800 list, this application heavyly make use of literals , NO BIND VARIABLES and was running without