Status: Solved
Priority: Medium
Security: Public
Views: 302
Last Modified: 2014-04-06

undo segment

In an undo tablespace...how many undo segments are created..

tonydba

Asked: 2014-04-01

Advertise Here

Oracle Database

1 Solution

LVL 74

sdstuberCommented: 2014-04-01

as many as are needed depending on the number and size of transactions

LVL 23

DavidSenior Oracle Database AdministratorCommented: 2014-04-01

An application running a high volume of inserts, deletes, or updates will need more; queries less (none, no rollback). Say more.

LVL 15

Devinder Singh VirdiLead Oracle DBA TeamCommented: 2014-04-01

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;

tonydbaAuthor Commented: 2014-04-06

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.

Expand your skills with this month's free Premium course.

undo segment

Join & Write a Comment Already a member? Login.

Featured Post