Oracle di windows hanya terdiri dari 1 process, maka
SGA + PGA mesti < 3 GB.
Apakah error dari posting yg dulu2 masih terjadi?
regards,
tomi
--- Ervin Listyawan <[EMAIL PROTECTED]> wrote:
> Saya mau reposting topik yang sudah lama, mau tanya
> yang berkaitan.
> 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
> >
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
-----------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
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.
