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
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
No one has followed this question yet.