dbca errors ORA-24344 (SYS.RECOMP_CATMETA_VIEWS) , ORA-04031

 

I was trying to create database on a test VM and thought of allocating just 300MB to memory_target which was around 15% of available RAM for that VM.

Received these errors during dbca database creation:

 

As ORA-04031 was raised for java pool and shared pool, its evident that the allotted memory for this instance is not adequate. As a consequence the SYS.RECOMP_CATMETA_VIEWS was having errors.

Did “Abort”, then went back to screen where memory_target can be changed. Changed it to 600MB, i.e. 30% of available RAM.

After this change these errors were not reported by dbca while creating the database.

 

HTH.