Home » RDBMS Server » Server Administration » Re: V_LOGHIST
Re: V_LOGHIST [message #57970] Wed, 23 July 2003 04:57 Go to next message
Manu Gupta
Messages: 44
Registered: January 2002
Member
:-) I am using Oracle 8.1.7 without any replication or parallel server.

Manu
Re: V_LOGHIST [message #57978 is a reply to message #57970] Wed, 23 July 2003 07:44 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I don't think 12K records will decrease performance.
The number Log History records is dependent on the system parameter "maxloghistory". This parameter is set when the control file has been created and cannot be reset afterwards. I wouldn't worry too much, since this is only relevant for Parallel Server.

Related views are: V$LOG_HIST (the V_$ variant is the internal SYS view) and V$LOG_HISTORY.

MHE
Previous Topic: Updation of Oracle database to another system??
Next Topic: solaris/oracle
Goto Forum:
  


Current Time: Fri Sep 20 13:41:02 CDT 2024