OraFAQ Forum: Performance Tuning » Db servers capacity

Home » RDBMS Server » Performance Tuning » Db servers capacity (oracle )

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

Db servers capacity [message #624602]

Tue, 23 September 2014 21:04

simplesanju
Messages: 36
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

Report message to a moderator

Re: Db servers capacity [message #624604 is a reply to message #624602]

Tue, 23 September 2014 21:18

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: Db servers capacity [message #624608 is a reply to message #624602]

Wed, 24 September 2014 00:01

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

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.

Report message to a moderator

Re: Db servers capacity [message #624610 is a reply to message #624608]

Wed, 24 September 2014 00:47

simplesanju
Messages: 36
Registered: July 2008

Member

Thanks BlackSwan

Report message to a moderator

Previous Topic:	Is there a way to monitor historical locks in Standard Edition
Next Topic:	How to tune a slow query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 20 10:44:22 CST 2025