Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can't update table

RE: Can't update table

From: <Hannah.M.Doran_at_sb.com>
Date: Fri, 1 Dec 2000 13:22:58 -0500
Message-Id: <10697.123424@fatcity.com> 





--0__=O2auGpe5oEJ1eJ3x6epFp1rloFffWWOWmvl8mYszjzBmzzFyu7v1xBj2

Content-type: text/plain; charset=us-ascii
Content-Disposition: inline





Hi,



     Think I wrote this before, but check out your temp tablespace too.  I had a
similar problem (but doing mass updates), and it turned out, it was using some
temp space.








Chuck Hamilton <chuck_hamilton_at_yahoo.com> on 12/01/2000 11:18:38 AM



Please respond to ORACLE-L_at_fatcity.com



To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:


Subject:  RE: Can't update table







I can think of two things off the top of my head. If there are a lot of people
trying to update the table simultaneously you could be getting freelist
contention. The solution would be to create addtitional freelists. Another
thought is that if you've only got one rollback segment online you could be
getting contention for the transaction table in the rollback segment. Solution
here is to bring more rollback segments online.




  "Bond, Mike" <CEMAB_at_cews.okc.disa.mil> wrote:




yes.



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.



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



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.



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



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


--



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


--



Author: Bond, Mike


INET: CEMAB_at_cews.okc.disa.mil



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: Jeffery Stevenson


INET: jeff_at_mpv.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).



--



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


--



Author: Ron Rogers


INET: RROGERS_at_galottery.org



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: Bond, Mike


INET: CEMAB_at_cews.okc.disa.mil



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






Do You Yahoo!?


Yahoo! Shopping - Thousands of Stores. Millions of Products.



--0__=O2auGpe5oEJ1eJ3x6epFp1rloFffWWOWmvl8mYszjzBmzzFyu7v1xBj2

Content-type: text/html; 


        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML





