Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

ODA +RECO SPACE_LIMIT odd results

edited May 21, 2014 12:00PM in Oracle Database Appliance (ODA) (MOSC) 1 commentAnswered


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

+RECO18.253.1


dev

+RECO180010.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? 

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