undo segment

In an undo tablespace...how many undo segments are created..
tonydbaAsked:
Who is Participating?
 
Devinder Singh VirdiConnect With a Mentor Lead 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;
0
 
sdstuberCommented:
as many as are needed depending on the number and size of transactions
0
 
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.
0
 
tonydbaAuthor Commented:
yes got it
0
All Courses

From novice to tech pro — start learning today.