Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: System table space size in Oracle 8.0.5
Rob,
Which version are you upgrading/migrating from? Each new release of Oracle seems to require more system tablespace space than the previous versions. This is due to the change in the data dictionary requirements to support new features.
To give you an idea, one of my Oracle 8.0.5 instance is using about 40 MBytes of system tablespace size. This will vary from database to database depending on how big your data dictionary gets. For instance, lots of stored procedures and packages require space in SYS.SOURCE$ and therefore require more system tablespace space.
The Oracle installation and/or migration guides should give you an idea of what Oracle recommends.
HTH,
Brian
Rob Feehan wrote:
>
> Can anyone tell me the size that the system table space needs to be in
> 8.0.5? It seems to need a bigger initial size than previous versions.
>
> Thanks
>
> Email replies appreciated.
-- ======================================== Brian Peasland Raytheons Systems at USGS EROS Data Center These opinions are my own and do not necessarily reflect the opinions of my company! ========================================Received on Tue Aug 01 2000 - 00:00:00 CDT
![]() |
![]() |