Re: Reusing name of rollback segment

This may be related to monitoring -

If you drop and recreate a rollback segment reusing the same name, you will end up re-using the same undo number (undo$.us#) for the rollback segment.

If you do this, then the statistics in v$rollstat for that rollback segment will still exist in memory, and will be reported as if they applied to the new rollback segment (though they will clear down when the database is shut down).

If your reason for dropping the rollback segment was to make a clean start on statistics without re-starting the database, then using the same name defeats the purpose of the exercise.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Grange Man wrote in message <917tle$gad$1_at_nnrp1.deja.com>...


>Someone told me recently that if one drops and recreates a rollback

>segment (say to change its size), that it should be given a new name,

>not the name it used to have.

>

>Is there any basis for this?

>

>Thanks.

>

>

>Sent via Deja.com

>http://www.deja.com/