Re: AMD/64, SGA size

I would agree, it appears you are running a 32-bit version of Linux or Oracle.

But, if you really are running "Linux x86-64 AMD64" (wording from Metalink certification) and 64-bit Oracle, I would be curious which hardware vendor you are using?

It is interesting how different AMD and Intel are implementing a 64-bit version.

• More info on this at: http://www.winnetmag.com/Articles/Print.cfm?ArticleID=41096

Also, interesting that the cost of Intel Itanium 2 chips is about the same as all the good old usual (reliable and proven) Unix RISC chip vendors. - The GHz rating is in the same range too which has always been misleading (meant nothing) and is even more complicated by the now several different methods of doing 64-bit (Intel (EPIC), AMD(extends the existing x86), and all the RISC (HP,Sun,AIX,etc.) chips). See URL above.

Although (for now), Intel Itanium2 1.5GHz does appear to have the highest FP specs (but Xeon has the highest INT specs - and cheaper too).

So now what's that advantage of Itanium2 64-bit (or AMD 64-bit) (SGAs larger than they need to be :) ....
- The performance doesn't appear to be that much better ( refer to www.spec.org ).
- Look at the INT and FP for 32-bit Xeon vs. 64-bit Itanium2.

• Xeon 3.2GHz appears to be 1.5 times faster in the INT specs and Itanium2 1.5GHz (latest) is 1.5 times faster in the FP specs (yet Itanium2 is slower in the INT specs than Xeon). - What's best for Oracle ... INT or FP performance?

-- 

"Pete's" <empete2000_at_yahoo.com> wrote in message
news:6724a51f.0406040804.32c80349_at_posting.google.com...


> dm_at_belkam.com (Dmitry Melekhov) wrote in message

news:<48f1f058.0406040229.549a78db_at_posting.google.com>...


> > Hello!

> >

> > I can't get SGA size more that 1.7Gb on Mandrake 9.2/2.6.3

> > with 9.2.0.4:

> >

> > SQL> startup

> > ORACLE instance started.

> >

> > Total System Global Area 1796705872 bytes

> > Fixed Size 745040 bytes

> > Variable Size 1761607680 bytes

> > Database Buffers 33554432 bytes

> > Redo Buffers 798720 bytes

> > Database mounted.

> > Database opened.

> > SQL> alter system set shared_pool_size=1796705872;

> > alter system set shared_pool_size=1796705872

> > *

> > ERROR at line 1:

> > ORA-02097: parameter cannot be modified because specified value is

invalid


> > ORA-04033: Insufficient memory to grow pool

> >

> >

> > shmmax value is very high

> >

> > any ideas?

>


> I may be off my rocker asking this, or completely wrong, but, is the

> OS running in 32bit or 64bit mode?  Or, did you install the 32bit

> version vs. the 64 bit of Oracle?  I've seen this with the 32bit

> version of memory, to grow your SGA larger than 2GB, you need to use

> the 64 bit version.

>


> HTH,

> Pete's