Re: DP export 5x slower in 11.2 than 10.1
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Tue, 14 Aug 2012 11:17:20 -0500 (CDT)
Message-ID: <923c41c3986d634820140a56022886d9.squirrel_at_society.servebeer.com>
Raj writes:
Date: Tue, 14 Aug 2012 11:17:20 -0500 (CDT)
Message-ID: <923c41c3986d634820140a56022886d9.squirrel_at_society.servebeer.com>
Raj writes:
> So, if you exclude=procedure it still works fine? I wonder if you just
> spin off include=procedure by itself and see how well it works. I
> don't have a db that has many packages unfortunately to test.
That's a good point. In the schemas I'm working with, there are 10K tables and 22K indexes, but only 4 procedures and 8 triggers, with ZERO packages.
It seems unlikely that the source for those procs/triggers wouldn't cause my metadata-only DP export to go from 4 min to almost 20 min...
Thanks!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 14 2012 - 11:17:20 CDT