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 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Using the PGX server with Production data using graph tables in Oracle 12.2.0.1.0 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
Changes
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |