Documentation bug #5882161 is available for viewing. -- Mark D Powell -- Phone (313) 592-5148 ________________________________ From: Powell, Mark D Sent: Friday, February 27, 2009 3:53 PM To: 'veeeraman@xxxxxxxxx' Subject: RE: v$undostat rows The 10g documentation is wrong. This is a known documentation bug. The 11g manual has the update. -- Mark D Powell -- Phone (313) 592-5148 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ram Raman Sent: Friday, February 27, 2009 3:01 PM To: ORACLE-L Subject: v$undostat rows While trying to get some information from v$undostat, I found that the view has only 576 rows in both our production and test databases. This is v10.202. However, the 10.2 document says that it has 1008 rows for 7 days: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_ 2174.htm The 11.1 doc has it as 576 rows: http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/dynviews_ 3110.htm Is this something documentation bug? i was trying to find out week end activity, grr.. Too lazy to run awr.