Re: Index Maintenance: Another Oracle Gem

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 17 Oct 2006 14:08:21 -0700
Message-ID: <1161119296.611938@bubbleator.drizzle.com>

Steve Howard wrote:
> Brian Peasland wrote:

>> Daniel,
>>
>> I'm curious as to why you would build this utility. You, yourself, have
>> been a proponent of *not* rebuilding indexes.
>>
>> I'm just wondering what your motivation was?!?!?!  :)
>>
>> Cheers!
>> Brian

>
> That is a standard part of the software. Just selecting from
> dba_objects where object_name like 'DBMS%' will reveal a treasure trove
> of functionality.
>
> Some time ago, I started (and have since quit, unfortunately) taking
> one a day and spending thirty minutes with to see where it may be
> useful. It would take a year probably to do them all.
>
> Regards,
>
> Steve

I've been at it for at least 3 now and there is no question they can release them faster than I can learn them.

SQL> SELECT COUNT(*) FROM (
   2 SELECT DISTINCT package_name, object_name    3 FROM all_arguments);

   COUNT(*)

---

      14634

At one object per day that is 40 years worth of work in 10gR2.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Oct 17 2006 - 16:08:21 CDT