10 Replies Latest reply: Apr 6, 2013 9:01 AM by onedbguru RSS

    Can DBA force queries to run in parallel without modifying sql's queries

    930862
      Hi,

      We have a latest SUN SPARC server and storage available with Oracle database 11.2.0.3.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.

      Please suggest.

      Rgds,
      Praveen