OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » databse resources (10.2.0.3;windows server x64)

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

databse resources [message #638353]

Wed, 10 June 2015 00:37

surmaa013
Messages: 20
Registered: April 2015
Location: delhi

Junior Member

Hi all ,

I want to what should be the standard maintain for the oracle DB server ? I mean how much disk space should be free on the drives which contain the datafiles .and how it can effect our performance ?

Report message to a moderator

Re: databse resources [message #638356 is a reply to message #638353]

Wed, 10 June 2015 00:56

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

Senior Member
Account Moderator

Quote:

I mean how much disk space should be free on the drives which contain the datafile

How much will your datafiles grow?

Quote:

how it can effect our performance ?

Not used space impacts the performances in no way.

Report message to a moderator

Re: databse resources [message #638357 is a reply to message #638356]

Wed, 10 June 2015 01:05

surmaa013
Messages: 20
Registered: April 2015
Location: delhi

Junior Member

In my DB there is only 15% disk space is free . and now the performance of db server become worse ...my cpu is being used 100% .please suggest a solution .

Report message to a moderator

Re: databse resources [message #638358 is a reply to message #638357]

Wed, 10 June 2015 01:12

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

Senior Member
Account Moderator

Why do you blame amount of free disk space for high CPU usage?

Report message to a moderator

Re: databse resources [message #638361 is a reply to message #638358]

Wed, 10 June 2015 01:27

surmaa013
Messages: 20
Registered: April 2015
Location: delhi

Junior Member

Its a heavy database approx 900gb . and lots of user connect to it . So its CPU is being used 100% .

Report message to a moderator

Re: databse resources [message #638362 is a reply to message #638361]

Wed, 10 June 2015 01:35

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

Senior Member
Account Moderator

This does not answer Littlefoot's question.
Who is using the CPU?

Report message to a moderator

Re: databse resources [message #638365 is a reply to message #638362]

Wed, 10 June 2015 02:00

surmaa013
Messages: 20
Registered: April 2015
Location: delhi

Junior Member

Oracle is using 100% cpu .

Report message to a moderator

Re: databse resources [message #638366 is a reply to message #638365]

Wed, 10 June 2015 02:06

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

Senior Member
Account Moderator

Given your question and answers I think you have not the skills to solve your problem and you should hire an expert to do it.

Report message to a moderator

Re: databse resources [message #638373 is a reply to message #638365]

Wed, 10 June 2015 06:21

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

surmaa013 wrote on Wed, 10 June 2015 02:00

Oracle is using 100% cpu .

And why do you believe that the amount of free/used disk space has anything whatsoever to do with that?

Report message to a moderator

Re: databse resources [message #638374 is a reply to message #638357]

Wed, 10 June 2015 06:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

surmaa013 wrote on Tue, 09 June 2015 23:05

In my DB there is only 15% disk space is free . and now the performance of db server become worse ...my cpu is being used 100% .please suggest a solution .

what are the top 5 CPU consuming SQL statement?

Report message to a moderator

Previous Topic:	LGWR doing non-clean dismount of group
Next Topic:	Unable to extend temp segment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:52:53 CST 2025