Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Amount of tablespaces in 10g

Amount of tablespaces in 10g

From: <nitelyjoy_at_ist-einmalig.de>
Date: 11 Aug 2006 13:16:52 -0700
Message-ID: <1155327412.523986.323380@i42g2000cwa.googlegroups.com>


How big is the biggest Oracle 10g database?

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?

b)
At which size I have to consider performance issues?

Thanx in advance for your answers.
NitelyJoy Received on Fri Aug 11 2006 - 15:16:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US