🚀 go-pugleaf

"Tim Truman" <ttruman@nospam.com> wrote in message
news:434ec516$1@newsgroups.borland.com...
>
> >What version of the Oracle jdbc drivers are you using, drivers are you
> >using, and which jre?
> >
> >Also, are you resoving these through TNSNames, or direct?
> >
>
> You may not notice it if users access table objects outside there schema
through grants and do not have the ANALYZE ANY system privilege. Tables in
the user's schema can be analyzed however. It may also be that some DBA's
keep ANALYZE statistics current so random updates do not severely effect the
optimizer.
>
Ah, that explains things a little more. I would suspect that the Connection
object meta data sees the Analyze Any option and uses it by default.

> We are using the Oracle jdbc driver Versions 9.2.0.1 and 10.1.0.4.0.  Thin
direct connections. The JRE version I am using to duplicate the issue is
1.4.2_06.
>
Thought I would ask. The Oracle site was vague in the past, about which
drivers would be used. On Oracle 8i, for instance, they recommended
classes12.zip, which did not work well on 1.4.x.

> As a side note there are several business applications connected to the
production server using both driver versions and JRE 1.4.2_06 that do ~not~
exhibit this behavior. I just duplicated the behavior on Oracle 10g Release
2 10.2.0.1. So my guess is I can get this to happen on 9i as well.
>
I do not know how you are going to adjust this behavior from DBPilot
however.

Hint: Try Squirrel. Does it exhibit the same behavior?
http://squirrel-sql.sourceforge.net/