Database Administration (MOSC)

MOSC Banner

DBA_DATA_FILES & UNDO Tablespace

edited Aug 4, 2021 11:29AM in Database Administration (MOSC) 4 commentsAnswered

Hello Team,


I am running the below query to see whether the change of UNDO Tablespace is reflected or not.


SELECT /*+ no_monitor */ :TS_NAME AS tablespace_name, COUNT(1) AS no_of_data_file, ROUND(SUM(A.Bytes)/(1024*1024*1024),2) AS current_data_file_size_gb

                       ,ROUND(SUM(a.maxbytes)/(1024*1024*1024),2) AS max_data_file_size_gb

 FROM dba_data_files a

WHERE a.tablespace_name = :TS_NAME

AND a.online_status = 'ONLINE'

AND a.status = 'AVAILABLE'

;


But I am getting the below result where total maxbytes are lower than total bytes.


And moreover from EM it is looking like below:

It will be great if you can help me to understand how could this happen.

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