Topic: Performance & Tuning >> ora-04030 out of process memory
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ora-04030 out of process memory |
| mr_mehraboon |
Posted: Mar 13, 2007 02:36:17 AM |
Total Post: 7
Joined: Feb, 2007
|
Hi,
we are having problem with this big report it seems that the report is using huge amout of memory we have doubles the amount of pga_aggregate_target to 239mb still getting this error. is there anyway to calculate the value for pga_aggregate_target for this particular session or sql statment?
or figure out how much of it this session is currently using ?
|
|
|
 naren |
| Posted: Mar 17, 2007 05:10:07 PM |  |
|
Total Post: 6
Joined: Mar, 2007
|
hello...
This error indicates that the oracle server process is unable to allocate more memory from the operating system.
This memory consists of the PGA (Program Global Area) and its contents depend upon the server configuration.
For dedicated server processes it contains the stack and the UGA (User Global Area) which holds user session data, cursor information and the sort area.
In a multithreaded configuration (shared server), the UGA is allocated in the SGA (System Global Area) and will not be responsible for ORA-4030 errors.
The ORA-4030 thus indicates the process needs more memory (stack UGA or PGA) to perform its job.
Need to check following
Is there still sufficient memory available?
Is_there_an_operating_system_limit_set?
Is there an oracle limit set?
Which process is requesting too much memory?
For more details use Note:233869.1 on Metalink.
regards
-naren
|
|
|
|
|
| mr_mehraboon |
| Posted: Mar 17, 2007 06:02:36 PM | |
|
Total Post: 7
Joined: Feb, 2007
|
we ran the report one more time and monitored the sga usage through TOAD the report is requiring more than 1GB of SGA_AGGRe... , we decided to break the report down.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 816 |
| Mohammed Taj | 709 |
| Jayanta Sur | 479 |
| positive fanatic | 418 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 240 |
| Ramesh Jois | 226 |
| Bishal Khetan | 205 |
|
|
