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 -> Re: Amount of tablespaces in 10g

Re: Amount of tablespaces in 10g

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 12 Aug 2006 07:59:20 +0200
Message-ID: <44dd6e38$0$17829$626a54ce@news.free.fr>

<nitelyjoy_at_ist-einmalig.de> a écrit dans le message de news: 1155327412.523986.323380_at_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
|

  1. http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/limits002.htm#sthref4183

Regards
Michel Cadot Received on Sat Aug 12 2006 - 00:59:20 CDT

Original text of this message

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