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

    Tablespaces keep growing


      Dear all,


      I have created a semantic network using a tablespace called 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):

       SEM_APIS.DROP_RDFVIEW_MODEL(model_name => 'model2');
      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):


      (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:

      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!




        • 1. Re: Tablespaces keep growing

          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.



          - Souri.