The problems we're having are daily space growth and some jobs failing due to constraint violations although the job errrors are sproadic in the VC database. ESX hosts don't appear to have any issues. This is with Oracle 9i patched to the correct level. We've been using Oralce 9i with VC 2.0 for at least a year and no issues and before that Oralce 8 and VC 1.x for several years and no problems. This release they appear to have not fully understood how Oracle works.
e.g. one of the scheduled jobs fail due to constraint violation:
ORA-12012: error on auto execute of job 47
ORA-00001: unique constraint (VPX.VPX_SAMPLE_TIME2_U1) violated
ORA-06512: at "VPX.STATS_ROLLUP1_PROC", line 222
The job is #47 and performs the following actions:
begin stats_rollup1_proc; Purge_Stat1_proc; end;
Another time we checked:
SQL> select job,substr(what,1,50) what,failures,broken from user_jobs
JOB WHAT FAILURES B
-
-
-
-
47 begin stats_rollup1_proc; Purge_Stat1_proc; end; 0 N
48 begin stats_rollup2_proc; Purge_Stat2_proc; end; 3 N
49 begin stats_rollup3_proc; Purge_Stat3_proc; end; 0 N
