CLEAR GRAPH Statement Very Slow Performance (Doc ID 1466790.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Semantics and inserting millions of statements in the database, all in the same graph, via SPARQL Update through Joseki. Attempted to empty the graph by running the SPARQL Update statement CLEAR GRAPH against the database. This runs for at least 16 hours without finishing.

The exact statement issued is "CLEAR GRAPH ".

All interaction with the database has so far been through Joseki and the Jena Adapter API.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms