Hi,
On
12 C on Oracle Linux:
As document says:
BLOCK_SIZE NUMBER NOT NULL Tablespace block size (in bytes)
MAX_SIZE NUMBER Default maximum size of segments (in Oracle blocks)
My query is:
select block_size,tablespace_name, max_size,(max_size*block_size)/(1024*1024*1024) from dba_tablespaces where tablespace_name like 'UND%';
Then UNDO max size is 16384 GB ?????
But in TOAD I see: Undo max size 7,81 GB
Why such a difference ?Is my query (division by 1024) wrong ?
Which one is correct? What is the real size of UNDO ?
Thank you.