Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What segment extended & when?
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
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
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 Sent via Deja.com http://www.deja.com/ Before you buy.Received on Thu Jun 29 2000 - 00:00:00 CDT