dbms_stats.gather_schema_stats with the option gather_auto
From: <michael.spoden_at_web.de>
Date: Mon, 23 Jun 2008 05:17:06 -0700 (PDT)
Message-ID: <d7c3bc7c-0e41-4fd6-b826-a62f74e3d2da@k37g2000hsf.googlegroups.com>
Date: Mon, 23 Jun 2008 05:17:06 -0700 (PDT)
Message-ID: <d7c3bc7c-0e41-4fd6-b826-a62f74e3d2da@k37g2000hsf.googlegroups.com>
Hi,
is there a possibility to use the dbms_stats package on schema level to just see which tables would be affected by the gather_auto option?
I want first see which tables would be analyzed depending on the output I want to start the dbms_stats package for this schema, or maybe just for some less tables of this output.
Regards
Michael Received on Mon Jun 23 2008 - 07:17:06 CDT