Re: Freeing space in the system tablespace

From: Paul Teague <teague_paul>
Date: 1995/07/05
Message-ID: <3te8c5$j8q_at_booz.bah.com>#1/1


To find out what has grown in your system tablespace, start by checking the DBA_SEGMENTS Use a statement like the following : Select owner,segment_name,segment_type,bytes,blocks,initial_extent,extents from dba_segments where the tablespace_name = 'SYSTEM'; This will show you who owns the object, what kind of object it is, how much space it currently occupies, and how big it was when it started. Since most objects in the system tablespace are owned by user 'SYS', they almost always startout at 10k is size. But they also ususally have defined a PCTINCREASE of 50. So objects grow by extents of 10k, 10k, 16k, 24k, 36k, ... Check in the Concepts Manual for a detailed explanation of PCTINCREASE Good luck

-- 
Paul Teague    Systems Engineer/Unix Admin/Oracle DBA
E-mail: teague_paul_at_.bah.com
#include <Standard disclaimer>  "All opinions voiced are my own, etc..."
Received on Wed Jul 05 1995 - 00:00:00 CEST

Original text of this message