Message-Id: <10732.125840@fatcity.com> From: "Koivu, Lisa" Date: Fri, 5 Jan 2001 11:19:40 -0500 Subject: 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_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 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 !=3D = 0
     = 8>     order by name;
LATCH_NAME         = NOWAIT_GETS      = NOWAIT_MISSES    NOWAIT_HIT_RATIO
------------------ = ---------------- ---------------- ----------------
cache buffers = chai         = 16164446          &nbs= p;   = 155           &nb= sp;    1
cache buffers = lru          = 10288800          &nbs= p;  = 1065           &n= bsp;    1
channel handle = poo           &nb= sp;  = 811           &nb= sp;  = 553           &nb= sp; .595
channel = operations          &n= bsp;   = 811           = 451508           =   .002
latch wait = list           &n= bsp;     = 967           &nb= sp;    = 0            = ;    1
process = allocation          &n= bsp;   = 810           &nb= sp;    = 0            = ;    1
redo = copy           &n= bsp;      = 51066386          &nbs= p;  = 1186           &n= bsp;    1
session idle = bit           &nb= sp;     = 64           &nbs= p;    = 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 =