even if no any sql query is using any hint or parallel clause ??Yes. However, it is not a good idea to force all queries to be parallel unless you can test and prove that this provides a benefit.
I believe above Will not work in Oracle 11g database,this concept was there in 10gI believe that it will work in 11g
Can we set all suggested "ALTER SESSION" options togetherYou really need to test it.
Praveen Saxena wrote:What is the subject of this forum?
We have a latest SUN SPARC server and storage available with Oracle database 18.104.22.168.While running our application on this database we found that only 1 cpu is being utilized out of 16 physical CPU's.
Even in our End of day / month process total time taken is same as it takes on old server. We are not getting any benefits of latest more efficient server.
Can't we force sql queries to run in parallel and make a most of available resources,without changing sql scripts.
We want to do something from DBA side,can not bear sql scripting.