[opencms-dev] missing pl/sql procedures with genericsql install

[Alexander Kandzior]

Hi Dan,

> However, with the OCI driver, a large number of PL/SQL 
> packages were installed.  With the genericSql driver, no 
> packages were installed.  This is cause for concern.  
> 
> Does OpenCMS need the PL/SQL packages to use Oracle effectively?

it depends on the driver used. 
If you use the genericSQL driver, you don't need PL/SQL.

PL/SQL was introduced to increase performance for OpenCms running on
Oracle
a while back. Using PL/SQL reduces the number of DB queries since 
logic like permission information etc. is checked in Oracle PL/SQL
directly.
To goal of introducing PL/SQL qas to increase performance.
However, some measurements on the topic have shown that
this performance gains are in the below 10% range.

So the PL/SQL procedures in Oracle are not needed for the genericSQL
driver,
since with this driver all logic resides in the OpenCms java classes.

Hope this helps.

Regards,
Alex.

Alexander Kandzior
OpenCms Group