-
error ora-04030 out of process memory when trying to allocate 460 bytes
When I am trying to query "select start_scn,commit_scn from flashback_Transaction_query where table_owner='SH1';" getting this error.
ERROR:
ORA-04030: out of process memory when trying to allocate 460 bytes (Logminer
LCR c,krvxbpdl)
Please help me.
Thanks in advance
Shihab
-
check the 'free memory' in v$sgastat and size the shared pool accordingly
-
Originally Posted by Thomasps
check the 'free memory' in v$sgastat and size the shared pool accordingly
My shared pool free memory is 27238308. How can set the shared pool accordingly...?I am new,plz help me.
-
Could you tell me in detail.I am A new DBA
-
4030 is related to your PGA, check your oracler user's ulimit values
also state what platform is this
thanks
-
-
Hmm my short sight. Menalink doc: 233869.1 explains this problem.
-
er platform as well, i.e what operating system are you using
thanks
-
OS is Windows 2003 Server Service Pack 1.
RAM - 2GB.Intel Xeon
-
Support Pando, it seems to be the PGA. On WIndows it could be physical memory shortage. What do u think people?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|