PFA+SSBjYW4gdGhpbmsgb2YgdHdvIHRoaW5ncyBvZmYgdGhlIHRvcCBvZiBteSBoZWFkLiBJZiB0
aGVyZSBhcmUgYSBsb3Qgb2YgcGVvcGxlIHRyeWluZyB0byB1cGRhdGUgdGhlIHRhYmxlIHNpbXVs
dGFuZW91c2x5IHlvdSBjb3VsZCBiZSBnZXR0aW5nIGZyZWVsaXN0IGNvbnRlbnRpb24uIFRoZSBz
b2x1dGlvbiB3b3VsZCBiZSB0byBjcmVhdGUgYWRkdGl0aW9uYWwgZnJlZWxpc3RzLiBBbm90aGVy
IHRob3VnaHQgaXMgdGhhdCBpZiB5b3UndmUgb25seSBnb3Qgb25lIHJvbGxiYWNrIHNlZ21lbnQg
b25saW5lIHlvdSBjb3VsZCBiZSBnZXR0aW5nIGNvbnRlbnRpb24gZm9yIHRoZSB0cmFuc2FjdGlv
biB0YWJsZSBpbiB0aGUgcm9sbGJhY2sgc2VnbWVudC4gU29sdXRpb24gaGVyZSBpcyB0byBicmlu
ZyBtb3JlIHJvbGxiYWNrIHNlZ21lbnRzIG9ubGluZS48L1A+PEJSPg0KPFA+Jm5ic3A7IDxCPjxJ
PiJCb25kLCBNaWtlIiAmbHQ7Q0VNQUJAY2V3cy5va2MuZGlzYS5taWwmZ3Q7PC9JPjwvQj4gd3Jv
dGU6IDxCUj48L1A+PEJSPg0KPEJMT0NLUVVPVEUgc3R5bGU9IkJPUkRFUi1MRUZUOiAjMTAxMGZm
IDJweCBzb2xpZDsgTUFSR0lOLUxFRlQ6IDVweDsgUEFERElORy1MRUZUOiA1cHgiPnllcy4gPEJS
PjxCUj5JIG5vdGljZWQgdGhhdCB0aGlzIHRhYmxlIHdhcyB0aGUgb25seSBvbmUgd2l0aCAnQ0FD
SEUnIHR1cm5lZCBvbiBzbyBJPEJSPnR1cm5lZCBpdCBvZmYuIE5vdyBJIGFtIGFibGUgdG8gdXBk
YXRlIGEgcm93LCBidXQgdGhlcmUgaXMgc3VjaCBhPEJSPnBlcmZvbWFuY2UgcHJvYmxlbSB0aGF0
IHRvIHVwZGF0ZSAxMDAwIHJvd3Mgd2lsbCB0YWtlIGFuIGhvdXIuPEJSPjxCUj5UaGVyZSB3ZXJl
IG5vIGxvY2tzLCBubyBkYmFfd2FpdHMgb3IgZGJhX2Jsb2NrZXJzIGVudHJpZXMuPEJSPjxCUj5J
IGJvdW5jZWQgdGhlIGRiIGFuZCBub3RoaW5nIGhhcyBjaGFuZ2VkLjxCUj48QlI+U2VsZWN0cyB3
b3JrIGZpbmUuPEJSPjxCUj5JJ20gbm93IGxvb2tpbmcgYXQgcGVyZm9ybWFuY2UgaXNzdWVzIHNw
ZWNpZmljIHRvIHRoaXMgdGFibGUuIDxCUj48QlI+dGhhbmtzLDxCUj48QlI+bWlrZTxCUj48QlI+
PEJSPjxCUj4tLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLTxCUj5TZW50OiBXZWRuZXNkYXksIE5v
dmVtYmVyIDI5LCAyMDAwIDE6NDEgUE08QlI+VG86IE11bHRpcGxlIHJlY2lwaWVudHMgb2YgbGlz
dCBPUkFDTEUtTDxCUj48QlI+PEJSPklzIHRoZSBVUERBVEUgcHJpdmlsZWdlIGZvciAiQk9CJ3Mi
IHRhYmxlIGdpdmVuIHRvIHRoZSBwZXJzb24gdHJ5aW5nIHRvPEJSPnVwZGF0ZSB0aGUgdGFibGU/
Pz88QlI+PEJSPlJPUiBtYT9hbTxCUj48QlI+Jmd0OyZndDsmZ3Q7IGplZmZAbXB2LmNvbSAxMS8y
OS8wMCAwMjowMVBNICZndDsmZ3Q7Jmd0OzxCUj5Tb3VuZHMgbGlrZSBpdCBtaWdodCBiZSBhIGxv
Y2tpbmcgaXNzdWUuLi5jaGVjayB0byBzZWUgaWYgYW55b25lIGVsc2UgaGFzPEJSPnRoYXQgdGFi
bGUvcm93IGxvY2tlZC4gKHYkbG9ja2VkX29iamVjdCwgdiRsb2NrLCENCiENCiBldGMuKS48QlI+
PEJSPkplZmZlcnkgU3RldmVuc29uPEJSPkNoaWVmIERhdGFiYXNlIEdlZWs8QlI+TWVkaWNhbCBQ
cmVzZW50IFZhbHVlLCBJbmMuPEJSPkF1c3RpbiwgVFg8QlI+PEJSPi0tLS0tT3JpZ2luYWwgTWVz
c2FnZS0tLS0tPEJSPlNlbnQ6IFdlZG5lc2RheSwgTm92ZW1iZXIgMjksIDIwMDAgMTA6MzEgQU08
QlI+VG86IE11bHRpcGxlIHJlY2lwaWVudHMgb2YgbGlzdCBPUkFDTEUtTDxCUj48QlI+PEJSPkhp
LDxCUj48QlI+SSBhbSBoYXZpbmcgYSBwcm9ibGVtIHVwZGF0aW5nIGEgdGFibGUuIFVzaW5nIDgu
MS42LjEgb24gTlQuPEJSPjxCUj5JIGNhbiB1cGRhdGUgb3RoZXIgdGFibGVzIG93bmVkIGJ5IHVz
ZXIgJ0JPQicuIDxCUj48QlI+QWxsIHRhYmxlcyB3ZXJlIGNyZWF0ZWQgdmlhIElNUE9SVC4gVGFi
bGUgWCAnc2hvdWxkJyBiZSB0aGUgc2FtZSBhcyB0aGU8QlI+cmVzdC48QlI+PEJSPkJ1dCBubyBv
bmUgY2FuIHVwZGF0ZSB0YWJsZSBYLCBvd25lZCBieSBCT0IuIDxCUj48QlI+Tm8gZXJyb3JzIGFy
ZSByZXR1cm5lZCBhbmQgbm8gYWxlcnQgbG9nIGVudHJpZXMgYXJlIGdlbmVyYXRlZC4gU1FMIFBM
dXM8QlI+c2ltcGx5IGhhbmdzLiA8QlI+PEJSPkl0IGRvZXNuJ3QgbWF0dGVyIGlmIGl0IGlzIDEg
cmVjb3JkIHRvIGJlIHVwZGF0ZWQgb3IgMzAsMDAwLCB0aGUgc2FtZSByZXN1bHQ8QlI+LSBub3Ro
aW5nLjxCUj48QlI+Qk9CIGNhbiBzZWxlY3QgZnJvbSB0aGlzIGFuZCBvdGhlciB0YWJsZXMganVz
dCBmaW5lLjxCUj48QlI+Qk9CIGNhbiB1cGRhdGUgb3RoZXIgdGFibGVzIGp1c3QgZmluZS48QlI+
PEJSPklkZWFzPzxCUj48QlI+VGhhbmtzLDxCUj48QlI+TWlrZTxCUj4tLSA8QlI+UGxlYXNlIHNl
ZSB0aGUgb2ZmaWNpYWwgT1JBQ0xFLUwgRkFROiBodHRwOi8vd3d3Lm9yYWZhcS5jb20gPEJSPi0t
IDxCUj5BdXRob3I6IEJvbmQsIE1pa2U8QlI+SU5FVDogQ0VNQUJAY2V3cy5va2MuZGlzYS5taWwg
PEJSPjxCUj5GYXQhDQohDQogQ2l0eSBOZXR3b3JrIFNlcnZpY2VzIC0tICg4NTgpIDUzOC01MDUx
IEZBWDogKDg1OCkgNTM4LTUwNTE8QlI+U2FuIERpZWdvLCBDYWxpZm9ybmlhIC0tIFB1YmxpYyBJ
bnRlcm5ldCBhY2Nlc3MgLyBNYWlsaW5nIExpc3RzPEJSPi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPEJSPlRvIFJFTU9W
RSB5b3Vyc2VsZiBmcm9tIHRoaXMgbWFpbGluZyBsaXN0LCBzZW5kIGFuIEUtTWFpbCBtZXNzYWdl
PEJSPnRvOiBMaXN0R3VydUBmYXRjaXR5LmNvbSAobm90ZSBFWEFDVCBzcGVsbGluZyBvZiAnTGlz
dEd1cnUnKSBhbmQgaW48QlI+dGhlIG1lc3NhZ2UgQk9EWSwgaW5jbHVkZSBhIGxpbmUgY29udGFp
bmluZzogVU5TVUIgT1JBQ0xFLUw8QlI+KG9yIHRoZSBuYW1lIG9mIG1haWxpbmcgbGlzdCB5b3Ug
d2FudCB0byBiZSByZW1vdmVkIGZyb20pLiBZb3UgbWF5PEJSPmFsc28gc2VuZCB0aGUgSEVMUCBj
b21tYW5kIGZvciBvdGhlciBpbmZvcm1hdGlvbiAobGlrZSBzdWJzY3JpYmluZykuPEJSPi0tIDxC
Uj5QbGVhc2Ugc2VlIHRoZSBvZmZpY2lhbCBPUkFDTEUtTCBGQVE6IGh0dHA6Ly93d3cub3JhZmFx
LmNvbSA8QlI+LS0gPEJSPkF1dGhvcjogSmVmZmVyeSBTdGV2ZW5zb248QlI+SU5FVDogamVmZkBt
cHYuY29tIDxCUj48QlI+RmF0IENpdHkgTmV0d29yayBTZXJ2aWNlcyAtLSAoODU4KSA1MzgtNTA1
MSBGQVg6ICg4NTgpIDUzOC01MDUxPEJSPlNhbiBEaWVnbywgQ2FsaWZvcm5pYSAtLSBQdWJsaWMg
SW50ZXJuZXQgYWNjZXNzIC8gTWFpbGluZyBMaXN0czxCUj4tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTxCUj5UbyBSRU1P
VkUgeW91cnNlbGYgZnJvbSB0aGlzIG1haWxpbmcgbGlzdCwgc2VuZCBhbiBFLU1haWwgbWVzc2Fn
ZTxCUj50bzogTGlzdEd1cnVAZmF0Y2l0eS5jb20gKG5vdGUgRVhBIQ0KIQ0KQ1Qgc3BlbGxpbmcg
b2YgJ0xpc3RHdXJ1JykgYW5kIGluPEJSPnRoZSBtZXNzYWdlIEJPRFksIGluY2x1ZGUgYSBsaW5l
IGNvbnRhaW5pbmc6IFVOU1VCIE9SQUNMRS1MPEJSPihvciB0aGUgbmFtZSBvZiBtYWlsaW5nIGxp
c3QgeW91IHdhbnQgdG8gYmUgcmVtb3ZlZCBmcm9tKS4gWW91IG1heTxCUj5hbHNvIHNlbmQgdGhl
IEhFTFAgY29tbWFuZCBmb3Igb3RoZXIgaW5mb3JtYXRpb24gKGxpa2Ugc3Vic2NyaWJpbmcpLjxC
Uj48QlI+LS0gPEJSPlBsZWFzZSBzZWUgdGhlIG9mZmljaWFsIE9SQUNMRS1MIEZBUTogaHR0cDov
L3d3dy5vcmFmYXEuY29tPEJSPi0tIDxCUj5BdXRob3I6IFJvbiBSb2dlcnM8QlI+SU5FVDogUlJP
R0VSU0BnYWxvdHRlcnkub3JnPEJSPjxCUj5GYXQgQ2l0eSBOZXR3b3JrIFNlcnZpY2VzIC0tICg4
NTgpIDUzOC01MDUxIEZBWDogKDg1OCkgNTM4LTUwNTE8QlI+U2FuIERpZWdvLCBDYWxpZm9ybmlh
IC0tIFB1YmxpYyBJbnRlcm5ldCBhY2Nlc3MgLyBNYWlsaW5nIExpc3RzPEJSPi0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
PEJSPlRvIFJFTU9WRSB5b3Vyc2VsZiBmcm9tIHRoaXMgbWFpbGluZyBsaXN0LCBzZW5kIGFuIEUt
TWFpbCBtZXNzYWdlPEJSPnRvOiBMaXN0R3VydUBmYXRjaXR5LmNvbSAobm90ZSBFWEFDVCBzcGVs
bGluZyBvZiAnTGlzdEd1cnUnKSBhbmQgaW48QlI+dGhlIG1lc3NhZ2UgQk9EWSwgaW5jbHVkZSBh
IGxpbmUgY29udGFpbmluZzogVU5TVUIgT1JBQ0xFLUw8QlI+KG9yIHRoZSBuYW1lIG9mIG1haWxp
bmcgbGlzdCB5b3Ugd2FudCB0byBiZSByZW1vdmVkIGZyb20pLiBZb3UgbWF5PEJSPmFsc28gc2Vu
ZCB0aGUgSEVMUCBjb21tYW5kIGZvciBvdGhlciBpbmZvcm1hdGlvbiAobGlrZSBzdWJzY3JpYmlu
ZykuPEJSPi0tIDxCUj5QbGVhc2Ugc2VlIHRoZSBvZmZpY2lhbCBPUkFDTEUtTCBGQVE6IGh0dHA6
Ly93d3cub3JhZiENCiENCmFxLmNvbTxCUj4tLSA8QlI+QXV0aG9yOiBCb25kLCBNaWtlPEJSPklO
RVQ6IENFTUFCQGNld3Mub2tjLmRpc2EubWlsPEJSPjxCUj5GYXQgQ2l0eSBOZXR3b3JrIFNlcnZp
Y2VzIC0tICg4NTgpIDUzOC01MDUxIEZBWDogKDg1OCkgNTM4LTUwNTE8QlI+U2FuIERpZWdvLCBD
YWxpZm9ybmlhIC0tIFB1YmxpYyBJbnRlcm5ldCBhY2Nlc3MgLyBNYWlsaW5nIExpc3RzPEJSPi0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tPEJSPlRvIFJFTU9WRSB5b3Vyc2VsZiBmcm9tIHRoaXMgbWFpbGluZyBsaXN0LCBz
ZW5kIGFuIEUtTWFpbCBtZXNzYWdlPEJSPnRvOiBMaXN0R3VydUBmYXRjaXR5LmNvbSAobm90ZSBF
WEFDVCBzcGVsbGluZyBvZiAnTGlzdEd1cnUnKSBhbmQgaW48QlI+dGhlIG1lc3NhZ2UgQk9EWSwg
aW5jbHVkZSBhIGxpbmUgY29udGFpbmluZzogVU5TVUIgT1JBQ0xFLUw8QlI+KG9yIHRoZSBuYW1l
IG9mIG1haWxpbmcgbGlzdCB5b3Ugd2FudCB0byBiZSByZW1vdmVkIGZyb20pLiBZb3UgbWF5PEJS
PmFsc28gc2VuZCB0aGUgSEVMUCBjb21tYW5kIGZvciBvdGhlciBpbmZvcm1hdGlvbiAobGlrZSBz
dWJzY3JpYmluZykuPC9CTE9DS1FVT1RFPjxwPjxicj48aHIgc2l6ZT0xPjxiPkRvIFlvdSBZYWhv
Received on Fri Dec 01 2000 - 12:22:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US