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

Oracle 8i Enterprise edition, release 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
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
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
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

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).

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
postedJun 26, '02 at 9:48a
activeJun 26, '02 at 9:48a

1 user in discussion

Abdul Jaleel: 1 post



site design / logo © 2022 Grokbase