> -----Original Message-----
> From: VIVEK_SHARMA
> Sent: Sunday, February 04, 2001 3:38 PM
> To: 'oracledba_at_lazydba.com'
> Subject: Waits on latch free for shared_pool & library Cache
>
>
> CASE Overall Fall in performance of a primarily OLTP Banking Product after
> Loading about 10 GB of Data ( thru SQL*Loader , exp/imp)into an Existing
> Database of Size 65 GB
>
> Oracle 7345 on Solaris 2.6
> 1 DB Server - E6500 , 26 CPUs , 26 GB RAM
> 2 APP Servers - SAme as DB Server
>
> - Waits on Latch Free for shared_pool , Library Cache Phenominally High
> Qs. What may be Done for the Same ?
>
> SVRMGR> select ksmchcls status,ksmchcom,sum(ksmchsiz) Bytes
> 2> from x$ksmsp
> 3> group by ksmchcls,ksmchcom
> 4> order by ksmchcls,ksmchcom;
> STATUS KSMCHCOM BYTES
> -------- ---------------- ----------
> R-free free memory 6667540
> R-freea PL/SQL MPCODE 28924
> R-freea dictionary cach 35940
> R-freea library cache 594336
> R-freea multiblock rea 272
> R-freea reserved stoppe 80
> R-freea session param v 610504
> R-freea sql area 92992
> R-perm permanent memor 11206764
> R-recr KGL handles 520676
> R-recr library cache 230564
> R-recr sql area 11488
> free free memory 24446040
> freeabl PL/SQL MPCODE 23852
> freeabl PLS cca hp desc 164
> freeabl character set m 21456
> freeabl character set o 3180
> freeabl dictionary cach 2052820
> freeabl kzull 112224
> freeabl library cache 26556604
> freeabl multiblock rea 544
> freeabl session param v 1937040
> freeabl sql area 21544832
> perm permanent memor 75818168
> recr KGL handles 7410592
> recr PL/SQL MPCODE 22272
> recr PLS non-lib hp 2096
> recr fixed allocatio 4676
> recr library cache 8967020
> recr row cache lru 2384
> recr sql area 3318024
> recr table definiti 1140
> 32 rows selected.
> SVRMGR>
> SVRMGR>
> SVRMGR> spool off
>
> freeabl - most probably stands for the memory that has been used but is
> freeable
> perm - most probably stands for the free memory not yet moved to free area
> for use
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infy.com
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).
Received on Sun Feb 04 2001 - 04:41:16 CST
