Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Re: Memory Sizi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 23 of 23 Topic 16534 of 17418
Post > Topic >>

Re: Memory Sizing Advice

by Frank van Bortel <frank.van.bortel@[EMAIL PROTECTED] > May 16, 2008 at 09:58 AM

Helma wrote:

> The old machine was a 1 CPU machine. There was an increase of
> performance between 0 to 2 % (if i remember well) , instead of the
> 800% the CEO expected.
> 
> So if you want to try the RAM scenario, do as you please. But please
> measure your performance in response times, and not some hitratio. And
> then have a look at the difference in performance.
> 
> H.

:D

And there's a bug in 9.2 (patch 6, iirc, and it was HP specific)
that will send your response time skyhigh, because the optimizer
keeps looping the huge buffer - it simply does not understand
searching memory for 6 hours is *not* faster than giving up
after 1 second, and fetching from disk - although it may
be "cheaper".

FvB
 




 23 Posts in Topic:
Memory Sizing Advice
Pat <pat.casey@[EMAIL   2008-05-08 20:07:25 
Re: Memory Sizing Advice
"Ana C. Dent" &  2008-05-09 03:31:07 
Re: Memory Sizing Advice
Pat <pat.casey@[EMAIL   2008-05-08 20:46:14 
Re: Memory Sizing Advice
"Ana C. Dent" &  2008-05-09 04:00:52 
Re: Memory Sizing Advice
Pat <pat.casey@[EMAIL   2008-05-08 21:35:15 
Re: Memory Sizing Advice
"Ana C. Dent" &  2008-05-09 04:48:22 
Re: Memory Sizing Advice
"Arne Ortlinghaus&qu  2008-05-09 15:05:42 
Re: Memory Sizing Advice
Mladen Gogala <mgogala  2008-05-09 07:11:38 
Re: Memory Sizing Advice
"Jack" <none  2008-05-09 11:33:34 
Re: Memory Sizing Advice
"fitzjarrell@[EMAIL   2008-05-09 05:49:23 
Re: Memory Sizing Advice
Mladen Gogala <mgogala  2008-05-09 13:39:30 
Re: Memory Sizing Advice
bhonaker <bhonaker@[EM  2008-05-09 06:47:57 
Re: Memory Sizing Advice
"fitzjarrell@[EMAIL   2008-05-09 06:54:44 
Re: Memory Sizing Advice
"fitzjarrell@[EMAIL   2008-05-09 07:06:26 
Re: Memory Sizing Advice
"Mike Jones" &l  2008-05-10 08:57:32 
Re: Memory Sizing Advice
bhonaker <bhonaker@[EM  2008-05-09 07:56:32 
Re: Memory Sizing Advice
"fitzjarrell@[EMAIL   2008-05-09 08:05:53 
Re: Memory Sizing Advice
"fitzjarrell@[EMAIL   2008-05-09 08:11:12 
Re: Memory Sizing Advice
"Mike Jones" &l  2008-05-10 09:00:52 
Re: Memory Sizing Advice
Pat <pat.casey@[EMAIL   2008-05-11 08:00:48 
Re: Memory Sizing Advice
joel garry <joel-garry  2008-05-12 13:38:48 
Re: Memory Sizing Advice
Helma <helma.vinke@[EM  2008-05-14 05:27:46 
Re: Memory Sizing Advice
Frank van Bortel <fran  2008-05-16 09:58:40 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 14:40:37 CST 2008.