Hi,

Data stored in v$log_history table depends on maxloghistory parameter of controlfile. This parameter set during database creation or controlfile re-creation. Means if data would be more than it will overwrite and if you want to change value of same parameter and want to store more data in v$log_history then you should need to re-create controlfile.


Thanks and regards,
Rahul Jain
http://www.dbametrix.com