Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select on object types stalls my system

Re: Select on object types stalls my system

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/03/26
Message-ID: <954067908.9124.0.nnrp-03.9e984b29@news.demon.co.uk>#1/1

At two rows, perhaps you could post the
script to create the object and the table and let other see if they get the same
result.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Christopher Maher wrote in message <38DD6C72.CC0871B6_at_Hotmail.com>...

>I am running Oracle 8i on an NT box with 128 MB of RAM.
>
>When I run a select on a table containing an abstract object type and
>ask for all columns to be listed, SQL responds correctly. However, this
>simple select statement almost cripples my system, even though the table
>contains only two rows. The system remains extremely slow for the rest
>of my session until I exit SQL*Plus Worksheet and restart it.
>Frequently, SQL*Plus Worksheet crashes shortly after running this simple
>select statement:
>
>select * from TABLENAME;
>
>I have heard that object types demand memory. Is 128 MB of RAM really
>insufficient? NT Task Manager tells me that my entire 300 MB
>pagefile.sys gets used up when this system slow-down occurs.
>
Received on Sun Mar 26 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US