Shared sql area in 10g versus 9i

From: Zoran Martic <zoran_martic_at_yahoo.com>
Date: Wed, 24 Aug 2005 14:19:58 -0700 (PDT)
Message-ID: <20050824211958.31144.qmail@web52611.mail.yahoo.com>

Does anybody know what is the difference between the space needed for the same cursor (SQL) in 9i and 10g?

I have heard about some 2x difference between 8i and 10g.
This will lead to "dramatic" shared_pool_size increase in 10g for havy loaded databases.

Anybody has some mathematics available.

I am very curious, because it looks that 10g is much more hungry for the cursor space in SQL Area piece of shared pool.

All parameters are the same (except maybe undocumented) in 9i and 10g and still it looks that the cursors in 10g eating much more space.

Regards,
Zoran                 

---

Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs  

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 24 2005 - 16:22:00 CDT