Our database server has two CPUs with dual core processor which is running on Red Hat Enterprise Linux 4.7 platform. When we ran one Oracle request, it only take one core of CPU with 98% usage. This request has taken one hour and fifteen minutes to complete. My question are:
1. Can Oracle request not take more than one CPU core to run? so the request can complete in a shorter time.
2. If this is possible, how can I configure on OS or Oracle parameter file to enable it to take two cores of CPU?