Re: control files growing big

On 2 Apr 2004 12:51:56 -0800, hemasudhaind_at_hotmail.com (vikram) wrote:

>hi,
>
>In the oracle server there is a system file "sys1per1.ora" this file
>is growing to the size of 2GB. But the actually data contained there
>is just 10mb. Can anybody advice why this is growing and what to do to
>reduce the size of the file.
>
>thanks
>vikram

Likely this file is not the 'control file', but is the datafile for the SYSTEM tablespace. You can verify this by issuing select tablespace_name
from dba_data_files
where file_name = '<directory_name>\sys1per.ora'

The SYSTEM tablespace is the location of the datadictionary. The datadictionary is maintained on the fly by Oracle. Consequently the only method to reorganize the SYSTEM tablespace is to take an export, create the database again, this time choosing a smaller datafile for the system tablespace, and import.
While you mistake the SYSTEM tablespace for the controlfile, you might consider enlisting on-site the aide of someone more versed in Oracle.

Regards

--
Sybrand Bakker, Senior Oracle DBA