> -----Original Message----- > From: VIVEK_SHARMA > Sent: Sunday, February 04, 2001 3:38 PM > To: '[EMAIL PROTECTED]' > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
