Question: What is the ROracle driver and how
does it compare with RJDBC and Oracle JDBC?
Answer: ROracle is a DBI-compliant Oracle
driver based on the ProC/C++ embedded SQL. ROracle is similar in
purpose to RJDBC in that it acts as an interface between R and an
Oracle database. The way they operate, however, is vastly
different. ROracle uses the Oracle libraries to handle the
connections to the database, where RJDBC can hook up any kind of
JDBC datasource into R. ROracle provides much better performance
than RJDBC, although it is considered to be much more difficult to
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.