RE: Can't update table

From: William Beilstein <BeilstWH_at_OBG.com>
Date: Wed, 29 Nov 2000 16:47:05 -0500
Message-Id: <10695.123254@fatcity.com>

Is the column being used as a foreign key?

>>> "Bond, Mike" <CEMAB_at_cews.okc.disa.mil> 11/29/00 04:05PM >>> yes. =20

I noticed that this table was the only one with 'CACHE' turned on so I turned it off. Now I am able to update a row, but there is such a perfomance problem that to update 1000 rows will take an hour.

There were no locks, no dba_waits or dba_blockers entries.

I bounced the db and nothing has changed.

Selects work fine.

I'm now looking at performance issues specific to this table.=20

thanks,

mike

-----Original Message-----
Sent: Wednesday, November 29, 2000 1:41 PM To: Multiple recipients of list ORACLE-L

Is the UPDATE privilege for "BOB's" table given to the person trying to update the table???

ROR ma?am

>>> jeff_at_mpv.com 11/29/00 02:01PM >>>
Sounds like it might be a locking issue...check to see if anyone else has that table/row locked. (v$locked_object, v$lock, etc.).

Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
Sent: Wednesday, November 29, 2000 10:31 AM To: Multiple recipients of list ORACLE-L

Hi,

I am having a problem updating a table. Using 8.1.6.1 on NT.

I can update other tables owned by user 'BOB'. =20

All tables were created via IMPORT. Table X 'should' be the same as the rest.

But no one can update table X, owned by BOB. =20

No errors are returned and no alert log entries are generated. SQL PLus simply hangs. =20

It doesn't matter if it is 1 record to be updated or 30,000, the same = result
- nothing.

BOB can select from this and other tables just fine.

BOB can update other tables just fine.

Ideas?

Thanks,

Mike
--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20

Author: Bond, Mike
INET: CEMAB_at_cews.okc.disa.mil=20

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20

Author: Jeffery Stevenson
INET: jeff_at_mpv.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20

Author: Ron Rogers
INET: RROGERS_at_galottery.org=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------