OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » REBOOT DB (Unix)

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

REBOOT DB [message #503878]

Wed, 20 April 2011 03:53

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

Hey ALL,

just one question about DB, i wanna know if the DB performance will be better after the reboot of this db Sad

Report message to a moderator

Re: REBOOT DB [message #503880 is a reply to message #503878]

Wed, 20 April 2011 03:54

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No, it will be worse.

Regards
Michel

Report message to a moderator

Re: REBOOT DB [message #503881 is a reply to message #503880]

Wed, 20 April 2011 04:03

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

"this db" ?

Which one?
Why you wanna reboot/restart DB?

Sriram

Report message to a moderator

Re: REBOOT DB [message #503882 is a reply to message #503881]

Wed, 20 April 2011 04:11

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

yes restart DB Smile

Report message to a moderator

Re: REBOOT DB [message #503886 is a reply to message #503882]

Wed, 20 April 2011 04:23

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

just restart db , because sometimes i see that the DB performance will be better Smile

Report message to a moderator

Re: REBOOT DB [message #503889 is a reply to message #503886]

Wed, 20 April 2011 04:28

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

This does n`t answer My question.
Anyway you got a conclusion 'that the DB performance will be better'.

Sriram

Report message to a moderator

Re: REBOOT DB [message #503893 is a reply to message #503889]

Wed, 20 April 2011 04:33

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

THanks Ramoradba,
your question :
Why you wanna reboot/restart DB?

answer: i need to modify some FS (FILE SYS)
Now i wanna know if realy the DB need to restarted for exmple each 03 days or each one week

Best regards

Report message to a moderator

Re: REBOOT DB [message #503894 is a reply to message #503893]

Wed, 20 April 2011 04:37

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

i wanna know if realy the DB need to restarted for exmple each 03 days or each one week

Not required

Sriram

Report message to a moderator

Re: REBOOT DB [message #503896 is a reply to message #503893]

Wed, 20 April 2011 04:39

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Quote:

No, it will be worse.

Regards
Michel

I agree. It can take a long time for performance to stabilize after a re-start. For instance, you have to re-parse all your code, re-populate your DB cache.

{Fixed typo BY ROD}

[Updated on: Wed, 20 April 2011 04:41] by Moderator

Report message to a moderator

Re: REBOOT DB [message #503900 is a reply to message #503896]

Wed, 20 April 2011 04:43

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Yes Ofcourse! Michel Was Correct.
Thats why I have asked "Why you wanna reboot/restart DB?"
And OP not mentioned it proper.

Sriram

Report message to a moderator

Re: REBOOT DB [message #503901 is a reply to message #503900]

Wed, 20 April 2011 04:46

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

THank u Ram, THank u Micel

Report message to a moderator

Re: REBOOT DB [message #503903 is a reply to message #503901]

Wed, 20 April 2011 04:48

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Michel not "Micel"

Please Don`t Use IM speak.
Forum people don`t know anything about "u" so never use it .
Sriram

[Updated on: Wed, 20 April 2011 04:48]

Report message to a moderator

Re: REBOOT DB [message #503905 is a reply to message #503903]

Wed, 20 April 2011 05:00

hakim.moussaoui
Messages: 17
Registered: April 2011
Location: algerie

Junior Member

thanks for your advice Sad

Report message to a moderator

Previous Topic:	Oracle 11g R2 installation on Windows 2008 64 bit Server (merged 2 CM)
Next Topic:	Database Administration tool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 12:17:53 CST 2024