SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-23-2008, 04:49 AM
| ||||
| ||||
 How to differentiate whether the rbs is public or private? Hi, From the dba_rollback_segs, I can't seem to be able to tell if those created rollback segments are public or private. Is there any way I can find this information elsewhere? Can I get the optimum value specified too? Please advice. Thank you in advance. Best Regards, Jeffrey Yee      |
|
02-23-2008, 04:49 AM
| ||||
| ||||
| Re: How to differentiate whether the rbs is public or private? "Jeffrey Yee" <jeffyee@hotmail.com> a écrit dans le message news: ec4cec95.0311270235.7b53971b@posting.google.com... > Hi, > > From the dba_rollback_segs, I can't seem to be able to tell if those > created rollback segments are public or private.Is there any way I > can find this information elsewhere? Can I get the optimum value > specified too? > > Please advice. Thank you in advance. > > Best Regards, > Jeffrey Yee If a rbs has been created PUBLIC, its owner is PUBLIC You can see the OPTIMAL value you specified in creation's sql in v$rollstat (OPTSIZE) By default, rbs are created private, you render them public by "publishing" them to an instance in the init file by listing rbs in the rollback_segments parameter. hth, Alkos |
Linear Mode
