Monthly Archives: December 2008

Refresh materialized view slower in 10g

Yep,  took over existing procedure of a database with several hundreds of dbms_snapshot.refresh in it, and all on Oracle 9i.  Installed a test-database next to it with, and a complete refresh appeared to be 6 times slower, while producing a lot of archive_logs. Changing to dbms_mview.refresh didn't help, while the parameter  atomic_refresh is default

By |2022-06-07T20:12:39+02:00December 11th, 2008|Database|1 Comment

ORA-04062 bij package. Timestamp has been changed..

Een ‘timestamp’ foutmelding in job. Package gaf de volgende melding: Onverwachte fout; proces volledig afgebroken: ORA-20001: Fout in <package> bij nr. 18212 ORA-00604: error occurred at recursive SQL level 1 ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 11 ORA-04062: timestamp of package “INET.INET_ALGEMEEN_PCK” has been changed

By |2022-06-07T20:13:39+02:00December 8th, 2008|Database|0 Comments

Recent Tweets Jobaclenl