從oracle v$version檢視中查詢os的資訊

msdnchina發表於2011-10-14


C:>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Oct 14 08:48:07 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

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

SQL>

這一點比較適用於那些進入cde介面後,看不出來作業系統資訊的,直接查oracle得知。其實eygle在他的帖子中也記錄了此資訊

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1055667/,如需轉載,請註明出處,否則將追究法律責任。

相關文章