Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What segment extended & when?

Re: What segment extended & when?

From: <ddf_dba_at_my-deja.com>
Date: 2000/06/29
Message-ID: <8jfpud$dhh$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US