OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Database speed up

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

Database speed up [message #166743]

Sat, 08 April 2006 01:10

amkotz
Messages: 72
Registered: May 2005
Location: Bangalore

Member

hi,

I have oracle 9i database server on a Windows 2000.
It has gone slow day by day.
What are all the checks i can follow to see where is the problem( Diagnose).
Is it possible to clear the Redo log files ? After clearing them whether the server performance will really increase to some extent. ?

Thanks in advance,
Amkotz

Report message to a moderator

Re: Database speed up [message #166770 is a reply to message #166743]

Sat, 08 April 2006 05:50

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

Senior Member
Account Moderator

What do you mean by 'clearing redologs'?

Report message to a moderator

Re: Database speed up [message #166772 is a reply to message #166743]

Sat, 08 April 2006 06:02

amkotz
Messages: 72
Registered: May 2005
Location: Bangalore

Member

I mean some how logs can be cleared.
The log files can be cleared ! I think.
i am not sure.

Report message to a moderator

Re: Database speed up [message #166776 is a reply to message #166772]

Sat, 08 April 2006 06:32

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

Senior Member
Account Moderator

Do not touch your ORL ( Online Redo logs), unless you want to put yourself in trouble.

>>What are all the checks i can follow to see where is the problem( Diagnose).
It is a very broad question. None cannot answer your question in a single line.
You may want to start here.
http://www.orafaq.com/forum/t/51267/42800/
Followed by
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/toc.htm

Report message to a moderator

Previous Topic:	migrating SYS from DICT to LOCAL
Next Topic:	about PCT in mv_capabilities_table.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 08:39:29 CST 2024