I don't think ORA 04030 is a good example ...
It means that the oracle process has tried to allocate memory as asked by the
DBA, and couldn't, because either the server has no more memory, the process
has hit an administrative (OS) limit, the OS has done an optimistic memory
allocation...
As far as I know, it occurs when (for instance) a DBA puts a gigantic sort
area size, coupled with a very high number of process limit, or some other
(voluntarily) high limits.
What I mean is that it's not something that happens with 'out of the box'
configurations... It's something the DBA has 'voluntarily' done when tuning
the database.
Of course, you can trigger something like that with postgresql, providing you
put a high default work_mem, coupled with a high max_connections, and of
course, lots of session simultaneously doing big sorts ... but these aren't
out of the box parameters.
On Friday 23 March 2007 17:38, Eric Bollengier wrote:
> This cause a database/system crash ? or a just a transaction rollback ?
> ...
>
> Le Vendredi 23 Mars 2007 17:03, Oliver Lehmann a écrit :
> > Eric Bollengier wrote:
> > > It's the database job... I never seen a database (mysql, postgres or
> > > oracle) saying something like "Sorry i'm out of memory". Database takes
> > > memory that you give, never more.
> >
> > Talking about Oracle - I can tell you those erros can happen (generally,
> > not speaking about bacula). I saw them some times in my short life ;)
> > Error codes are:
> >
> > ORA-04030
> > Error out of process memory when trying to allocate string bytes
> > (string,string)
> > Cause Operating system process private memory has
> > been exhausted
> >
> > ORA-04031
> > Error unable to allocate string bytes of shared memory
> > ("string","string","string","string")
> > Cause More shared memory is needed than was allocated in the
> > shared pool.
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
