Database Administration (MOSC)

MOSC Banner

query database edition from data dictionary

edited May 1, 2009 9:00AM in Database Administration (MOSC) 4 commentsAnswered
 Hi,

I have inherited a whole bunch of databases from another org and am sorting out licensing, etc...

In 10g, I've found that I can query the Edition (Standard, Enterprize, etc) from the v$version tables, but this doesn't work for 8i & 9i databases.  Is there an easy way to determine this without logging onto each server (Log on to database is less complex due to userid/firewall etc).

Also, is there a way to query the 'all time' highwater mark?  Some of these DBs get cold backups so the numbers in v$license aren't very useful [ and I'm not looking forward to searching thru the alert logs :-) ]

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