<div>
if performance is slow then it's in 96% of the time ITSS <br />
&gt;&nbsp;It's The Stupid Sql (or It's The Slow Sql)<br />
<br />
Tune the slow sql and the performance will get better<br />
<br />
the fastest way to find the bad queries is by listing v$sql by consumed resources<br />
buffer gets or physical reads per execution
</div>


if performance is slow then it's in 96% of the time ITSS
> It's The Stupid Sql (or It's The Slow Sql)

Tune the slow sql and the performance will get better

the fastest way to find the bad queries is by listing v$sql by consumed resources
buffer gets or physical reads per execution

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Recently i have read an article, if the performance is slow because of full table scan. <br />
Then we need to increase the no. of disks.? so the io will be less.<br />
<br />
how to do this? by doing this how the performance will improve.
</div>
</div>


Hi,

Recently i have read an article, if the performance is slow because of full table scan. 
Then we need to increase the no. of disks.? so the io will be less.

how to do this? by doing this how the performance will improve.

Increase no. of disks, so that io will be less.

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.