OraFAQ Forum: Server Administration » how to shutdown heavy loaded oracle machine (urgunt)

Home » RDBMS Server » Server Administration » how to shutdown heavy loaded oracle machine (urgunt)

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

how to shutdown heavy loaded oracle machine (urgunt) [message #229043]

Thu, 05 April 2007 03:06

meggens
Messages: 57
Registered: February 2007
Location: Netherlands

Member

Hi,

I'm currently facing an oracle database server (linux) with a load of 70!.....I'm not able to start an sqlplus session, I think the machine is to busy to start a new dedicated server proces...so I'm also not able to see what the application is doing on the database.

I would like to restart the database to get rid of the connection....what would be the best way?

regards,
Martin

Report message to a moderator

Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229045 is a reply to message #229043]

Thu, 05 April 2007 03:13

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Renice the sqlplus session (and background process). Wait for it to open, then SHUTDOWN IMMEDIATE/ ABORT.

You can also try to do a "top" and kill the offending processes.

Alternatively, reboot the server and hope your DB will be OK.

Report message to a moderator

Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229085 is a reply to message #229045]

Thu, 05 April 2007 05:36

meggens
Messages: 57
Registered: February 2007
Location: Netherlands

Member

Hi

Thanks for your reply.
renicing unfortunately didn't help. I first killed all the user processen and afterward all the other oracle processes and rebooted the system....everything is fine now, oracle had no problems while recovering.

Regards,
Martin

Report message to a moderator

Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229087 is a reply to message #229085]

Thu, 05 April 2007 05:42

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Next time, if there is a next Razz

This One will show you the top20 most consuming cpu processes

ps -e -o pcpu -o pid -o user -o args | sort -k 1 | tail -21r

[Updated on: Thu, 05 April 2007 05:43]

Report message to a moderator

Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229176 is a reply to message #229087]

Thu, 05 April 2007 12:17

meggens
Messages: 57
Registered: February 2007
Location: Netherlands

Member

Hi Thanks for your reply.
I'll keep this one in mind...but I hope it will not happen again Cool

Report message to a moderator

Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229185 is a reply to message #229176]

Thu, 05 April 2007 15:17

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Won't happen.

I mean, will happen.

____________________________

Explanation: you'll hope in vain - it will happen again, sooner or later.

Report message to a moderator

Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229286 is a reply to message #229185]

Fri, 06 April 2007 08:39

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Will happen, I mean won't happen, or will it? It is the wont of a operating system to get bogged down with too many processes.

Will you answer no to this question?

Twisted Evil

Report message to a moderator

Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229307 is a reply to message #229286]

Fri, 06 April 2007 10:17

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Report message to a moderator

Previous Topic:	How to offline a Partitioning?
Next Topic:	connectivity with SQL Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:22:14 CDT 2024