Re: How big can it get?

From: Mark Malakanov <markmal_at_home.com>
Date: Sun, 22 Apr 2001 00:25:23 GMT
Message-ID: <TxpE6.22060$_P.5621778@news3.rdc1.on.home.com>

Following info from support.oracle.com

---

Size of file in NT can be more 4G (NTFS). BlockSize 16Kb
Maximum blocks per Oracle datafile: 4194302 blocks Maximum datafiles per database - depends on block size

20,000 datafiles for 2 Kb Oracle block size
40,000 datafiles for 4 Kb Oracle block size
65,536 datafiles for >= 8 Kb Oracle block size

Largest datafile: 64 Gb (assuming 16 Kb Oracle block size) Largest database: 4 Pb (Petabytes)

If you are using Oracle8, then the only limitation in documented in the following alert and please review it.
67421.1 ALERT Do NOT use files >= 4Gb on NT in Oracle8

---

--
-----------------------------------------------------
Thanks,
Mark

"Jim" <JimboA_at_yahoo.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:Xns908AB9CA653B6jimboausenetserverco_at_64.154.60.92...


> How large can tablespace files grow on Window NT systems?  Someone want to

> put together a table that will be a couple of hundred GB.  Is that

> possible?

>

Received on Sat Apr 21 2001 - 19:25:23 CDT