Tablespace Size for Oracle M3 Databases (AIX)

Tablespace No of db files Initial size (MB) Max size(GB) Description File system
system 11 700 unlimited Oracle /u02
undotbs 11 1500 unlimited Oracle /u03
temp 1 500 unlimited Oracle /u02
sysaux 1 500 unlimited Oracle /u03
users 1 100 5   /u05
perfstat 1 100 2 Oracle /u03
TMVXRUNT 1 200 10 Tablespace for M3 FAT, datasets, etc. /u04
TMVXTEMP 1 1000 10 Default tablespace for M3 users/schema /u04
TMVXSD 2 9000 2x10 Tablespace for M3 tables /u05
TMVXSI 3 10000 3x10 Tablespace for M3 indexes /u04
TMVXLD 1 100 10 Spare tablespace for M3 tables /u04
TMVXLI 1 100 10 Spare tablespace for M3 indexes /u05
TMVXARCH 1 50 10 Tablespace for M3 archiving /u04
redologs   6x200 -

Redo101.log

Redo201.log

Redo301.log

Redo401.log

Redo102.log

Redo202.log

Redo303.log

Redo402.log

/u06 - /u07
Initial db size   ~256 GB