Re: How full the SYSTEM tablespace is?

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Fri, 23 Apr 1999 18:29:39 +0200
Message-ID: <7fq7dr$sfu$1@news0.skynet.be>

There is a gauge on the left of the instance, underneath the database-writers.

If you don't find it, you can also query dba_free_space

Grace Tsai heeft geschreven in bericht <37208C5A.76F2F639_at_bnl.gov>...
>I am preparing to upgrade our Oracle Server from version 7.3.2.3.0 to
>8.0.5.
>In the manual "Oracle8, Release 8.0.5, Installation Guide for AIX-Based
>Systems",
>At the bottom of the page 5-7, it says one of the steps to "Prepare the
>Migration Utility" is
>
>"
>Verify Space in SYSTEM Tablespace
>
>An Oracle8 database requires approximately 150% as much space in the
>SYSTEM
>tablespace as the equivalent Oracle7 database. Verify that the SYSTEM
>tablespace
>in your Oracle7 database is large enough, before migrating the database.
>
>"
>
>Does anybody know to to check how full an Oracle tablespace is?
>Thanks very much in advance.
>
>Grace Tsai
>Brookhaven National Lab
>
>
Received on Fri Apr 23 1999 - 11:29:39 CDT