undo segment

In an undo tablespace...how many undo segments are created..
Who is Participating?
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Your question is littlebit unclear to me.
If you want to know how much is used then you can query DBA_HIST% tables to find more information.
select * from dba_hist_undostat;
select * from DBA_UNDO_EXTENTS;
as many as are needed depending on the number and size of transactions
DavidSenior Oracle Database AdministratorCommented:
An application running a high volume of inserts, deletes, or updates will need more; queries less (none, no rollback).  Say more.
tonydbaAuthor Commented:
yes got it
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.