OraFAQ Forum: Server Administration » how to find out edition of oracle 10G instance ?

Home » RDBMS Server » Server Administration » how to find out edition of oracle 10G instance ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to find out edition of oracle 10G instance ? [message #325339]

Thu, 05 June 2008 17:44

jren
Messages: 13
Registered: May 2008

Junior Member

when i check:

select * from v$instance

it's only show me the version is 10.2.0.1.0, but how do i find out the edition ? Thx.

Report message to a moderator

Re: how to find out edition of oracle 10G instance ? [message #325341 is a reply to message #325339]

Thu, 05 June 2008 18:16

Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA

Senior Member

SCOTT@orcl_11g> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

SCOTT@orcl_11g>

Report message to a moderator