I'm helping in getting a dotlrn site up and running and I am looking at the Oracle Statspack reports. Its figures suggest that the Oracle Server is trashing away its time parsing statements again and again.
My first guess is that new-portals is the culprit. It sends queries with in (1234,2345,3456) - aka hard-coded values - so that Oracle has to do the parsing work over and over again.
Looking at e. g. forums-portlet.tcl I find this
set list_of_package_ids $config(package_id)
I was browsing new-portals' and forum-portlets' code to find the place and eventually the sql query that fills config(package_id). To no avail - can someone point me to the particular piece of code that computes the list of packages for a portlet?