-----Original Message-----
>From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]
>
>The v$instance table has the following two entries in
>Oracle7.
>STARTUP TIME - Julian 2452043
>STARTUP TIME - SECONDS 9476
>Doing the obligitory RTFM, I find all it
>says is that STARTUP TIME - Julian is the
>startup date and time in Julian format.
>(Thanks oracle, that's big help.)
>What is the Julian calender? How do you translate this
>number?
For translating number: look at the second query below.
column db_name format a10
column instance_name format a10
column global_name format a20
column host_os format a16
column version format a10
column current_time format a30
select
a.name as db_name,
rtrim (b.instance, chr (0)) as instance_name,
c.global_name as global_name,
substr (d.banner, 9, instr (d.banner, ':', 9) - 9) as host_os,
e.value as version,
to_char (sysdate, 'DAY, YYYY/MM/DD HH24:MI:SS') as current_time
from
v$database a, v$thread b, global_name c,
v$version d, v$parameter e
where
d.banner (+) like 'TNS for %'
and e.name (+) = 'compatible' ;
column host_name format a10
column logins format a10
column startup_time format a30
select
b.machine as host_name,
decode (c.value, 0, 'ALLOWED', 'RESTRICTED') as logins,
to_char (to_date (d.value, 'J'), 'DAY, YYYY/MM/DD')
|| to_char (to_date (e.value, 'SSSSS'), ' HH24:MI:SS') as startup_time
from
v$bgprocess a, v$session b,
v$instance c, v$instance d, v$instance e
where
a.paddr = b.paddr
and a.name like 'SMON%'
and c.key = 'RESTRICTED MODE'
and d.key = 'STARTUP TIME - JULIAN'
and e.key = 'STARTUP TIME - SECONDS' ;
Jacques R. Kilcho�r
x8816
