Determine Platform Information from SQL*PlusThis is a featured page


set lines110 page500
col platform_id format 999 hea 'OSID'
col platform_name format a20 hea 'OS_NAME'
col db_unique_name format a8 hea 'DB_NAME'
col host_name format a25 hea 'HOSTNAME'

select platform_id, platform_name, db_unique_name, host_name,
database_role DB_ROLE, database_status DB_STATUS
from v$database, v$instance;

OSID OS_NAME ............ DB_NAME. HOSTNAME ................ DB_ROLE .........DB_STATUS
---- -------------------- -------- ------------------------- ---------------- -----------------
10 ..Linux IA (32-bit) ...orcl ... olapdba-pc.us.oracle.com. PRIMARY ........ ACTIVE

--------------------------------

col info format a60 heading "Operating Environment"

select to_char(dbms_utility.port_string) info from dual;

Operating Environment
------------------------------------------------------------
Linuxi386/Linux-2.0.34-8.1.0

--------------------------------

select 'Platform: '||to_char(dbms_utility.port_string) info from dual union
select 'Endianness: '||to_char(dbms_utility.get_endianness) info from dual union
select 'Instance: '||to_char(dbms_utility.current_instance) info from dual;

Operating Environment
------------------------------------------------------------
Endianness: 2
Instance: 1
Platform: Linuxi386/Linux-2.0.34-8.1.0


olapdba
olapdba 		Latest page update: made by olapdba , Jan 23 2008, 12:08 PM EST (about this update About This Update olapdba Edited by olapdba

2 words added
1 word deleted

view changes
- complete history)
Keyword tags: None
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.