This content has been marked as final. Show 1 reply
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?
Can you give us the sql for the query that is being executed?
What version of Oracle are you on?
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.
But what does it matter if there is a delay after a database restart? A properly run database system should only be restarted for maintenance reasons. i.e. a restart every few months when you have to patch the database or operating system. So a bit of a delay every couple of months isn't really worth too much concern.