Change of Dynamic View Name

Thanks to Tim Hall for pointing out on his blog that going from database 11.1 to 11.2 Oracle have changed the Flash Recovery Area to Fast Recovery Area. This might please Neil Johnson, who has previously expressed a dislike for its “Sunday best” name here (end of post).

This got me thinking about V$FLASH_RECOVERY_AREA_USAGE, which I’ve previous wanted to create a synonym for as V$FRA_USAGE… Anyway, Oracle have renamed the view from V$FLASH_RECOVERY_AREA_USAGE to V$RECOVERY_AREA_USAGE, which is only going to save me typing 6 characters.

Now, I’m probably asking for too much, but can DBA_TAB_PRIVS be renamed to DBA_OBJ_PRIVS? The description of the TABLE_NAME column makes it clear the name doesn’t fit the usage, “Name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.”

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s