Feeds:
Posts
Comments

Posts Tagged ‘T2000’

Client could be the bottleneck.


In the previous post I said if sql*net is the bottleneck,  then the cpu usage of oracle server is low.

https://mysqloracle9.wordpress.com/2009/12/23/how-much-cpu-will-full-table-scan-use/

The test I did was on solaris T2000 (Both server and client are T2000 but on different machine).  What I observed is the sql*net has a low throughput, but the root cause is that the client side app (sqlplus) used up 100% cpu.  If run sqlplus on PC server, the throughput of sql*net will be much higher and the cpu usage of oracle server also increase to about 60%. The lesson learned here is:  client side could also be the bottleneck. It’s too easy to tune the oracle server and network but forget client side completely.

And for batch job which can’t run in parallel, T2000 is a bad choice, PC server is much better.

Read Full Post »