10 Replies Latest reply on Apr 6, 2013 2:01 PM by onedbguru

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


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