Re: Memory Limit Imposed on Oracle by Windows?

dbaplusplus_at_hotmail.com wrote:

> Of couuse there are some overheads which you point out, but how much
> CPU ovethead one is talking vs disk based
> access. which takes mili seconds . CPU based access takes micro
> secinds. Do the math for your application.

A lot of people have done the testing. And what you assume is not necessarily the case.

Here is one example among many:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5408706816128

> Those people who advise you to limit memory to 640K or stay away from
> large buffer cache are plain wrong. Why there are in memory dataase,
> why Oracle has developed/acquired TEN TIMES database, Why in TPC
> benchamrks, they use hundreads of GB"s of buffer cache.

The reason TimesTen is so fast has little to do with what you assume. It is not just a question of throwing a lot of RAM at the problem. You should study the underlying concepts and architecture before trying to draw a line between the Oracle RDBMS and TimesTen. They are totally different beasts.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org