RE: estat rpt - Channel Operations latch?

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Fri, 5 Jan 2001 11:49:47 -0500
Message-Id: <10732.125846@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_01C07737.82FB2E60
Content-Type: text/plain;

charset="iso-8859-1"

Probably RMAN related.

Not alarming at all. There are essentially "zero" hits on this latch.

-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Friday, January 05, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L Subject: estat rpt - Channel Operations latch?

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 <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_01C07737.82FB2E60
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>estat rpt - Channel Operations latch?</TITLE>

<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV>Probably RMAN related. </DIV>
<DIV> </DIV>
<DIV>Not
alarming at all. There are essentially "zero" hits on this</DIV>
<DIV>latch.
</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader>-----Original Message----- From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Friday, January 05, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject: estat rpt - Channel Operations latch? </DIV> 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</FONT> <BR><FONT face="Courier New" size=2>------------------ 
  ---------------- ---------------- ----------------</FONT> <BR><FONT

face="Courier New" size=2>cache buffers chai         16164446              155                1 cache buffers lru          10288800             1065                1 channel handle

  poo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  811&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  553&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

.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 <A target=_blank href="http://www.qode.com">http://www.qode.com</A> "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed Received on Fri Jan 05 2001 - 10:49:47 CST