Database Size Limit with Oracle 10g Standard Edition
Dereck L. Dietz
I remember once seeimg 10g specifications saying the maximum database size
for the Oracle 10g Standard Edition was 500GB. Is that correct?
Thanks.
johnb...@sbcglobal.net
I do not recall anything like that.
Are there any limitations for 11g?
joel garry
Highly doubtful.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/limits.htm#i287915
http://download.oracle.com/docs/cd/B19306_01/license.102/b14199/editions.htm#BABJICBB
The problem is you can't buy the partitioning option, though nothing
says you can't roll your own or not even need it. You may have seen
some practical limitations for some particular thing, but 20 32G
files... why not try it, buy a couple "Terrabyte" disks for $100 ea...
Of course, I'm on EE, may be totally wrong.
jg
--
@home.com is bogus.
http://www3.signonsandiego.com/stories/2009/apr/23/1b23qcom21927-qualcomm-nears-deal-broadcom-lawsuit/?uniontrib
Shakespeare
The max numbers of sockets for a server to be allowed to use SE is 4. As
far as I know, that's the only limitation....
Shakespeare
Mladen Gogala
I don't think so. On 32 bit Linux, the maximum oracle file size is 32GB
and you can have at least 65500 of them, which yields 2PB (with "P" as
in Petabyte) at the very least. Where did you come across that number?
If the platform is 64 bit, and it usually is, you can have larger file
system block on the XFS file system, and it will make those numbers even
larger. If you need really big files, do try XFS, it can have block sizes
of 16k or 32k. You can also make your database block larger which may
speed up your index processing (duck & cover).
Palooka
>>
>> I remember once seeimg 10g specifications saying the maximum database size
>> for the Oracle 10g Standard Edition was 500GB. Is that correct?
>
> Highly doubtful.
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/limits.htm#i287915
> http://download.oracle.com/docs/cd/B19306_01/license.102/b14199/editions.htm#BABJICBB
>
> The problem is you can't buy the partitioning option, though nothing
> says you can't roll your own or not even need it. You may have seen
> some practical limitations for some particular thing, but 20 32G
> files... why not try it, buy a couple "Terrabyte" disks for $100 ea...
>
> Of course, I'm on EE, may be totally wrong.
>
aware there is no particular size limit on a Standard Edition database.
Palooka
gym dot scuba dot kennedy at gmail
"Mladen Gogala" <mla...@bogus.email.com> wrote in message
news:gsqif9$l73$1...@solani.org...
I thought Mauve sped up index processing?
Jim
Mladen Gogala
> The max numbers of sockets for a server to be allowed to use SE is 4. As
> far as I know, that's the only limitation....
>
> Shakespeare
Sockets or threads?
Shakespeare
> Na Thu, 23 Apr 2009 22:14:52 +0200, Shakespeare napisao:
>
>> The max numbers of sockets for a server to be allowed to use SE is 4. As
>> far as I know, that's the only limitation....
>>
>> Shakespeare
>
> Sockets or threads?
>
>
>
Sockets.
In the latest Licensing Policies, Oracle states:
"Standard Edition requires a minimum of 5 Named User Plus licenses or
the total number of actual users, whichever is greater. Oracle Database
Standard Edition can only be licensed on servers that have a maximum
capacity of 4 sockets. A blade server that meets this criteria is also
eligible for licensing this program. Effective with the release of 10g,
the Oracle Database Standard Edition product includes the Real
Applications Clusters database option."
Shakespeare
Mladen Gogala
Michael Austin
This is apparently referencing number of CPU sockets available (they can
be dual or quad core, but no more than 4 CPUS - which means up to 4
quad-core processors which means 16 cores. not shabby for a "PC".
joel garry
wrote:
Interesting cloud variant: http://www.oracle.com/corporate/pricing/cloud-licensing.pdf
jg
--
@home.com is bogus.
The warts on your naughty parts will soon be open source:
http://rockefeller.senate.gov/press/record.cfm?id=311951&
(ouch)
Shakespeare
That seems to be correct. But until March 15 2009, Oracle put this in
their license agreements:
"When licensing Oracle programs with Standard Edition One or Standard
Edition in the product name, a processor is counted equivalent to an
occupied socket; however, in the case of multi-chip modules, each chip
in the multi-chip module is counted as one occupied socket."
The only problem here is: when is a module a multi-chip module? Oracle
Sales guys say a module is the same as a core... but in that case, the
whole socket condition is in fact a multi-core condition, which
basically says:
1) If you have 1 single core (or max quad core) cpu and 3 empty sockets,
you can use Standard Edition
2) If you have 1 single core (or max quad core) cpu and 4 or more empty
sockets, you can't.
So (cores times core-factor) + (#empty sockets) must be at max. 4
SE will work however on more sockets/cores, but you violate the license
terms and will be forced to buy EE after Oracle audited your systems.
And Oracle is very active at the moment auditing systems (but I guess
this will stop by may 20, when the Fiscal Year closes)
I will check if this condition is still there in the latest License
Agreements, but I have not seen one yet.
Shakespeare
SEJ
never heard about size limitation for SE.
"gym dot scuba dot kennedy at gmail" <kenn...@verizon.net> skrev i en
meddelelse news:ishIl.2581$b11...@nwrddc02.gnilink.net...