Sankar,
1) How many indexes does this table have?
2) How many rows currently exist?
3) Are there ANY triggers on this table?
4) Are there any column constraints other than NOT NULL?
5) Is there a foreign key on from this table to another?
6) How many rows are in the master table, if applicable?
7) Are the data and index tablespaces one and the same?
8) Are the data and index tablespaces on the same disk drive?
9) Are there other applications trying to update/delete from/insert to this
table at the same time?
10) Do any of those applications explicitly lock the table? (lock <table>
in exclusive mode;)
Dick Goulet
____________________Reply Separator____________________
Author: Greg Moore <[EMAIL PROTECTED]>
Date: 5/9/2002 2:58 PM
Sankar,
For starters,
SQL> set autotrace trace explain
Now run your SQL and you'll get an explain plan.
Send another email to the list showing both: the SQL statement, and the
explain plan. These may reveal your problem quickly.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 6:08 AM
>
> Hi,
> We are using Oracle 8.1.5 on solaris 2.7.We have a table with 70 columns.
> My problem is when i try to insert/update data into the table,it is
> taking a very long time[45secs to update 40rows].Is there any methods to
> improve the updation/access speed other than Table partitions.
>
> Thanks & Regards,
> Sankar
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: P.V.Sankar
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
