Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select on object types stalls my system
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>...Received on Sun Mar 26 2000 - 00:00:00 CST
>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.
>