<div>
How can see that I have no accurate table and index stats on oracle 11G?<br />
Thanks<br />
bibi
</div>


How can see that I have no accurate table and index stats on oracle 11G?
Thanks
bibi

<div>
This should get you started:<br />
&nbsp; &nbsp;SELECT table_name, last_analyzed FROM user_tables;<br />
&nbsp; &nbsp;SELECT table_name, index_name, last_analyzed FROM user_indexes;<br />

</div>


This should get you started:
   SELECT table_name, last_analyzed FROM user_tables;
   SELECT table_name, index_name, last_analyzed FROM user_indexes;


<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
Why the plan of execution for the same request launched &nbsp;in parallel but can change?<br />
How to resolve of problem because there is an impact on the performances?<br />
Thanks<br />
bibi
</div>
</div>


Hello

Why the plan of execution for the same request launched  in parallel but can change?
How to resolve of problem because there is an impact on the performances?
Thanks
bibi

Query execution plan change in oracle 11G

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.