I have Oracle9i DB R2 running on Sun Solaris 9 with 4 GB RAM. When I execute a query remotely via SQL+ after connecting like dbuser@TNS/<password>. The query finishes in two minutes. But when I execute the same query sitting on the DB console, it finishes in three seconds.
Does this difference in performance have anything to do with SQL net performance? I think the database is OK. We checked our network for viruses and there are none. We have 100 MBPS fiber-optics network.
Could you please explain why this performance bottlenecks? Also, how can I increase the SGA size, as I hope that will give us a faster database response?
QUESTION POSED ON: 23 JAN 2006
QUESTION ANSWERED BY: Paul Baumgartel
There shouldn't be a noticeable difference in performance. Ask your network administrator to check network transfer speeds.
You increase SGA size by specifying larger values for the components that make up the SGA, such as db_cache_size and shared_pool_size.
|
