Re: ASSM vs MANUAL - freelists + freelist groups

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Mon, 25 Apr 2005 00:20:33 -0700 (PDT)
Message-ID: <20050425072033.67364.qmail@web52601.mail.yahoo.com>

Hi Sean,

If you look the similar thread maybe two months ago on this forum, where I posted some results for HP (11, 11i) and Solaris (Sol 7, 8 and 9), both 9.2.0.6 and 10.1.0.3 you will see that I could not manage to get better results with MANUAL.

ASSM was beating MANUAL all the time, from 15% to more then 30%. Maybe it is something strange with my databases/environments that they are tuned to work better with ASSM :)

I am curious now is the version of Oracle you are using less then 9.2.0.5/6 or the OS is not Solaris/HP?

When you said the result is different would you provide the difference in real CPU time used here from v$sesstat when using ASSM and MANUAL?

You obviously need to push the system to be under more pressure where old MANUAL method will be the same or even better then ASSM or just to have the bottleneck somewhere else, like log file sync or log buffer space, ...

>From the pure CPU usage I would like to see real statistics where MANUAL is beating ASSM.

Regards,
Zoran Martic

• Sean Hull <shull_at_iheavy.com> wrote:
  > Does this seem like the right order of magnitude
  > improvement I should
  > expect on INSERTs? Should I ever get say 2x or 3x
  > as many inserts on
  > manual segment space management table versus an
  > ASSM?
  

  ---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Mon Apr 25 2005 - 03:24:47 CDT