Re: Discrepency between v$rollname and dba_rollbackk_segs???

Indeed, RBBTMP was offline.

I changed my ROLLSTAT.SQL to take into account that offline rbs don't show up in V$ views.

Thanks!

--

Sytrem
http://pages.infinit.net/syltrem

"Howard J. Rogers" <howardjr_at_www.com> a écrit dans le message news:
9AZi6.223$305.69531_at_inet16.us.oracle.com...


> Because DBA_ views will tell you all rollback segments that exist,

 whatever


> their status.  And the V$ views will only tell you about those rollback

> segments which are actually online.  I would imagine, therefore that

 RBBTEMP


> has been taken offline at some point.

>

> Regards

> HJR

>

>

>

> "Syltrem" <syltrem_at_videotron.ca> wrote in message

> news:nOSi6.429$Cx3.5419_at_wagner.videotron.net...

> > How could this happen?

> > Was there someone who asked the same thing not so long ago? I think I

> > remember seing this but I did not read the thread since it did not occur

 to


> > me that I could have odd problems like this... And I don`t keep messages

> > long enough to look back a week or two in the past.

> >

> > SQL> select segment_name from dba_rollback_segs;

> >

> > SEGMENT_NAME

> > ------------------------------

> > SYSTEM

> > R01

> > R02

> > R03

> > RBBTMP

> >

> > SQL>

> > select name from v$rollname;

> >

> > NAME

> > ------------------------------

> > SYSTEM

> > R01

> > R02

> > R03

> >

> >

> >

> > --

> >

> > Sytrem

> > http://pages.infinit.net/syltrem

> >

> >

> >

>

>