Oracle-L: Performance with Oracle Object Types

From: Abdul Jaleel <spammitplease_at_yahoo.co.in>
Date: Wed, 26 Jun 2002 01:48:26 -0800
Message-ID: <F001.00488198.20020626014826@fatcity.com>

Hi all
We have a problem with Oracle 8i database slowing down while deleting nested tables. Details are... Configuration :

Oracle 8i Enterprise edition , release 8.1.6.0.0 on Compaq AlphaServer ES40
alpha(500MHz)with 1024 MB main memory.

Table details

create type rest as OBJECT(time varchar2(5), use varchar2(3),A double precision,

B double precision,C double precision,
D double precision,E double precision,
F double precision,G double precision,
H double precision,I double precision,
J double precision,K double precision,
L double precision,M double precision,
N double precision,O double precision,
P double precision,Q double precision,
R double precision,S double precision,
T double precision,U varchar2(1),V varchar2(1),

W varchar2(1),use1 varchar2(5))
/

create type inrest_tab AS TABLE OF rest
/

create table maintab(Field1 varchar2(2) not null, Field2 varchar2(6) not null,Field3 varchar2(3) not null,
Field4 varchar2(4) not null,Field5 varchar2(1), inrest inrest_tab, ////comment Each row in maintab contains 60 records in nested table
constraint myKey primary key
(Field1,Field2,Field3,Field4))
NESTED TABLE inrest STORE AS store_tab
/

When i say
sql>delete from maintab where field1='AB'

it takes around one hour to delete 45 rows
system slows down very much,
sqlplus wont connect to database (simply stucks) ,
other program which is populating a different table(which is in other tablespace) stucks in betweeen

any suggestions or pointers on this ... Thanks in advance
Abdul

Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!!

visit http://in.autos.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Abdul=20Jaleel?=
  INET: spammitplease_at_yahoo.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jun 26 2002 - 04:48:26 CDT