My Oracle Support Banner

Graph Load Time (RDBMS To PGX) Taking Too Long (Doc ID 2486366.1)

Last updated on APRIL 17, 2023

Applies to:

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


Using the PGX server with Production data using graph tables in Oracle show the following result.

[DEBUG] 2018-09-25 16:19:39.628 [pgx-client-thread-4] vertex-logger - [GraphMetaData [numVertices=2718409, numEdges=13392322, memoryMb=1579, dataSourceVersion=6265232746904, creationRequestTimestamp=1537883461376 (2018-09-25 15:51:01.376), creationTimestamp=1537885176109 (2018-09-25 16:19:36.109), vertexIdType=long, edgeIdType=long, directed=true]]

The graph took about 40 minutes to load. Db monitoring identified the following query was taking the most time:

select /*+ parallel(1) */ eid,SVID,DVID,EL,k,t,v,vn,TO_CHAR(vt,'YYYY-MM-DD"T"HH24:MI:SS.FFTZH:TZM') AS vt ,vts,vte from ( select * from "PGXTXN".PAYMENTSGE$ as of scn 6265232746904 ) t where mod(EID, 1)=0 order by svid, dvid, eid




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.