Re: ignored duplicate rollback segment

yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0311240903.5b58df81_at_posting.google.com>...
> sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0311170617.1a2f78a1_at_posting.google.com>...
> > yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0311170018.353f8111_at_posting.google.com>...
> > > i have this set of messages appearing regularly in my alert file.
> > >
> > > Ignored duplicate rollback segment 12 in ROLLBACK_SEGMENTS parameter
> > > Ignored duplicate rollback segment 2 in ROLLBACK_SEGMENTS parameter
> > > Ignored duplicate rollback segment 13 in ROLLBACK_SEGMENTS parameter
> > > Ignored duplicate rollback segment 14 in ROLLBACK_SEGMENTS parameter
> > > Ignored duplicate rollback segment 15 in ROLLBACK_SEGMENTS parameter
> >
> > So verify the rollback_segments parameter in init.ora and discover you
> > do have duplicated segment names in it.
> >
> > Sybrand Bakker
> > Senior Oracle DBA
>
>
>
> in my initsid.ora, i had the following rollback segments
> rollback_segments = (PRS_1,PRS_10,PRS_11,PRS_12,PRS_13,PRS_14,PRS_2,PRS_3,PRS_4,PRS_5,PRS_6,PRS_7,PRS_8,PRS_9,
> prs_10, prs_11,
> prs_12, prs_13, prs_14, prs_15, prs_16, prs_17, prs_18, prs_19,
> prs_20, prs_21, prs_22, prs_23, prs_24, prs_25, prs_26, prs_27,
> prs_28, prs_29, prs_30)
>
> as you could see.... rollback segment, 12, 13, 14, are declared twice.
>
> but PRS_2, prs_15 are declared once.
>
> my understanding tells me that PRS_12 and prs_12 are the same,
> irregardless of big case?
>
> another question is what happens to PRS_2, prs_15. they are declared
> once only.

I bet if you select segment_name, segment_id from dba_rollback_segs; you'll see the numbers don't correspond to the declared names, but rather to the order declared.

jg

--
@home.com is bogus.
"Please and Thank You are the lubricants of social intercourse."  -
Heard on radio.