Database Administration (MOSC)

MOSC Banner

Undo

edited Apr 13, 2015 10:00AM in Database Administration (MOSC) 3 commentsAnswered

How to interpret below output?

SQL> SELECT (UR * (UPS * DBS)) + (DBS * 24) AS "Bytes"

  2  FROM (SELECT value AS UR FROM v$parameter WHERE name = 'undo_retention'),

  3  (SELECT (SUM(undoblks)/SUM(((end_time - begin_time)*86400))) AS UPS FROM v$undostat),

  4  (select block_size as DBS from dba_tablespaces where tablespace_name=

  5  (select value from v$parameter where name = 'undo_tablespace'));

     Bytes

----------

1.4996E+11

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center