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 -----
From: "Koivu, Lisa" <lkoivu_at_qode.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, January 05, 2001 11:20 AM
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."
Received on Fri Jan 05 2001 - 10:44:08 CST