Re: Analyzing all objects
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1996/02/05
Message-ID: <Pine.SUN.3.91.960205094055.1163A-100000_at_seatimes>#1/1
Date: 1996/02/05
Message-ID: <Pine.SUN.3.91.960205094055.1163A-100000_at_seatimes>#1/1
On Fri, 2 Feb 1996, Brian Sakach wrote:
> Does anyone care to share any quick easy tricks to analyze
> all their tables and indexes with an easy SQL script?????
execute dbms_utility.analyze_schema('name','COMPUTE')
Of course, you need to have loaded the procedural stuff first. You may use the ESTIMATE, and DELETE options in place of COMPUTE.
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Mon Feb 05 1996 - 00:00:00 CET