Re[2]: Improving Oracle Performance

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 <sqlgreg_at_pacbell.net>
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" <ORACLE-L_at_fatcity.com> 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: sankar_at_cdotb.ernet.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  INET: sqlgreg_at_pacbell.net

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

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