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

Quote:

---

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

this is oracle 10g

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?

Metalink Note:233869.1 -- Diagnosing and Resolving ORA-4030 errors