How to collect and distribute SQL profiles from/to several databases?
Dear all,
we are running a site with several databases for several application instances.
During our several tuning sessions in all databases we found many SQL profiles which we want to collect and to distribute to all databases.
I know, with create_stgtab_sqlprof, pack_stgtab_sqlprof, expdp, impdp, unpack_stgtab_sqlprof you can transport the profiles from one database to another one.
My problem is: I have profiles in all databases and I want to merge these profiles and then to distribute them back to all databases.
I know, we have to do this nearly every week in the next year(s) (because of several tuning sessions, new releases, ...).
0