Re: What segment extended & when?

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.
Received on Thu Jun 29 2000 - 00:00:00 CDT