My Oracle Support Banner

CLEAR GRAPH Statement Very Slow Performance (Doc ID 1466790.1)

Last updated on JANUARY 12, 2020

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.