Re: What segment extended & when?

In article <8jfpud$dhh$1_at_nnrp1.deja.com>,   ddf_dba_at_my-deja.com wrote:
> In article <962290673.924.0.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > Don't do it.
> > The underlying uet$ table is one of the most heavily used tables.
> > Also, what happens if your trigger fails, and the transaction
 started
 on
> > behalf of Oracle to update uet$ consequently also fails. I wouldn't
 be
 in
> > your shoes, when Support refuses to help you out.
> > Better build a monitor tool to run at regular intervals. That's
 harmless.
> > Why do so many people the last few days want to 'tweak' the
 data-dictionary?
> > Has everyone gone mad, or am I mistaken?
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > <allanwebster_at_my-deja.com> wrote in message
> > news:8jfipi$7kg$1_at_nnrp1.deja.com...
> > > Hi,
> > >
> > > I'd like to know have a record of when any segment extends. Whats
 the
> > > feeling on putting a trigger on dba_extents (or its underlying
 table)
> > > to insert a copy of the new row into a table of my own, with a
> > > timestamp?
> > >
> > > I've heard that Oracle strongly advise against putting triggers on
> > > dictionary objects. Any other solutions?
> > >
> > > Cheers
> > > Allan
> > >
> Possibly. Interestingly enough any attempt to create a trigger on an
> object owned by 'SYS' will fail, at least in 8.1.5.
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>

I have written a simple extent tracking system. It is based on running a job that takes a snaphsot of the sys.dba_segments. This second table is then queried to produce a report like this: {edited to try to format to post screen]

OWNER     OBJ_NAME                  DATE_CHEC CHANGE_COMME  EXTENT_CT
--------- ------------------------- --------- ------------ ----------
MPOWEL01  SECURITY_REPORT           13-SEP-99                       3
MPOWEL01                            20-SEP-99 RESET                 1
MPOWEL01                            04-OCT-99                       5
MPOWEL01                            11-OCT-99 RESET                 1
<snip>
SYSTEM    DQ3_QUERY                 12-NOV-99                      59
SYSTEM                              24-NOV-99                      60
SYSTEM                              03-DEC-99                      61
SYSTEM                              16-DEC-99                      62

Item that shrink are flaged as a truncate/rebuild has occured. I have written routines to create the table, purge old data, and remove deleted objects etc... If you are interested email me and I will share.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.