Kevin Kempf's Blog

October 28, 2009

That’s so 1980’s….

Filed under: Oracleisms — kkempf @ 9:44 am


Nice bytes!

On a lighter note, when I cranked up my 11.2 RDBMS today, it looked like this:

Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2220200 bytes
Variable Size             578817880 bytes
Database Buffers          482344960 bytes
Redo Buffers                5554176 bytes

Seriously, does anyone allocate an Oracle database’s memory settings in bytes anymore?  What I really love is when the buffer cache is so large it uses scientific notation to display memory allocation.  Time to step into the 21st century, I’d say, and show these startup allocations in MB or GB…


Create a free website or blog at