OraFAQ Forum: Server Administration » V

Home » RDBMS Server » Server Administration » V_LOGHIST

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

V_LOGHIST [message #57965]

Wed, 23 July 2003 00:48

Manu Gupta
Messages: 44
Registered: January 2002

Member

Hi All,

I have around 12000 records in V_$LOGHIST. I have few questions related to it -

1. Should I delete these records?
2. How can I delete these records?
3. Is there any impact on the performance in keeping the records?
4. What all things should I do to optimize my SYSTEM tablespace?

Thanks

Manu

Report message to a moderator

Re: V_LOGHIST [message #57966 is a reply to message #57965]

Wed, 23 July 2003 01:18

Maaher
Messages: 7065
Registered: December 2001

Senior Member

NEVER go around messing with system tables unless you like to reinstall your Oracle.

What version of Oracle are we talking about here? Is this a Parallel Server? Any other special options?

MHE

Report message to a moderator

Re: V_LOGHIST [message #57973 is a reply to message #57965]

Wed, 23 July 2003 06:06

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Maaher is right.
V_$LOGHIST is the base table fro v$loghist.
DO NOT MESSUP with dictionary.

Report message to a moderator

Previous Topic:	solaris certification
Next Topic:	Updation of Oracle database to another system??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:45:44 CDT 2024