Re: Amount of tablespaces in 10g

nitelyjoy_at_ist-einmalig.de wrote:
> > > a)
> > > One tablespace is limited to 128 terabyte of data blocks (in Oracle
> > > 10g), both for smallfile and bigfile tablespaces. Is there a limitation
> > > for the amount of tablespaces?
> >
> > Have you looked at the docs?
> >
> > http://tahiti.oracle.com
>
> yes, i found:
>
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7003.htm#i2215114
>
> " * A bigfile tablespace contains only one datafile or tempfile,
> which can contain up to approximately 4 billion (232) blocks. The
> maximum size of the single datafile or tempfile is 128 terabytes (TB)
> for a tablespace with 32K blocks and 32TB for a tablespace with 8K
> blocks.
> * A smallfile tablespace is a traditional Oracle tablespace, which
> can contain 1022 datafiles or tempfiles, each of which can contain up
> to approximately 4 million (222) blocks.
> "
> ..., but nothing about the amount of tablespaces allowed in one
> instance. Where can I find information about that?

Look up maxdatafiles and db_files. Since tablespaces are made up of one or more data files, your platform limit is the maximum allowed. Also, they are in databases, many instances can access a database. Read the concepts manual to understand the difference.

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams049.htm#sthref206 http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5003.htm

So, what are you going to use all those exabytes for?

http://web51-01.oracle.com/oowsf2004/1159.pdf (See page 36).

>
> >
> > > b)
> > > At which size I have to consider performance issues?
> >
> > When the amount of space required exceeds your budget.
>
> So I'm relieved again, to hear that ;-)

You need to design in performance before you have any size. Sorry.

jg

--
@home.com is bogus.
"Pseudo-Attention Deficit Disorder:  Some programmers are perversely
wired. It is not uncommon for them to be sitting in a meeting and using
a hand-held device to exchange instant messages surreptitiously -
with someone in the same meeting." -
http://www.softpanorama.org/Social/overload.shtml