My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.