3 Replies Latest reply on Nov 14, 2014 5:25 PM by Sdas-Oracle

    Commits in bulk load

    ChrD

      Hi

       

      After 16 hours of SEM_APIS.bulk_load_from_staging_table () of 150.000.000 triplets on v. 11.2.0.3.0 I get

       

      ORA-13199:  MRG1opt:SQLERRM=ORA-01652: unable to extend temp segment by 128 in tablespace TEMPORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 5624

      ORA-06512: at "MDSYS.MD", line 1723

      ORA-06512: at "MDSYS.MDERR", line 17

      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 5660

      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 6623

      ORA-06512: at "MDSYS.SDO_RDF", line 707

      ORA-06512: at "MDSYS.RDF_APIS", line 893


      so - to free up space - there should probably be some commits underway (after taking "care" of the blank nodes).


      Do you have any performance measurements on bulk loads?


      Kind regards - Christian