Re: How to find out when a rollback segment was created?

From: MarkP28665 <markp28665_at_aol.com>
Date: 13 Jan 1999 01:01:07 GMT
Message-ID: <19990112200107.22197.00011481@ng134.aol.com>

Jurij Modic >>
Good guess, Mark, but unfortunately RB segments are not among the types of objects stored in the obj$ fixed table on which DBA_OBJECTS view is based. Furtheremore, there seems to be no fixed table that holds the creation timestamp for the rollback segment. <<

I was thinking about dba_segments. The rbs and temp segment information is there, but still no creation information.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Tue Jan 12 1999 - 19:01:07 CST