Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tablespaces keep growing

3054700Aug 10 2016 — edited Sep 5 2016

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

This post has been answered by Sdas-Oracle on Aug 11 2016
Jump to Answer

Comments

Sdas-Oracle
Answer

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.

Marked as Answer by 3054700 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 8 2016
Added on Aug 10 2016
1 comment
858 views