Ok... my SQL Prompt, looks like an email :-)
ARBORDBA#SIEB.al37hp48>
(# = @)
Regards,
LG
-----Original Message-----
From: "Ganhão, Luís Manuel Martins, VF-PT" [mailto:oracledba-
ezmlmshield-x24889273.[Email address protected]
Sent: quarta-feira, 18 de Agosto de 2004 12:25
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
------------------------------------------
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)
Oracle LazyDBA home page