Re: Benchmark runs - Waits on enqueue , latch free

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Wed, 30 Aug 2000 10:46:22 +0530
Message-Id: <10604.115820@fatcity.com>

NO packages pinned .
Qs. How to pin the SYS packages ?

PENDING Will check out by Setting CURSOR_SPACE_FOR_TIME=TRUE & revert back

SCRIPT :-
SQL> select owner || '.' || name OBJECT

  2          , type
  3          , to_char(sharable_mem/1024,'9,999.9') "SPACE(K)"
  4          , loads
  5          , executions execs
  6          , kept

7 from v$db_object_cache
8 where type in ('FUNCTION','PACKAGE','PACKAGE BODY','PROCEDURE') 9 and owner not in ('SYS')
10 order by owner, name
11 /

OBJECT

TYPE SPACE(K) LOADS EXECS KEP -------------- -------- ---------- ---------- --- TBAADM.LASP0003
PACKAGE 4.7 1 38 NO TBAADM.LASP0003
PACKAGE BODY 27.9 1 20 NO SQL>
SQL> select to_char(sum(sharable_mem)/1024,'9,999,999.9') "TOTAL SPACE (K)" 2 from v$db_object_cache
3 where type in ('FUNCTION','PACKAGE','PACKAGE BODY','PROCEDURE') 4 and owner not in ('SYS');

TOTAL SPACE

32.6

NOTE the menu option Corresponding to package LASP0003 quite well performing

Hence NO pinning may be Required

	-----Original Message-----
	From:	K Gopalakrishnan [SMTP:kaygopal_at_yahoo.com]
	Sent:	Tuesday, August 29, 2000 3:45 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re: Benchmark runs -  Waits on enqueue , latch free

- & AGAIN Hi Vivek !

Still benchmarking :)

> > RESULT - Most of the waits Occuring on "library
> cache"
> > a few waits on row cache objects & shared pool
> also exist
> >
> > Qs. How can this be Addressed ?

	Waits for library cache can be reduced (!!) if you set
	the paremeter CURSOR_SPACE_FOR_TIME. But in this case
	you need a little bigger shared pool size. I guess you
	have pinned most of the SYS packages and heavy reload
	packages in Shared Pool.




	=====
	With Regards !
	K Gopalakrishnan
	-----------------------------------------------------------
	#489,EastEnd Main Road,
	Jayanagar IX Block East,
	Bangalore-560069, INDIA
	Ph # + (91)-(80)- 6543672

	__________________________________________________
	Do You Yahoo!?
	Yahoo! Mail - Free email you can access from anywhere!
	http://mail.yahoo.com/
	-- 
	Author: K Gopalakrishnan
	  INET: kaygopal_at_yahoo.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

Received on Wed Aug 30 2000 - 00:16:22 CDT

Re: Benchmark runs - Waits on enqueue , latch free - & AGAIN