too much references to old archive log in v$history_log

Hi there,

Could some one give me a clue on this concern? :

I am running an Oracle 9i database and I'm backuping it quite intensively.

I noticed that when I do a

   SQL> select * from v$log_history;

I get back the whole lists of backup files that ever have been used by the system.

I would assume that there must be a parameter limitating the number of archive file names remember by oracle to save disk space and do not let control file grows for ever... But what shall I do exactly?

Things I already tried with no success :

  I tried to set up MAXLOGHISTORY, shutdown and restarted my database, but   still have the same number of archivelog file name in v$log_history...

  While in Rman, I run DELETE ARCHIVELOG.   The unused file disapeared, but their references in v$log_history is   still there?

Thanks in advance for Any help or advice or comment!

Samuel Kortas Received on Mon Feb 24 2003 - 05:15:35 CST