Solved

undo segment

Posted on 2014-04-01

Oracle Database

1 solution

291 Views

Last Modified: 2014-04-06

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

Comment

Question by:tonydba

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

4 Comments

LVL 74

Expert Comment

by:sdstuber

ID: 399705372014-04-01

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

LVL 23

Expert Comment

by:David

ID: 399706682014-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

Accepted Solution

by:Devinder Singh Virdi

Devinder Singh Virdi earned 500 total points

ID: 399708082014-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;

Author Closing Comment

by:tonydba

ID: 399817002014-04-06

yes got it

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to use Oracle (simple) table compression

Article by: Christoffer

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…

Oracle Database

Configuring and using Oracle Database Gateway for ODBC

Article by: sdstuber

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…

Oracle Database

Executing a SQL Script from a Unix Shell Script and Passing Parameters

Video by: Steve

This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

How to Extract Information from the Oracle Data Dictionary Views

Video by: Steve

This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…