Re: V_LOGHIST [message #57970] |
Wed, 23 July 2003 04:57 |
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 |
|
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
|
|
|