query database edition from data dictionary
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 :-) ]