Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
• ORA 12540: TNS:internal limit restriction exceeded
• ORA 12838 please : Is possible to append two times to the same table befo
• ORA 12838 please : Is possible to append two times to the same table before
• ora 04031
• ora 12500 on windows
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ora 12500 on windows
• ORA 01650, one idea
• ORA 01650
• ORA 4030
• ORA 12838 please : Is possible to append two times to thesametable before do
• ORA 12838 please : Is possible to append two times to thesame table before d
• ORA 01536
• ORA 03113 end of file on communication channel
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 00600:
• ORA 00020: maximum number of processes (%s) exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 01650, one idea
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650
• ORA 01650
• Subject: ora 01031
• ORA 4030
• ORA 4030
• ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
• Subject: Re: ORA 01722 invalid number
 
Subject: kolccst obj: large streams pool memory segment

Subject: kolccst obj: large streams pool memory segment

2007-10-04       - By Charles Schultz

 Back
Anyone know where I can find more information about this KOLCCST object? And
other KO objects for that matter?

SQL > select * from (select * from v$sgastat where pool = 'streams pool'
order by bytes desc) where rownum < 6;

POOL         NAME                                          BYTES
-- ---- ---- -- ---- ---- ---- ---- ---- ---- ---- -- -- ---- --
streams pool kolccst obj                              1987055480
streams pool kol raw                                   465430552
streams pool kolcalm coll                              464969704
streams pool koicnfadt adt attr                        419245184
streams pool kol vstring                               259053352

Kinda curious why we are eating so much memory. This is a downstream
database, so I expect to be using the Streams Pool. Perhaps there is a
perfectly valid reason for this, and in that case I would like to learn
about it.

--
Charles Schultz

Anyone know where I can find more information about this KOLCCST object? And
other KO objects for that matter?<br><br><span style="font-family: courier new
,monospace; color: rgb(51, 51, 153);">SQL &gt; select * from (select * from v
$sgastat where pool = &#39;streams pool&#39; order by bytes desc) where rownum
&lt; 6;
</span><br style="font-family: courier new,monospace; color: rgb(51, 51, 153);"
><br style="font-family: courier new,monospace; color: rgb(51, 51, 153);"><span
style="font-family: courier new,monospace; color: rgb(51, 51, 153);">
POOL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BYTES<
/span><br style="font-family: courier new,monospace; color: rgb(51, 51, 153);">
<span style="font-family: courier new,monospace; color: rgb(51, 51, 153);">-- --
-- ---- -- ---- ---- ---- ---- ---- ---- ---- -- -- ---- --
</span><br style="font-family: courier new,monospace; color: rgb(51, 51, 153);"
><span style="font-family: courier new,monospace; color: rgb(51, 51, 153);"
>streams pool kolccst obj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1987055480</span>
<br style="font-family: courier new,monospace; color: rgb(51, 51, 153);"><span
style="font-family: courier new,monospace; color: rgb(51, 51, 153);">streams
pool kol raw&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 465430552</span><br
style="font-family: courier new,monospace; color: rgb(51, 51, 153);">
<span style="font-family: courier new,monospace; color: rgb(51, 51, 153);"
>streams pool kolcalm coll&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 464969704</span><br style="font
-family: courier new,monospace; color: rgb(51, 51, 153);"><span style="font
-family: courier new,monospace; color: rgb(51, 51, 153);">
streams pool koicnfadt adt attr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; 419245184</span><br style="font-family: courier new,monospace;
color: rgb(51, 51, 153);"><span style="font-family: courier new,monospace;
color: rgb(51, 51, 153);">streams pool kol vstring&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
259053352
</span><br clear="all"><br>Kinda curious why we are eating so much memory. This
is a downstream database, so I expect to be using the Streams Pool. Perhaps
there is a perfectly valid reason for this, and in that case I would like to
learn about it.
<br><br>-- <br>Charles Schultz