Home » RDBMS Server » Performance Tuning » Db servers capacity (oracle )
Db servers capacity [message #624602] Tue, 23 September 2014 21:04 Go to next message
simplesanju
Messages: 34
Registered: July 2008
Member
Hi all,


how can I get the information regarding how many threads can DB server handle per second, minute and hour
or an average what is the capacity to bear threads of database server?

Thanks in advance!!

Sanjana
Re: Db servers capacity [message #624604 is a reply to message #624602] Tue, 23 September 2014 21:18 Go to previous messageGo to next message
BlackSwan
Messages: 25793
Registered: January 2009
Location: SoCal
Senior Member
It depends upon number & speed of CPUs within the server, the amount of RAM, the disk subsystem along with complexity of SQL being processed.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/
Re: Db servers capacity [message #624608 is a reply to message #624602] Wed, 24 September 2014 00:01 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
how can I get the information regarding how many threads can DB server handle per second, minute and hour or an average what is the capacity to bear threads of database server?


Nowhere, this is the reason of benchmarks.

Re: Db servers capacity [message #624610 is a reply to message #624608] Wed, 24 September 2014 00:47 Go to previous message
simplesanju
Messages: 34
Registered: July 2008
Member
Thanks BlackSwan
Previous Topic: Is there a way to monitor historical locks in Standard Edition
Next Topic: How to tune a slow query
Goto Forum:
  


Current Time: Tue Jan 16 14:18:21 CST 2018

Total time taken to generate the page: 0.01558 seconds