Soal memory quota, di Windows Advance Server sekalipun, kan ada
option /3GB tuh, artinya kan quotanya 3 GB.
Apakah ini berarti PGA + SGA < 3 GB, ataukah masing-2x PGA < 3 GB dan
SGA < 3 GB (jadi PGA + SGA mungkin 6 GB).
Thanks & regards,
Ervin L
--- In [email protected], "java4sg" <[EMAIL PROTECTED]> wrote:
>
> Kalau dilihat dari Oracle error sih ini maksudnya:
>
> Cause: Operating system process private memory has been exhausted.
>
> Action: See the database administrator or operating system
> administrator to increase process memory quota. There may be a bug
in
> the application that causes excessive allocations of process memory
space.
>
>
> Coba lihat apakah memang ada process memory quota?
>
> Cheers.
> BAM
>
>
> --- In [email protected], "Ervin Listyawan" <[EMAIL PROTECTED]>
> wrote:
> > Dear rekan milis,
> >
> > Saya ketemu Error aneh lagi yg menghambat query akibat men-turn-
on
> > parallelism pada tabel spt saran beberapa rekan milis.
> >
> > Setelah paralellism diaktifkan, saya ketemu error sbb:
> >
> > ERROR at line 1:
> > ORA-12801: error signaled in parallel query server P001
> > ORA-04030: out of process memory when trying to allocate 8192
bytes
> > (sort
> > subheap,sort key)
> >
> > ERROR at line 1:
> > ORA-12801: error signaled in parallel query server P003
> > ORA-04030: out of process memory when trying to allocate 254476
bytes
> > (hash-join subh,kllcqas:kllsltba)
> >
> > ERROR at line 1:
> > ORA-12801: error signaled in parallel query server P002
> > ORA-04030: out of process memory when trying to allocate 254476
bytes
> > (hash-join subh,kllcqas:kllsltba)
> >
> > Kira-kira apa penyebab & solusinya?
> >
> >
> > Regards,
> >
> > Ervin L
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
SPONSORED LINKS
| Membership database software | Database mortgage software | Pda database software |
| Database management software | Oracle database administration | Oracle database management |
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
