"session param valu " in x$ksmlru

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

"session param valu " in x$ksmlru

"session param valu " in x$ksmlru

2006-02-08 - By Hameed, Amir

Reply: 1 2 3 4 5 6 7 8

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@(protected) [mailto:oracle-l-bounce@(protected)] 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@(protected)>
To: oracle-l@(protected)
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>"session param valu" in x$ksmlru</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1528" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=470204715-08022006><FONT
face="Comic Sans MS" color=#800000 size=2>Thanks Tanel!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470204715-08022006><FONT
face="Comic Sans MS" color=#800000 size=2>Just to follow up on he same, I see a
lot of the following when I query x$ksmlru on hourly basis:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470204715-08022006><FONT
face="Comic Sans MS" color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470204715-08022006><FONT
face="Comic Sans MS" color=#800000
size=2>KSMLRCOM          
             
    
KSMLRSIZ    KSMLRNUM</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470204715-08022006><FONT face="Courier New"
color=#800000 size=2>session param valu    
27,480    
656            
             
             
   
0<BR>session param valu    
27,480      
8             
             
             
  
0<BR>session param valu     27,480    
504            
             
             
   
0<BR>session param valu     27,480    
151            
             
             
   
0</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470204715-08022006><FONT
face="Comic Sans MS" color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470204715-08022006><FONT
face="Comic Sans MS" color=#800000 size=2>It seems that these cause a lot of
flushes. Are these chunks of type "freeable"?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470204715-08022006><FONT
face="Comic Sans MS" color=#800000 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470204715-08022006><FONT
face="Comic Sans MS" color=#800000 size=2>Amir</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Tanel
Põder<BR><B>Sent:</B> Wednesday, February 08, 2006 3:21 AM<BR><B>To:</B>
ORACLE-L<BR><B>Subject:</B> Re: "session param valu" in
x$ksmlru<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2>You need this for storing the array of session
parameter values (seen from x$ksppcv) for each session.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Tanel.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
#000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">-- -- Original Message -- -- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:<
/B>
<A title=Amir.Hameed@(protected) href="mailto:Amir.Hameed@(protected)">Hameed,
Amir</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=oracle-l@(protected)
href="mailto:oracle-l@(protected)">oracle-l@(protected)</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, February 07, 2006 11:43
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> "session param valu" in
x$ksmlru</DIV>
<DIV><BR></DIV>
<P><FONT face="Comic Sans MS" size=2>Folks,</FONT> <BR><FONT
face="Comic Sans MS" size=2>Does anyone know what the value "session param
valu" in column x$ksmlru.ksmlrcom means?</FONT> </P>
<P><FONT face="Comic Sans MS" size=2>Thanks</FONT> <BR><FONT
face="Comic Sans MS" size=2>Amir</FONT>
</P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>