OraFAQ Forum: Server Administration » Oracle server very slow

Home » RDBMS Server » Server Administration » Oracle server very slow

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

Oracle server very slow [message #243913]

Mon, 11 June 2007 00:33

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

Report message to a moderator

Re: Oracle server very slow [message #243918 is a reply to message #243913]

Mon, 11 June 2007 01:00

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Unix team got back saying 'oracle' is consuming more CPU

Report message to a moderator

Re: Oracle server very slow [message #243925 is a reply to message #243913]

Mon, 11 June 2007 01:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Messages: 222
Yet you ignore ALL basic posting requests.
You're On You Own (YOYO)!

Report message to a moderator

Re: Oracle server very slow [message #243926 is a reply to message #243913]

Mon, 11 June 2007 01:13

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Oracle server very slow [message #243933 is a reply to message #243913]

Mon, 11 June 2007 01:22

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

Report message to a moderator

Re: Oracle server very slow [message #243948 is a reply to message #243933]

Mon, 11 June 2007 01:47

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Oracle server very slow [message #244106 is a reply to message #243948]

Mon, 11 June 2007 10:50

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

try to run statspack with this document.

Attachment: Oracle Statspack Survival Guide1.doc
(Size: 76.00KB, Downloaded 1324 times)

Report message to a moderator

Re: Oracle server very slow [message #244112 is a reply to message #244106]

Mon, 11 June 2007 11:02

Michel Cadot
Messages: 68686
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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

haha.

Yes.beacause i want to share all that what i have.

Report message to a moderator

Re: Oracle server very slow [message #244205 is a reply to message #243913]

Mon, 11 June 2007 23:57

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 !!

Report message to a moderator

Re: Oracle server very slow [message #244213 is a reply to message #244205]

Tue, 12 June 2007 00:43

Michel Cadot
Messages: 68686
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

Report message to a moderator

Previous Topic:	SGA Sizing Question
Next Topic:	Regarding Oracle Achitecture

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:29:12 CDT 2024