estat rpt - Channel Operations latch?

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Fri, 5 Jan 2001 11:19:40 -0500
Message-Id: <10732.125840@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07733.4F60875C
Content-Type: text/plain;

charset="iso-8859-1"

Hello all, HAPPY FRIDAY!

Anyone know what this is - channel operations? The number is kind of alarming ! See below. I found nothing on metalink that discusses this. Then that leads to the question - what's channel handle pool?

Thanks ANYONE for any insight.

SVRMGR> Rem Statistics on no_wait gets of latches.  A no_wait get does not 
SVRMGR> Rem wait for the latch to become free, it immediately times out.
SVRMGR> select name latch_name,
     2>     immed_gets nowait_gets,
     3>     immed_miss nowait_misses,
     4>     round((immed_gets/(immed_gets+immed_miss)), 3)
     5>       nowait_hit_ratio 
     6>    from stats$latches 
     7>     where immed_gets + immed_miss != 0
     8>     order by name;
LATCH_NAME         NOWAIT_GETS      NOWAIT_MISSES    NOWAIT_HIT_RATIO
------------------ ---------------- ---------------- ----------------
cache buffers chai         16164446              155                1
cache buffers lru          10288800             1065                1
channel handle poo              811              553             .595
channel operations              811           451508             .002
latch wait list                 967                0                1
process allocation              810                0                1
redo copy                  51066386             1186                1
session idle bit                 64                0                1

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

------_=_NextPart_001_01C07733.4F60875C
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>estat rpt - Channel Operations latch?</TITLE>
</HEAD>
<BODY>

Hello all, HAPPY FRIDAY!


Anyone know what this is - channel =
operations?  The number is kind of alarming !  See = below.  I found nothing on metalink that discusses this.  = Then that leads to the question - what's channel handle = pool?

Thanks ANYONE for any insight.  =



SVRMGR> Rem Statistics on =
no_wait gets of latches.  A no_wait get does not 
 SVRMGR> Rem wait for the =
latch to become free, it immediately times out.
 SVRMGR> select name =
latch_name,
      =
2>     immed_gets nowait_gets,
      =
3>     immed_miss nowait_misses,
      =
4>     =
round((immed_gets/(immed_gets+immed_miss)), 3)
      =
5>       nowait_hit_ratio 
      =
6>    from stats$latches 
      =
7>     where immed_gets + immed_miss !=3D = 0
      =
8>     order by name;
 LATCH_NAME         = NOWAIT_GETS      = NOWAIT_MISSES    NOWAIT_HIT_RATIO
 ------------------ =

---------------- ---------------- ----------------</FONT>

 cache buffers =
chai         = 16164446          &nbs= p;   =
155           &nb= sp;    1
 cache buffers =
lru          = 10288800          &nbs= p;  =
1065           &n= bsp;    1
 channel handle =

poo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; =
811&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; =
553&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=

sp; .595
 channel =
operations          &n= bsp;   =
811           = 451508           =   .002
 latch wait =
list           &n= bsp;     =
967           &nb= sp;    =
0           &nbsp= ;    1
 process =
allocation          &n= bsp;   =
810           &nb= sp;    =
0           &nbsp= ;    1
 redo =
copy           &n= bsp;      =
51066386          &nbs= p;  =
1186           &n= bsp;    1
 session idle =
bit           &nb= sp;     =
64           &nbs= p;    =
0           &nbsp= ;    1

 

Lisa Rutland Koivu
 Oracle Database Administrator
 Qode.com
 4850 North State Road 7
 Suite G104
 Fort Lauderdale, FL  =
33319


V: 954.484.3191, x174
 F: 954.484.2933 
 C: 954.658.5849
 <A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A>


"The =
information contained herein does not express the opinion or position = Received on Fri Jan 05 2001 - 10:19:40 CST