Hibernate reverse-engineering Oracle does ANALYZE?

[dtseiler]

Actually that topic doesn't portray the situation accurately.

I'm trying to use Hibernate in Eclipse to reverse-engineer a table in our Oracle 10g database. Right now I'm just trying to get a list of the tables in a given schema. That process is taking FOREVER. I went into TOAD and looked at the session browser, and saw that Hibernate is actually analyzing each table with ESTIMATE STATISTICS.

Why does this need to be done? It should just need to get the schema. Estimating statistics looks at data, and some of our tables are huge and so it takes very long to analyzing each one.

So far the process has been running an hour and could very well eat up the rest of the afternoon.

[maxandersen]

we don't do that - oracles driver does that when we get tables.

reduce the number of tables you scan by setting default schema or use the <schema-selection> in reveng.xml.

[dtseiler]

Nihility in #jboss provided further info with this:

http://forums.oracle.com/forums/thread.jspa?threadID=210782