Re: out of memory - executing a select statement

From: Anurag Varma <avoracle_at_gmail.com>
Date: 10 Jan 2007 13:02:34 -0800
Message-ID: <1168462953.914520.11480@k58g2000hse.googlegroups.com>

What's in a namespace wrote:
> "Anurag Varma" <avoracle_at_gmail.com> schreef in bericht
> news:1168445146.894466.108780_at_p59g2000hsd.googlegroups.com...
> >
> > savindya wrote:
> > -snip-
> >> 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
> >
> > This question has nothing to do with oracle. Please post this question
> > in
> > a pl/sql developer forum.
> > Either its an issue with your machine .. or a bug in pl/sql developer.
> > .. or you can probably try getting the latest version of pl/sql
> > developer.
> > Maybe its a bug thats fixed in latest release (maybe..)
> >
> >
> > Anurag
> >

> Could be a mismatch between SQL NET client version (10? 8?) and server
> version (9?). Toad had a problem like this too (client version 9, server
> version 10)

Well still OP should look for answers in a pl/sql developer forum. http://www.allroundautomations.nl/plsqldev.html

They have a forum there...

Anurag Received on Wed Jan 10 2007 - 15:02:34 CST