I'm trying to size my UNDO tablespace for automatic undo management. The formula for the calculation calls for the number of undo data blocks generated per second. The database can be queried for this using the v$undostat view. Rows are supposed to be written to this view for each 10 minute interval, once the db is running.
Problem:
When I query the v$undostat view, there are no rows returned. I can't find any information about what might be set incorrectly in my database to cause 0 rows to be written to this view.
Question:
Can anyone help me with getting information into the v$undostat view? Or, other ways of getting the same information?
Thanks for any help!
Problem:
When I query the v$undostat view, there are no rows returned. I can't find any information about what might be set incorrectly in my database to cause 0 rows to be written to this view.
Question:
Can anyone help me with getting information into the v$undostat view? Or, other ways of getting the same information?
Thanks for any help!
