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

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Tue, 29 Aug 2000 02:12:32 -0700 (PDT)
Message-Id: <10603.115708@fatcity.com>

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! Received on Tue Aug 29 2000 - 04:12:32 CDT