Doh! Thanks to all who replied. (I saw that column, but thought it was come kind of cumulative statistic. Who knew!!!) Christopher: Your script has gobs of good stuff that I was looking for. Thanks a bunch! Barb
> ---------- > From: Christopher Spence[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, October 04, 2001 1:25 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Where is optimal for RBS? > > V$rollstat > > But you can use the script I wrote "rbsinfo.sql" from my site: > > http://www.vampired.net/scripts/php/rbs.php > > It simply joins it with V$rollname to give names other than USN numbers > and > does some formatting. > > "Do not criticize someone until you walked a mile in their shoes, that way > when you criticize them, you are a mile a way and have their shoes." > > Christopher R. Spence > Oracle DBA > Phone: (978) 322-5744 > Fax: (707) 885-2275 > > Fuelspot > 73 Princeton Street > North, Chelmsford 01863 > > > > -----Original Message----- > Sent: Thursday, October 04, 2001 2:45 PM > To: Multiple recipients of list ORACLE-L > > Ok, I give up. I've looked everywhere I can think of. > In what table/view do I find the storage parameter that shows me the > Optimal > size set for a rollback segment? > Thanks for your help! > Barb > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Baker, Barbara > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Christopher Spence > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
