v$instance.family ?

May 20, 2014 — Leave a comment

in oracle 12.1 there appeared a column in v$instance which is not documented: v$instance.family

oracle docs

another new column which appeared is: v$instance.edition (which is documented):

EDITION 	VARCHAR2(7) 	The edition of the database.
Possible values include:
    CORE EE
    CORE SE
    EE
    PO
    SE
    XE

I never heard of oracle editions CORE EE, CORE SE and PO. A look at the source of gv$instance lists even more but others are missing:

decode(ksuxsedition,  2, 'PO', 4, 'SE', 8, 'EE', 16, 'XE', 32, 'CS', 40, 'CE', 'UNKNOWN')

Perhaps Oracle Support can put some light on this :) seems to be somehow related to cloud installations, but this is just a guess …

No Comments

Be the first to start the conversation!

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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.