Ask TEM Dba

col owner format a15 col segment_name format a30 col segment_type format a15 col mb format 999,999,999 select owner , segment_name , segment_type , mb from ( select owner , segment_name , segment_type , bytes / 1024[...]

col "Database Size" format a20 col "Free space" format a20 col "Used space" format a20 select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ' GB' "Database Size" , round(sum(used.bytes) / 1024 / 1024 / 1024 ) - round([...]

select to_char(startup_time, 'HH24:MI DD-MON-YY') "Startup time" from v$instance / [...]

This will return 9000′ish if it is… select count(*) from all_objects where object_type like '%JAVA%' and owner = 'SYS' / [...]