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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 26, '02 at 9:48a
activeJun 26, '02 at 9:48a
posts1
users1
websiteoracle.com

1 user in discussion

Abdul Jaleel: 1 post

People

Translate

site design / logo © 2022 Grokbase