RE: Performance issue to connect to an Oracle database using Oracle's OEM driver

[ThomasSoeiro]

This is a follow up of issue #606. I can still reproduce despite PR #777.

I posted an update there, but I don't know if you were notified as I didn't get feedback. Sorry if you were and I'm polluting your backlog!

library(DBI)

start_time <- Sys.time()
con1 <- dbConnect(odbc::odbc(), dsn = "OracleODBC-19g")
Sys.time() - start_time
# Time difference of 26.12799 mins

dbDisconnect(con1)

options(connectionObserver = NULL)

start_time <- Sys.time()
con2 <- dbConnect(odbc::odbc(), dsn = "OracleODBC-19g")
Sys.time() - start_time
# Time difference of 1.631401 secs

# dbDisconnect(con2)

Database

dbGetInfo(con2)
# $dbname
# [1] ""
# 
# $dbms.name
# [1] "Oracle"
# 
# $db.version
# [1] "19.00.0000"
# 
# $username
# [1] ""
# 
# $host
# [1] ""
# 
# $port
# [1] ""
# 
# $sourcename
# [1] "OracleODBC-19g"
# 
# $servername
# [1] "zzz"
# 
# $drivername
# [1] "SQORA32.DLL"
# 
# $odbc.version
# [1] "03.52"
# 
# $driver.version
# [1] "19.23.0000"
# 
# $odbcdriver.version
# [1] "03.52"
# 
# $supports.transactions
# [1] TRUE
# 
# $supports.catalogs
# [1] FALSE
# 
# $supports.schema
# [1] TRUE
# 
# $getdata.extensions.any_column
# [1] TRUE
# 
# $getdata.extensions.any_order
# [1] TRUE
# 

Session Info

sessionInfo()
# R version 4.4.3 (2025-02-28)
# Platform: x86_64-pc-linux-gnu
# Running under: Red Hat Enterprise Linux 8.10 (Ootpa)
# 
# Matrix products: default
# BLAS/LAPACK: /usr/lib64/libopenblasp-r0.3.15.so;  LAPACK version 3.9.0
# 
# locale:
#  [1] LC_CTYPE=fr_FR.UTF-8       LC_NUMERIC=C               LC_TIME=fr_FR.UTF-8        LC_COLLATE=fr_FR.UTF-8     LC_MONETARY=fr_FR.UTF-8   
#  [6] LC_MESSAGES=fr_FR.UTF-8    LC_PAPER=fr_FR.UTF-8       LC_NAME=C                  LC_ADDRESS=C               LC_TELEPHONE=C            
# [11] LC_MEASUREMENT=fr_FR.UTF-8 LC_IDENTIFICATION=C       
# 
# time zone: GMT
# tzcode source: system (glibc)
# 
# attached base packages:
# [1] stats     graphics  grDevices datasets  utils     methods   base     
# 
# other attached packages:
# [1] DBI_1.2.3
# 
# loaded via a namespace (and not attached):
#  [1] bit_4.0.5         odbc_1.6.0        compiler_4.4.3    cli_3.6.4         hms_1.1.3         tools_4.4.3       rstudioapi_0.16.0
#  [8] Rcpp_1.0.14       bit64_4.0.5       vctrs_0.6.5       blob_1.2.4        lifecycle_1.0.4   pkgconfig_2.0.3   rlang_1.1.5