SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check RAM usage by PL/SQL package

518838May 31 2007 — edited Jun 1 2007

Hi,
I'm running a billingrun application on my development env(Windows XP env), & I found that it is eating a lot of RAM, & process exits whenever it reaches out of memory limit(1 GB on my development env).

However the same application is running on production (UNIX platform) from years, but we never faced that type of problem. I'm not sure but may be that server is having lot of memory available.

Here my questions are:
How can we get the memory usage on production by my package?
Does trace file contains that info?
Are there any specific standard reasons of high memory usage by application(probably cursor retrieving more rows? Or anything else )

Thanks
Deepak

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2007

Added on May 31 2007

9 comments

2,128 views