1 Reply Latest reply on Aug 12, 2016 12:29 AM by Sdas-Oracle

    Tablespaces keep growing

    3054700

      Dear all,

       

      I have created a semantic network using a tablespace called rdf_users:

      EXECUTE SEM_APIS.CREATE_SEM_NETWORK('RDF_USERS');
      

       

      In this semantic network I have two semantic models, i.e with two triples tables to store references (rdf_data_1 and rdf_data_2):

      EXECUTE SEM_APIS.CREATE_SEM_MODEL('model1', 'rdf_data_1', 'triple');
      EXECUTE SEM_APIS.CREATE_SEM_MODEL('model2', 'rdf_data_2', 'triple');
      

       

      I then loaded triples in the model (from a relational database, i.e creating virtual models, exporting them into a staging table with SEM_APIS.EXPORT_RDFVIEW_MODEL and bulk loading from the staging table to the semantic model with SEM_APIS.BULK_LOAD_FROM_STAGING_TABLE)

       

      The rdf_users tablespace grew up to 170G.

       

      Now I deleted one model (both models contain approximately the same volume of data):

      BEGIN
       SEM_APIS.DROP_RDFVIEW_MODEL(model_name => 'model2');
      END;
      DROP TABLE rdf_data_2 PURGE;
      

       

      At that point I want to generate a third model model3, but I'm having the following issue when triples are loaded into the model from a staging table (Note that they are not loaded all at once but in smaller batches):

       

      BEGIN
       SEM_APIS.BULK_LOAD_FROM_STAGING_TABLE('model3','username','STAGE_TABLE');
      END;
      (error) DBD::Oracle::db do failed: ORA-13199:  MRG1opt failed: error stack:
      ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO01'
      
      [
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 6239
      
      ]
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 6279
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 7873
      ORA-06512: at "MDSYS.SDO_RDF", line 1014
      ORA-06512: at "MDSYS.RDF_APIS", line 926
      ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute)
      

       

      Indeed my HD is full (100% used!)

       

      But checking free space in the tablespaces I see than undo tablespace is 100% free (checked using this query) but bulk loading still tries to extend it.

      Tablespace Used(MB) Free(MB) Total(MB) Free(%)
      SYSAUX         5019      321      5340       6
      USERS             1    32725     32726     100
      USERS1        10102    11850     21952      54
      UNDO01           40    98911     98951     100
      SYSTEM          871        9       880       1
      RDF_USERS     79563    94295    173858      54
      
      

       

      I also tried to resize RDF_USERS, but couln't:

      ALTER TABLESPACE RDF_USERS RESIZE 150G
      Error report -
      SQL Error: ORA-03297: file contains used data beyond requested RESIZE value
      

       

      I'm not sure it is a RDF related issue, or what I am missing, but I can not figure out how to generate a new model (actually replace one, since I'm trying to remove a model before recreating it) since it seems to always need to extend tablespaces!

       

      Any help appreciated!

       

      Thanks

      Fred

        • 1. Re: Tablespaces keep growing
          Sdas-Oracle

          Hi Fred,

           

          The problem you are seeing seems to be an RDBMS (tablespace) issue, not an RDF issue. The error is being raised during processing of an INSERT /*+ APPEND */ statement issue by bulk-load to append the current batch of input triples (in id-based form) into the table partition designated for the RDF model.

           

          If you'd like, you can contact me by email: souripriya dot das at oracle dot com.

           

          Thanks,

          - Souri.