[EMAIL PROTECTED] wrote:
> however make test gives me the following:
> $ make test
[snip]
> t/meta.......DynaLoader.pm loaded (/wrk/DBD-Oracle-1.14/blib/lib
[snip]
>
> and it never comes back.
You don't by any chance have CBO optimiser statistics on the SYS schema? Is
there any activity on the Oracle database?
I had a similar looking problem recently, with the tests in t/meta that hit
the data dictionary causing Oracle to go beserk, and the query didn't
execute in a reasonable time. I'd been messing with Oracle and had gathered
CBO statistics on the SYS schema with DBMS_STATS (Oracle say this is
'sort-of' OK in 9.2, since in 10.0 the RBO is going away so you're going to
have to run CBO on SYS so they're starting to support it in 9.2, but it's
not as well tested). The result appears to be terrible execution plans on
the data dictionary in various cases.
If you have statistics on SYS you might want to drop them
(dbms_stats.delete_schema_stats) or turn the optimiser to RBO for t/meta
(alter session set optimizer_mode = RULE)
Maybe it's worth adding the alter session to t/meta.t, since unless you're
the DBA you're not going to be able to drop the stats or alter the default
optimiser mode? (Although maybe it would then break when 10.0 comes out...
so it should probably be version dependent, i.e. only do it on 9.2?)
--- t/meta.t~ 2003-03-25 13:57:57.000000000 +0000
+++ t/meta.t 2003-06-15 13:55:55.000000000 +0100
@@ -28,6 +28,8 @@
exit 0;
}
+$dbh->do('alter session set optimizer_mode = RULE');
+
print "1..10\n";
my @tables = $dbh->tables;
--
Andy Hassall ([EMAIL PROTECTED]) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
