CBC Latch Contention – My Experience

Recently, i got an opportunity to look into CBC latch contention on 9.2.0.8 database version at one of the client's site.As the number of users connecting to the database increased its performance degraded with poor application performance. The first thing was to check the statspack report.Lets see what the "Top 5 Wait Events" had to … Continue reading CBC Latch Contention – My Experience

Advertisement

MVIEW creation on tables with “OBJECT TYPE”

Recently i faced the below error while creating the materialized view on the target database. ORA-21700:object does not exist or is marked for delete CREATE MATERIALIZED VIEW LAPTEST.USER_MASTER TABLESPACE LAP_MATERIALIZE_VIEW BUILD IMMEDIATE USING INDEX TABLESPACE LAPDATA REFRESH COMPLETE ON DEMAND WITH PRIMARY KEY AS SELECT * FROM UA_USER_MASTER@DB_LINK_LAPTEST_MFREP; SELECT * FROM UA_USER_MASTER@DB_LINK_LAPTEST_MFREP * ERROR at … Continue reading MVIEW creation on tables with “OBJECT TYPE”