Home » RDBMS Server » Server Administration » databse resources (10.2.0.3;windows server x64)
databse resources [message #638353] Wed, 10 June 2015 00:37 Go to next message
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 ?
Re: databse resources [message #638356 is a reply to message #638353] Wed, 10 June 2015 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 65850
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: databse resources [message #638357 is a reply to message #638356] Wed, 10 June 2015 01:05 Go to previous messageGo to next message
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 .
Re: databse resources [message #638358 is a reply to message #638357] Wed, 10 June 2015 01:12 Go to previous messageGo to next message
Littlefoot
Messages: 21440
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why do you blame amount of free disk space for high CPU usage?
Re: databse resources [message #638361 is a reply to message #638358] Wed, 10 June 2015 01:27 Go to previous messageGo to next message
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% .
Re: databse resources [message #638362 is a reply to message #638361] Wed, 10 June 2015 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 65850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: databse resources [message #638365 is a reply to message #638362] Wed, 10 June 2015 02:00 Go to previous messageGo to next message
surmaa013
Messages: 20
Registered: April 2015
Location: delhi
Junior Member
Oracle is using 100% cpu .
Re: databse resources [message #638366 is a reply to message #638365] Wed, 10 June 2015 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 65850
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: databse resources [message #638373 is a reply to message #638365] Wed, 10 June 2015 06:21 Go to previous messageGo to next message
EdStevens
Messages: 985
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?
Re: databse resources [message #638374 is a reply to message #638357] Wed, 10 June 2015 06:33 Go to previous message
BlackSwan
Messages: 26208
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?
Previous Topic: LGWR doing non-clean dismount of group
Next Topic: Unable to extend temp segment
Goto Forum:
  


Current Time: Tue Oct 23 11:49:27 CDT 2018