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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). ===== Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
