Maryann - No problem, welcome to the list. We only ask that you make a slight effort to search for the answer first, but these are good questions that you won't quickly find as a beginner.
a. Oracle provides an explain plan feature to show you how your SQL will be handled. You must create a table in your schema called plan_table. Here is a tutorial (you'll have to patch the link back together): http://www.evolt.org/article/Use_Oracle_s_Explain_Plan_to_Tune_Your_Queries/ 17/2986/ b. You can do as much damage by tuning the SGA as anything, so learn how to do it right from the start. Buy: Oracle Performance Tuning 101 http://www.amazon.com/exec/obidos/tg/detail/-/0072131454/qid=1054149138/sr=8 -1/ref=sr_8_1/103-6975634-9907034?v=glance&s=books&n=507846 Another good book I've recently found is The Art and Science of Oracle Performance Tuning: http://www.amazon.com/exec/obidos/ASIN/1904347010/qid%3D1054149206/sr%3D11-1 /ref%3Dsr%5F11%5F1/103-6975634-9907034 Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, May 28, 2003 2:15 PM To: Multiple recipients of list ORACLE-L I am so novice it'll probably take me years to learn oracle like some of you know it in here... I am just studying a book, and try to learn from some of its questions. a. Which util do I use to see oracle's execution plan for a SQL statement? Which statement would you recommend me, so I can actually try it and see results? b. If I need to tune the SGA ONLY, should I concentrate on the log buffers, the library cache or the shared pool? thx maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
