control files growing big

Giganews Newsgroups
Subject: control files growing big
Posted by:  vikram (hemasudhai…@hotmail.com)
Date: 2 Apr 2004

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

Replies