Are you running 10g? I read somewhere that the 2GB limit was gone on 10g on
windows, but I can't find anything else to verify that. If that is truly
the case, I'll spend a little money and move my new server up to 8GB!
Thanks,
Mark
-----Original Message-----
From: Ganhão [mailto:Ganhão]
Sent: Wednesday, August 18, 2004 5:25 AM
To: LazyDBA Discussion
Subject: RE: SGA size - Urgent
I think this answer your question...
[Email address protected] show sga
Total System Global Area 5941316072 bytes
Fixed Size 104936 bytes
Variable Size 3252654080 bytes
Database Buffers 2684354560 bytes
Redo Buffers 4202496 bytes
As you can see in SQL Prompt... it's an hp
Regards,
Luís Ganhão
Novabase Portugal
-----Original Message-----
From: Ofer Harel [mailto:oracledba-ezmlmshield-
x31000760.[Email address protected]
Sent: quarta-feira, 18 de Agosto de 2004 13:25
To: LazyDBA Discussion
Subject: SGA size - Urgent
Good morning,
I always thought that SGA size is limit to 2G in all kind of
servers.
Also I thought that 3G or 4G options for SGA size are general
options
After reading notes 46001.1 and 116076.1 which refers to Windows
only, I 'm
getting confused
Question:
1. Is there a limit to SGA size on Sun Solaris or HP machine
2. Does the 3G and 4G option for SGA size are available outside of
Windows
machines
TIA
regards
Ofer Harel
DBA team
013Barak
[Email address protected]
******************************************************************
****
The information contained in this e-mail message may be
privileged and confidential. The information is intended only
for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have
received this communication in error, please notify us
immediately by telephone, or by e-mail and delete the message
from your computer. Thank you!
Unless otherwise stated, any views or opinions expressed in
this e-mail are solely those of the author and do not represent
those of
Barak I.T.C (1995) The International Telecommunications Services
Corp. Ltd.
******************************************************************
****
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
------------------------------------------
This message may contain confidential information or privileged material,
and is intended only for the individual(s) named. If you are not in the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message
which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
Vodafone (Portugal)
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page