| deadlock detected while auto execute of job [message #170825] |
Fri, 05 May 2006 06:03 |
first2last4
Messages: 10
Registered: May 2006
Location: Dubai
|
Junior Member |
|
|
Hi,
We use Oracle 8i DB and I have the following view and materialized view based on a view.
#View 'CAPACITY_REPORT' based on 5 base tables (takes at least 15 - 20 seconds to return the results)
#Materialized View
-----------------
create materialized view MV_CAPACITY_REPORT
build immediate
refresh complete on demand
as select * from CAPACITY_REPORT
/
A DBMS_JOB has been configured to refresh the Materialized views MV_CAPACITY_REPORT every 15 min. The base tables of this view is updated frequently and in last 4-5 weeks I've got the following error 3 times in the alerts log file.
ORA-12012: error on auto execute of job 5730
ORA-04020: deadlock detected while trying to lock object PRODUCTION.CARD_INST
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 654
ORA-06512: at line 1
PRODUCTION.CARD_INST is the base table. Apparently it looks like this error is logged when a DML statement is performed on the base table and the dbms job to refresh the Materialized view is done simulateously. Not sure how can I get this resolved? Any help would be really appreciated.
[Updated on: Fri, 05 May 2006 09:14] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
