Re: severe lib cache contention - how did i solve it

u did not have to do that the timed_statistics and sql_trace if set to false will do the job From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: severe lib cache contention - how did i solve it Date: Thu, 26 Jul 2001 22

RE: severe lib cache contention - how did i solve it

recipients of list ORACLE-L Subject: Re: severe lib cache contention - how did i solve it u did not have to do that the timed_statistics and sql_trace if set to false will do the job From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

severe lib cache contention - how did i solve it

list, i increased the kgl latches to 11 (from 3) and switched OFF the timed statistics and all the waits for lib cache and shared pool latch are gone !! thanks for pointing me to the timed statistic bug.. (i dont know how much the kgl parameter helped though) regards Rahul -- Please