FYI.
The USPS delivery just (10 minutes ago) arrived with
my copy of "Mastering Oracle PL/SQL Practical
Solutions", which I ordered from Book Pool, at:
http://www.bookpool.com/.x/mzttmcaj4i/sm/1590592174
As you can see, its not available yet on Amazon:
http://www.amazon.com/exec/obidos/tg/detail/-/1590592174
/qid=1072734291/sr=1-1/ref=sr_1_1/102-9815245-5757732?v=glance&s=books
If you look on pg249, it discusses bulk collect and
pga memory, e.g.
"I crashed my database session (and shortly thereafter
my laptop) because insufficient memory was available
to hold the set of 1000000 employee records". ...
"This is where a pipelined solution can help".
I'm not sure if this will help in this case, but
at least I hope this opens the discussion to
include a 'new' reference on PL/SQL.
Happy Holidays.
Regards,
Mike Thomas
- Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
> Btw, PRIVATE_SGA only limits shared server SGA
> memory usage, for limiting
> PGA sizes you could use _pga_max_size (defaults to
> 200M), but this is
> getting kind of dirty and is unsupported (and works
> starting from 9i)
>
> Tanel.
>
> ----- Original Message -----
> To: <ORACLE-L_at_fatcity.com>
> Sent: Monday, December 29, 2003 10:03 PM
>
>
> > Check profile option PRIVATE_SGA (available from
> 9i and needs
> resource_limit
> > parameter to be true).
> >
> > Tanel.
> >
> > ----- Original Message -----
> > From: <ryan_oracle_at_cox.net>
> > To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> > Sent: Monday, December 29, 2003 7:34 PM
> > Subject: Re: RE: large pl/sql table sucking up all
> memory on a server
> >
> >
> > > we dont have that level of granularity. everyone
> developers out of the
> > same DBA account(not my call).
> > >
> > > any parameter settings to limit the size of
> pl/sql tables?
> > >
> > > >
> > > > From: "Jamadagni, Rajendra"
> <Rajendra.Jamadagni_at_espn.com>
> > > > Date: 2003/12/29 Mon PM 12:14:24 EST
> > > > To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> > > > Subject: RE: large pl/sql table sucking up all
> memory on a server
> > > >
> > > > Assign the developer a "profile" .... that
> would do good.
> > > >
> > > > Raj
> > >
> >
> >
>
> > ------
> > > > Rajendra dot Jamadagni at nospamespn dot com
> > > > All Views expressed in this email are strictly
> personal.
> > > > QOTD: Any clod can have facts, having an
> opinion is an art !
> > > >
> > > >
> > > > -----Original Message-----
> > > > Sent: Monday, December 29, 2003 12:00 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > > One of our guys used a very large bulk collect
> into with a forall
> > update. It sucked up all the swap space on our
> solaris box and noone could
> > connect to it. So we had to bounce the server.
> > > >
> > > > I was under the impression that pl/sql tables
> go into the buffer cache
> > and cannot go large than its size? Oracle
> typically holds your hand with
> > memory usage issues. Are there any parameter
> settings I can use that limit
> > the size of pl/sql tables?
> > > >
> > > > Or are they just dynamic arrays that can grow
> as large as you want.
> > > >
> > > > I know your supposed to use a 'limit' command
> on them. I didnt write
> it.
> > I just dont want it to happen again.
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > > > --
> > > > Author: <ryan_oracle_at_cox.net
> > > > INET: ryan_oracle_at_cox.net
> > > >
> > > > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > > > San Diego, California -- Mailing list
> and web hosting services
> > > >
>
> > > > To REMOVE yourself from this mailing list,
> send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling
> of 'ListGuru') and in
> > > > the message BODY, include a line containing:
> UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be
> removed from). You may
> > > > also send the HELP command for other
> information (like subscribing).
> > > >
> > > >
> >
>
> > **********
> > > > This e-mail message is confidential, intended
> only for the named
> > recipient(s) above and may contain information
> that is privileged,
> attorney
> > work product or exempt from disclosure under
> applicable law. If you have
> > received this message in error, or are not the
> named recipient(s), please
> > immediately notify corporate MIS at (860) 766-2000
> and delete this e-mail
> > message from your computer, Thank you.
> > > >
> >
>
> > **********4
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > > > --
> > > > Author: Jamadagni, Rajendra
> > > > INET: Rajendra.Jamadagni_at_espn.com
> > > >
> > > > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > > > San Diego, California -- Mailing list
> and web hosting services
> > > >
>
> > > > To REMOVE yourself from this mailing list,
> send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling
> of 'ListGuru') and in
> > > > the message BODY, include a line containing:
> UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be
> removed from). You may
> > > > also send the HELP command for other
> information (like subscribing).
> > > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > > --
> > > Author: <ryan_oracle_at_cox.net
> > > INET: ryan_oracle_at_cox.net
> > >
> > > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > > San Diego, California -- Mailing list and
> web hosting services
> > >
>
> > > To REMOVE yourself from this mailing list, send
> an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > > the message BODY, include a line containing:
> UNSUB ORACLE-L
> > > (or the name of mailing list you want to be
> removed from). You may
> > > also send the HELP command for other information
> (like subscribing).
> > >
> >
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Tanel Poder
> INET: tanel.poder.003_at_mail.ee
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
>
=== message truncated ===
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Thomas
INET: mhthomas_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Dec 29 2003 - 15:59:32 CST
