오라클 버젼 및 sid 확인

select * from sys.v_$version  오라클 버젼 확인 쿼리

 

 

SQL> select * from sys.v_$version; BANNER -------------------------------------------------------------------------------- Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production CORE    10.2.0.1.0      Production TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production   SQL> SQL> SQL> col INSTANCE format a10 SQL> select instance from v$thread; INSTANCE ---------- xe   SQL> SQL> SQL> select name from v$database; NAME ------------------ XE   ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Solaris: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production