RE: "session param valu" in x$ksmlru

Thanks Tanel!
Just to follow up on he same, I see a lot of the following when I query x$ksmlru on hourly basis:  

KSMLRCOM                            KSMLRSIZ    KSMLRNUM
session param valu     27,480     656                                          0
session param valu     27,480       8                                          0
session param valu     27,480     504                                          0
session param valu     27,480     151                                          0
 

It seems that these cause a lot of flushes. Are these chunks of type "freeable"?  

Amir

	From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel Põder
	Sent: Wednesday, February 08, 2006 3:21 AM
	To: ORACLE-L
	Subject: Re: "session param valu" in x$ksmlru
	
	
	You need this for storing the array of session parameter values (seen from x$ksppcv) for each session.
	 
	Tanel.
	 

		----- Original Message ----- 
		From: Hameed, Amir <mailto:Amir.Hameed_at_xerox.com>  
		To: oracle-l_at_freelists.org 
		Sent: Tuesday, February 07, 2006 11:43 PM
		Subject: "session param valu" in x$ksmlru


		Folks, 
		Does anyone know what the value "session param valu" in column x$ksmlru.ksmlrcom means? 

		Thanks 
		Amir 

--
http://www.freelists.org/webpage/oracle-l