Shared sql area in 10g versus 9i
- From: Zoran Martic <zoran_martic@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Aug 2005 14:19:58 -0700 (PDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
