ODA +RECO SPACE_LIMIT odd results
Hi Community,
X3-2, 11.2.0.3.9 oracle home, ODA at 2.9 version.
Using the default config file for both, we set up (2) "SMALL" Class types of databases using oakcli on ODA.
The first is prod, second is dev.
When running the below query, we get odd results for RECO size area of each;
SELECT
NAME,
ROUND((SPACE_LIMIT / 1048576)/1024) SPACE_LIMIT_GB,
ROUND(SPACE_USED / 1048576/1024) SPACE_USED_GB,
ROUND(((SPACE_USED / 1048576) * 100) / (SPACE_LIMIT / 1048576), 2) PRC_USED
FROM V$RECOVERY_FILE_DEST;
prod
+RECO | 18 | .25 | 3.1 |
dev
+RECO | 1800 | 1 | 0.04 |
Why is the SPACE_LIMIT for the first one we created only "18GB" and the second is at "1800 GB" ?
Shouldn't they both be the same, ie "1800 GB" each for SPACE_LIMIT?