<div>
SQL*Plus is simply a client-server connection tool, one of several interfaces to the database you wish to examine. &nbsp;And to echo Sean from above, the big picture is important to keep in mind. &nbsp;With the more recent versions (10g, 11g) the emphasis has moved from statistical ratios to wait events: &nbsp;finding what takes the longest to complete, and try to improve it.<br />
<br />
There are many tutorials and guides on tuning here in EE; on the Oracle site; and so forth.<br />
<br />
My parting thought is to make use of the built-in tuning provided by the Optimizer, by keeping your tables and indexes analyzed as appropriate. HTH
</div>


SQL*Plus is simply a client-server connection tool, one of several interfaces to the database you wish to examine.  And to echo Sean from above, the big picture is important to keep in mind.  With the more recent versions (10g, 11g) the emphasis has moved from statistical ratios to wait events:  finding what takes the longest to complete, and try to improve it.

There are many tutorials and guides on tuning here in EE; on the Oracle site; and so forth.

My parting thought is to make use of the built-in tuning provided by the Optimizer, by keeping your tables and indexes analyzed as appropriate. HTH

<div>
The first question you should ask is<br />
<br />
&quot;Does my database needs tuning or not&quot; If Yes Then<br />
&quot;Is the SQL and PL/SQL optimized&quot; is Yes Then<br />
<br />
&quot;Is there enough memory allocated to various pools&quot; if Yes Then<br />
<br />
and so forth....
</div>


The first question you should ask is

"Does my database needs tuning or not" If Yes Then
"Is the SQL and PL/SQL optimized" is Yes Then

"Is there enough memory allocated to various pools" if Yes Then

and so forth....

<div>
BTW. &nbsp;the answer by sdstuber above is perfect!! I am just repeating what he/she already said!!
</div>


BTW.  the answer by sdstuber above is perfect!! I am just repeating what he/she already said!!

<div>
<div class="content wysiwyg-content">
How I can do Oracle Database Tunning by SQL Plus ?
</div>
</div>


How I can do Oracle Database Tunning by SQL Plus ?

Oracle Database Tunning

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.