問題描述
有沒有辦法使用 SQL 獲取有關(guān)服務(wù)器的信息?它是一個使用 Windows 服務(wù)器的 Oracle 數(shù)據(jù)庫.我搜索了谷歌，我發(fā)現(xiàn)的只是 @@version 這不起作用.謝謝你的幫助.
Is there a way to get information about a server using SQL? It is an Oracle database using a windows server. I searched google and all I found was @@version which does not work. Thanks for your help.
推薦答案
這里有一個很好的主要信息檢索例程列表.確保這是獲取服務(wù)器信息的最佳方式:
Here is a good list of the main informations retrieve routines. Be sure this is the best way to obtain Server infos:
甲骨文
版本:PL/SQL、TNS 版本與 Oracle 一起使用.
Version: PL/SQL, TNS versions using with Oracle.
SELECT * FROM v$version;
-- Which version of oracle you are running.
SELECT * FROM v$version WHERE banner LIKE 'Oracle%';
-- Or, in more readable way.
SELECT * FROM product_component_version;
Instance:顯示當前實例的狀態(tài).
Instance: Displays the state of the current instance.
SELECT * FROM v$instance;
-- About license limits of the current instance.
SELECT * FROM v$license;
數(shù)據(jù)庫:數(shù)據(jù)庫名稱.
SELECT * FROM GLOBAL_NAME
--Db IP Address.
SELECT UTL_INADDR.get_host_address FROM dual
--Db Host Name.
SELECT UTL_INADDR.GET_HOST_NAME('above ip address') FROM dual
客戶端:客戶端 IP 地址.
Client: Client IP Address.
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') FROM dual
--Db Host Name
SELECT SYS_CONTEXT('USERENV','TERMINAL') FROM dual
--Db Host Name with domain.
SELECT SYS_CONTEXT('USERENV','HOST') FROM dual
--Current Client session details who using DB.
SELECT * FROM v$session WHERE username = 'User/Schema name'
--To which DB user connected to.
SELECT SUBSTR(GLOBAL_NAME, 1, INSTR(GLOBAL_NAME,'.')-1) FROM GLOBAL_NAME
SQL Server
版本:您正在運行的 Sql 服務(wù)器版本.
Version: Which versions of Sql sever you are running.
SELECT @@VERSION
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('edition')
-- SERVERPROPERTY Returns property information about the server instance.
客戶端:客戶端詳細信息(IP 地址、機器名稱、使用的實例).
Client: Client details (IP Address, Machine Name, Instance using).
SELECT con.client_net_address as IPAddress,
sess.host_name as MachineName, sess.program_name as ApplicationName,
login_name as LoginName
FROM sys.dm_exec_connections con
inner join sys.dm_exec_sessions sess
on con.session_ID=sess.session_ID
WHERE con.session_ID = @@SPID
有關(guān)詳細信息:http://msdn.microsoft.com/en-我們/圖書館/ms174396.aspx
這篇關(guān)于有沒有辦法使用 SQL 獲取有關(guān)服務(wù)器的信息的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！