Home » RDBMS Server » Server Administration » Oracle server very slow
Oracle server very slow [message #243913] Mon, 11 June 2007 00:33 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Suddenly i got an emergency issue-Oracle server very slow .
Anyone has any troubleshooting steps to find what is the cause ?
Regards
Re: Oracle server very slow [message #243918 is a reply to message #243913] Mon, 11 June 2007 01:00 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Unix team got back saying 'oracle' is consuming more CPU
Re: Oracle server very slow [message #243925 is a reply to message #243913] Mon, 11 June 2007 01:12 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Messages: 222
Yet you ignore ALL basic posting requests.
You're On You Own (YOYO)!
Re: Oracle server very slow [message #243926 is a reply to message #243913] Mon, 11 June 2007 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
More than 200 posts and you don't know you have to post your Oracle version.
What does you Statspack report say?

Regards
Michel
Re: Oracle server very slow [message #243933 is a reply to message #243913] Mon, 11 June 2007 01:22 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Oracle9i Enterprise Edition Release 9.2.0.6

i donot know how to use statspack.i am digging some articles now how to use it.

btw,following are the top 10 CPU usage in database.

USERNAME SID CPU_USAGE
------------------------------ ---------- ----------
SAPR 19 43178
SAPR 21 34991
SAPR 11 33129
SAPR 35 32822
SAPR 14 31303
SAPR 39 31089
SAPR 15 30877
SAPR 22 29945
SAPR 29 29907
SAPR 16 24708
SAPR 10 21415
Re: Oracle server very slow [message #243948 is a reply to message #243933] Mon, 11 June 2007 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i donot know how to use statspack.i am digging some articles now how to use it.

Search for "statspack" here, many links to documents have been given.

Please read and follow How to format your posts.

Regards
Michel
Re: Oracle server very slow [message #244106 is a reply to message #243948] Mon, 11 June 2007 10:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
try to run statspack with this document.

Re: Oracle server very slow [message #244112 is a reply to message #244106] Mon, 11 June 2007 11:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I wonder how many times you will have to post this document. Laughing
Someone want to create a poll on this subject? Smile

Regards
Michel

[Updated on: Mon, 11 June 2007 11:06]

Report message to a moderator

Re: Oracle server very slow [message #244114 is a reply to message #244112] Mon, 11 June 2007 11:12 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
haha.

Yes.beacause i want to share all that what i have.
Re: Oracle server very slow [message #244205 is a reply to message #243913] Mon, 11 June 2007 23:57 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
even its a website link or document ,everything is helpful to others.Thanks guys !!
Re: Oracle server very slow [message #244213 is a reply to message #244205] Tue, 12 June 2007 00:43 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Obviously you don't know the use of Search button because DreamzZ already posted his document half of dozen times.

Regards
Michel
Previous Topic: SGA Sizing Question
Next Topic: Regarding Oracle Achitecture
Goto Forum:
  


Current Time: Sat Dec 03 07:42:27 CST 2016

Total time taken to generate the page: 0.08555 seconds