| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to tune SQL and CPU usage
There are two types of background processes Oracle runs. One to manage
the database and the other to process user requests or SQL. Which one
are using up CPU is difficult to say without looking at the PS report.
Even though it may seem Oracle processes are using lots of CPU, it may be misleading, because if Oracle is up and running for sometime PS results will show high numbers for Oracle background processes.
However the background process to service your SQL should not show high number. It is possible that the SQL user is processing is not optimized or there is an index missing on the table and Oracle is performing full scan of a table.
You can tune the SQL. But you have to spend time learning Oracle. Look at Oracle concept manual for understanding SQL. Look for High Performance SQL tuning book to help you understand what is involved for SQL tuning.
Shakir
--- "Nguyen, David M" <david.m.nguyen_at_xo.com> wrote:
> Someone uses SQL to query data, he complains it takes too long to get
> results back from oracle database. He also notices there are many
> oracle
> processes running on system that uses much CPU and causing system
> slow down.
>
> Is there a way to tune SQL to improve query and to set maximum number
> of
> running oracle processes?
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
> INET: david.m.nguyen_at_xo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: mshakir08816_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Apr 05 2002 - 19:43:59 CST
 |
 |