| 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
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,
go to the Frequently Asked Question site for this list which appears at the
bottom of every message: http://www.orafaq.com. I searched this site for
"tuning" and received several papers that cover the most common questions.
Once you have exhausted this resource, you could go to http://www.google.com
and search for things like "Oracle SQL Tuning" or "Oracle System Tuning".
These free on-line resources should get you started and get you past some
common problems. If you decide to learn more, there are some really
excellent books that will help you learn. Oracle teaches a class on just
this topic. Once you have taken the time to understand some of the basics
and have some specific questions, write back with some more specific
questions. If your site needs help more quickly, ask your boss about
bringing a consultant in for a day. An experienced consultant can do a lot
in a day to put your site on the right path.
And the most common thing is for a developer to blame the database.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Friday, April 05, 2002 2:55 PM
To: Multiple recipients of list ORACLE-L
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).
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 - 16:48:19 CST
 |
 |