isitdevops.com/databases

–os_chk.sql
— mdw 99
— quick check of what server you are on. Wrote before V$instance available?
— NB Gives full OS info – no available from v$instance
set serveroutput on;
begin
declare
v_temp varchar2(255) := ‘hello world’;
begin
  v_temp := dbms_utility.port_string;
  dbms_output.put_line(v_temp);
end;
end;
/