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,
David - You have touched on two very large subjects: Tuning SQL Statements
and Oracle System Performance Tuning. There are people on this list who have
spent years developing skills in this area, and others like me that have
spent years not learning nearly enough. To get an overview of the subject
David,
The processes init.ora parameter sets the maximum number of Oracle processes
that will run on the server. Beware, if you set that too low then your users
will get an error message about max_processes exceeded when they try to logon.
Now regrettably we were not given the platform or O
gt; on behalf of "Nguyen, David M"
<[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 4:54 PM
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Subject:How to tune SQL and CPU usage
Someone uses SQL to query data, he complains i
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
run