Developer

Swaminathan K

<div>
<div class="content wysiwyg-content">
Hi Team,<br />
<br />
I need to write a query to fetch the memory used by a query while it is executing on oracle server . IS there any data dictionary views which can provide this information. I need to know PGA as well as SGA.<br />
<br />
Any help is really appreciated .
</div>
</div>


Hi Team,

I need to write a query to fetch the memory used by a query while it is executing on oracle server . IS there any data dictionary views which can provide this information. I need to know PGA as well as SGA.

Any help is really appreciated .

Data Dictionary view for memoery utilizedby sql queries

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.