Re: out of memory - executing a select statement

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 10 Jan 2007 05:14:28 -0800
Message-ID: <1168434868.565916.188540@o58g2000hsb.googlegroups.com>

savindya wrote:
> sybrandb wrote:
> > savindya wrote:
> > > Hi all,
> > >
> > > I m using oracle 9i as the db. And a certain table has 1330391 records
> > > in it.
> > > I use PLSQL developer to query on the db.
> > >
> > > When I execute a simple SELECT * FROM tablename , the system fetches
> > > about 208,595 records and halts with the out of memory error.It is
> > > impossible to use any stored procedures on this table also.Please
> > > advice on what options are available.
> > >
> > > regards,
> > > Savindya
> >
> > *Which* out of memory error?
> > Please do NOT assume we are looking over your shoulder and can guess
> > what 'the out of memory error' and 'impossible to use stored
> > procedures' means.
> > The options which are available are
> > - be more specific
> > - be more specific
> > and
> > - be more specific
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA

>

> Hi,

>

> Sorry if I offended you. But I have listed all the known facts.

>

> The out of memory occurs in the PL SQL developer GUI when a select *
> from XXXX is performed.
> The PLSQL developer first lists down the first 30 rows.When I click on
> fetch all rows, it crashes mid way.
> The problem must be with the client program (PL SQL developer) and not
> the database server.
> Are there any memory managment methods to use ?
> Should the database table entries be archived ?

>

> The machine on which the PLSQL runs has 1 GB RAM.
> please advice

>
> Savindya

Mhmmmm a bit wondering what you'd do with 1.3M records on the screen? Scroll through them to find the one you exactly need? Or probably count them to assure that table definitely has 1330391 rows?

Gints Plivna
http://www.gplivna.eu Received on Wed Jan 10 2007 - 07:14:28 CST