Home » RDBMS Server » Server Administration » how to shutdown heavy loaded oracle machine (urgunt)
how to shutdown heavy loaded oracle machine (urgunt) [message #229043] Thu, 05 April 2007 03:06 Go to next message
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
Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229045 is a reply to message #229043] Thu, 05 April 2007 03:13 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229085 is a reply to message #229045] Thu, 05 April 2007 05:36 Go to previous messageGo to next message
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
Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229087 is a reply to message #229085] Thu, 05 April 2007 05:42 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229185 is a reply to message #229176] Thu, 05 April 2007 15:17 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229286 is a reply to message #229185] Fri, 06 April 2007 08:39 Go to previous messageGo to next message
joy_division
Messages: 4640
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
Re: how to shutdown heavy loaded oracle machine (urgunt) [message #229307 is a reply to message #229286] Fri, 06 April 2007 10:17 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No ./fa/1599/0/
Previous Topic: How to offline a Partitioning?
Next Topic: connectivity with SQL Server
Goto Forum:
  


Current Time: Fri Dec 02 22:48:22 CST 2016

Total time taken to generate the page: 0.14164 seconds