Can I find out host OS details by querying a system table?
asked
Can I find out host OS details by querying a system table?
You were not very clear what os details you are interested in.
The OS can be determined with one of the following queries: 1)
select dbms_utility.port_string from dual
2)
select rtrim(substr(replace(banner,'TNS for ',''),
1,
instr(replace(banner,'TNS for',''),':')-1)) os
from v$version
where banner like 'TNS for %'
The os statistics can be determined by querying the view V$osstat
Basic platform information is in v$database:
select platform_id, platform_name from v$database;
