RE: estat rpt - Channel Operations latch?

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Fri, 5 Jan 2001 12:27:58 -0500
Message-Id: <10732.125850@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_01C0773C.DC16EA2A
Content-Type: text/plain;

charset="iso-8859-1"

Hi Ruth,

Unfortunately no rman here. I wish.
I found a couple of bad db links by suggestion of Scott Shafer. They are now gone (the passwords were wrong). That could have caused some weirdness I guess.

Thanks for your response.
Lisa

-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: Friday, January 05, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L Subject: Re: estat rpt - Channel Operations latch?

Are you using rman for backups. Everytime you allocate a channel in rman is makes entries in the alert_sid.log so....

Just a thot,
Ruth
it is more important to be human than to be important ----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, January 05, 2001 11:20 AM

> 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."
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C0773C.DC16EA2A
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>RE: estat rpt - Channel Operations latch?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Hi Ruth, </FONT>
</P>

<P><FONT SIZE=3D2>Unfortunately no rman here.&nbsp; I wish.&nbsp; =
</FONT>
<BR><FONT SIZE=3D2>I found a couple of bad db links by suggestion of =
Scott Shafer.&nbsp; They are now gone (the passwords were wrong).&nbsp; =
That could have caused some weirdness I guess.&nbsp; </FONT></P>

<P><FONT SIZE=3D2>Thanks for your response.</FONT>
<BR><FONT SIZE=3D2>Lisa</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Ruth Gramolini [<A =
HREF=3D"mailto:rgramolini_at_tax.state.vt.us">mailto:rgramolini_at_tax.state.v=
t.us</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, January 05, 2001 11:47 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: estat rpt - Channel Operations =
latch?</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Are you using rman for backups.&nbsp; Everytime you =
allocate a channel in rman is</FONT>
<BR><FONT SIZE=3D2>makes entries in the alert_sid.log so....</FONT>
</P>

<P><FONT SIZE=3D2>Just a thot,</FONT>
<BR><FONT SIZE=3D2>Ruth</FONT>
<BR><FONT SIZE=3D2>it is more important to be human than to be =
important</FONT>
<BR><FONT SIZE=3D2>----- Original Message -----</FONT>
<BR><FONT SIZE=3D2>To: &quot;Multiple recipients of list ORACLE-L&quot; =
&lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, January 05, 2001 11:20 AM</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>&gt; Hello all, HAPPY FRIDAY!</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Anyone know what this is - channel =
operations?&nbsp; The number is kind of</FONT>
<BR><FONT SIZE=3D2>&gt; alarming !&nbsp; See below.&nbsp; I found =
nothing on metalink that discusses this.</FONT>
<BR><FONT SIZE=3D2>&gt; Then that leads to the question - what's =
channel handle pool?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Thanks ANYONE for any insight.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; SVRMGR&gt; Rem Statistics on no_wait gets of =
latches.&nbsp; A no_wait get does not</FONT>
<BR><FONT SIZE=3D2>&gt; SVRMGR&gt; Rem wait for the latch to become =
free, it immediately times out.</FONT>
<BR><FONT SIZE=3D2>&gt; SVRMGR&gt; select name latch_name,</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
2&gt;&nbsp;&nbsp;&nbsp;&nbsp; immed_gets nowait_gets,</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
3&gt;&nbsp;&nbsp;&nbsp;&nbsp; immed_miss nowait_misses,</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
4&gt;&nbsp;&nbsp;&nbsp;&nbsp; =
round((immed_gets/(immed_gets+immed_miss)), 3)</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
5&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nowait_hit_ratio</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
6&gt;&nbsp;&nbsp;&nbsp; from stats$latches</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
7&gt;&nbsp;&nbsp;&nbsp;&nbsp; where immed_gets + immed_miss !=3D =
0</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
8&gt;&nbsp;&nbsp;&nbsp;&nbsp; order by name;</FONT>
<BR><FONT SIZE=3D2>&gt; =
LATCH_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
NOWAIT_GETS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
NOWAIT_MISSES&nbsp;&nbsp;&nbsp; NOWAIT_HIT_RATIO</FONT>
<BR><FONT SIZE=3D2>&gt; ------------------ ---------------- =
---------------- ----------------</FONT>
<BR><FONT SIZE=3D2>&gt; cache buffers =
chai&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
16164446&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp; =
155&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp; 1</FONT>
<BR><FONT SIZE=3D2>&gt; cache buffers =
lru&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
10288800&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp; =
1065&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; 1</FONT>
<BR><FONT SIZE=3D2>&gt; 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</FONT>
<BR><FONT SIZE=3D2>&gt; channel =
operations&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp; =
811&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
451508&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp; .002</FONT>
<BR><FONT SIZE=3D2>&gt; latch wait =
list&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp; =
967&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp; =
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; 1</FONT>
<BR><FONT SIZE=3D2>&gt; process =
allocation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp; =
810&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp; =
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; 1</FONT>
<BR><FONT SIZE=3D2>&gt; redo =
copy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
51066386&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp; =
1186&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; 1</FONT>
<BR><FONT SIZE=3D2>&gt; session idle =
bit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp; =
64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp; =
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; 1</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>&gt; Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>&gt; Qode.com</FONT>
<BR><FONT SIZE=3D2>&gt; 4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>&gt; Suite G104</FONT>
<BR><FONT SIZE=3D2>&gt; Fort Lauderdale, FL&nbsp; 33319</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>&gt; F: 954.484.2933</FONT>
<BR><FONT SIZE=3D2>&gt; C: 954.658.5849</FONT>
<BR><FONT SIZE=3D2>&gt; <A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A></FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &quot;The information contained herein does not =
express the opinion or position</FONT>
<BR><FONT SIZE=3D2>&gt; of Qode.com and cannot be attributed to or made =
binding upon Qode.com.&quot;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Ruth Gramolini</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: rgramolini_at_tax.state.vt.us</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =

Received on Fri Jan 05 2001 - 11:27:58 CST