It's harder than that anyway.
a) Extent management in 8.1 goes into
a couple of x$ if you use locally managed
tablespaces.
b) If you stick with system-managed tablespaces
the things that reports dba_segments and
dba_extents is such nasty view that they take
ages to run. You don't want to query them
regularly.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Sybrand Bakker wrote in message
<962290673.924.0.pluto.d4ee154e_at_news.demon.nl>...
>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?
>
Received on Thu Jun 29 2000 - 00:00:00 CDT
