<div>
Thank very much for your pace of response.<br />
Can you please elaborate your description , that help me for more understanding.<br />

</div>


<div>
run the above query and post the results. &nbsp;I'll help you understand the output and make recommendations for your system based on it.
</div>


<div>
Thanks for reply. <br />
<br />
Your reply has shown the way to dig more on this issue. Revert back you soon if I face difficulty while interpreting stats of oracle tuning advisory views and will close this log accordingly following with assigning the points for this thread. <br />

</div>


<div>
<div class="content wysiwyg-content">
What should be the ideal PGA size comparatively with SGA size. What are the factors that count while deciding this parameter
</div>
</div>


What should be the ideal PGA size comparatively with SGA size. What are the factors that count while deciding this parameter

How to decide the optimal oracle PGA size

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.