real world oracle concurrency limit
Date: Sat, 14 Nov 2015 01:35:16 +0800
Message-Id: <490ED9A4-487E-4796-82CD-DFE236268E56_at_gmail.com>
hi all
i have been away from the oracle world for a few years, and recent growing traffic caused our only oracle system running into its limit, so pulled me back to oracle world��
i got two questions
1�� whatis the realworld oracle concurrency limit? our 2way x86 server oracle has reached 77k qps during peak time and ~225k user calls, running the system at 70pct cpu(on flash card so no io wait)�� i am afraid of even if we upgrade to 4way/48core(now 2way/16core) server, internal concurrency limit(like library cache mutex etc) will block system from 2x traffic�� 5 years ago when i left oracle world the most busy production system i knew was around 40k qps on a sun t~3 server�� wondering where there is many production system running at 100k~200k qps(a few thousand tps) in real world,if yes whatkind of hw configirations?
2��i was curious about our system(11203 nom rac) with 225k user calls and 77k executions�� i know user call is usually higher than exec but this kind of gap does not make sense to me��
we dont use plsql, no big sql fetching tons of rows(sql lio per exec was just 9). a few hard parse(~60-100 per second) will cause more recursive call but this does not explain.
anyone has idea?
or i should skip user calls and just read the executions?
thanks a lot
best regards
Mail: zhuchao_at_gmail.com
�����ҵ�iPhone6
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 13 2015 - 18:35:16 CET