• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

undo segment

In an undo tablespace...how many undo segments are created..
0
tonydba
Asked:
tonydba
1 Solution
 
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
 
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;
0
 
tonydbaAuthor Commented:
yes got it
0
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now