Home » RDBMS Server » Performance Tuning » ORA-03127 error?
ORA-03127 error? [message #288646] Tue, 18 December 2007 04:25 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi all!

My customer claimed that he has an error - Object error with Oracle DB error : ORA-03127.

Search in Oracle error

Quote:


ORA-03127: no new operations allowed until the active operation ends
Cause: An attempt was made to execute a new operation before the active non-blocking operation completed or a new operation was attempted before all the pieces of a column were inserted or fetched.
Action: Execute the new operation after the non-blocking operation completes. If piecewise binds/defines were done, execute the new operation after all the pieces have been inserted or fetched.



I really do not understand that error. Would you like to explain to me?

OS: Solaris
DB: 10.2.0
Application: OAS 10.2
Thank you very much.
Re: ORA-03127 error? [message #288651 is a reply to message #288646] Tue, 18 December 2007 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&q=oracle+03127&meta=

Regards
Michel
Re: ORA-03127 error? [message #288680 is a reply to message #288651] Tue, 18 December 2007 05:19 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel!

Of course, before I wrote the topic at here, I searched in Google, however, nothing can help me. In this forum which I alway log in, is the last one.

I found that the problem caused this error, it was due to one customer inserted into the CLOB column, and transaction did not rollback.

Anyway, thank you!

P/s: Would you like to explain these statement in the ADDM snap

Quote:


Wait class "Application" was not consuming significant database time.
CPU was not a bottleneck for the instance.
Wait class "Network" was not consuming significant database time


Re: ORA-03127 error? [message #288683 is a reply to message #288680] Tue, 18 December 2007 05:24 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Of course, before I wrote the topic at here, I searched in Google

This is so rare and as you didn't say it, I assumed you didn't make it. Sorry.

Thanks for the feedback.

Your ADDM seems to tell there is no problem in your database or it is doing nothing.

Regards
Michel
Previous Topic: Procedure Performance
Next Topic: Fetching Cursor Performance
Goto Forum:
  


Current Time: Wed Dec 07 02:55:19 CST 2016

Total time taken to generate the page: 0.10131 seconds