-- Oracle 11gXEr2 Base Install Details
SELECT banner database_info FROM v$version;

SELECT 
  instance_number, instance_name, instance_role, host_name, version, parallel,  
  TO_CHAR(startup_time,'mm/dd/yyyy hh24:mi:ss') startup_time,  
  status, database_status, active_state, logins, shutdown_pending, archiver,
  blocked  
FROM gv$instance;  

SELECT CAST(DBMS_WARNING.get_warning_setting_string()
 AS VARCHAR2(30)) get_warning_setting_string
FROM DUAL;



-- Oracle 11gXEr2 Base Install Size
SELECT
 CAST(DECODE(GROUPING(segment_type), 0, segment_type,  
  'Total ('||To_Char(Sysdate,'mm/dd/yyyy hh24:mi:ss')||')') 
  AS  VARCHAR2(30))
 Segment_Type_Detail,  
COUNT(*) obj_count,  
ROUND(Sum(Bytes)/1024/1024/1024,4) Available_gb  
FROM dba_segments  
GROUP BY ROLLUP(segment_type);



-- Oracle 11gXEr2 Base Install Users
SELECT  DECODE(Grouping(username), 0, username,
 'Total ('||TO_CHAR(SYSDATE,'mm/dd/yyyy hh24:mi:ss')||')')
 user_details,
count(*) users
FROM  dba_users
GROUP BY ROLLUP(username);