Message-Id: <10732.125846@fatcity.com> From: "Mohan, Ross" Date: Fri, 5 Jan 2001 11:49:47 -0500 Subject: RE: estat rpt - Channel Operations latch? 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@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 "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" estat rpt - Channel Operations latch?
Probably RMAN related.
 
Not alarming at all. There are essentially "zero" hits on this
latch.
-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu@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

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