there is a considerable delay in the first request to execute a spatial queryCan you quantify the delay? What are we talking about here, a few seconds?
any body have any ideas?I'd suspect the delay is the JVM cranking up. Many spatial features are written in java, so they run in the JVM, which can take a while to get going after a database restart.
i would think the delay would be caused in creating a connection for the first time and not creating a result set?Find the sql that is being run and try running this from SQL*Plus after a database restart. This will help diagnose the issue.