Re: Oracle shared memory error

Chinna wrote:
>
> Can you give more details (the error number), maybe i can show some light
> on it.
>
> Chinna
>
> ErnieCee <acgator_at_erols.com> wrote in article <3427FE3C.6A35_at_erols.com>...
> > I am running a Perl script using DBI and DBD::Oracle. The script runs a
> > sequential batch process, to read large amounts of records and insert
> > them into a temporarily created table. The script does some processing
> > on the inserted data in the temp table and then copies the data in the
> > temp table to the permanent Oracle table.
> >
> > The scripts seems to work fine for small test data files, but with huge
> > data files it crashes and gives me an error stating that the database is
> > unable to allocated enough shared memory to execute the SQL statement.
> >
> > My question is has anyone experienced this problem, and is it an Oracle
> > configuration problem, or a problem with my script. Any information
> > would be most helpful.
> >
> > Replies can be posted here or sent direct to aron_ceely_at_notes.pw.com.
> >
> > Thanks
> >

The oracle error was ora 4031.

Unable to allocate shared memory. Received on Fri Sep 26 1997 - 00:00:00 CDT