Ameer Khan

— Number of users and CPU/Processors
SQL> select L.SESSIONS_MAX, L.SESSIONS_WARNING, L.SESSIONS_CURRENT,
  2  L.SESSIONS_HIGHWATER,
  3  L.USERS_MAX, L.CPU_COUNT_CURRENT, L.CPU_SOCKET_COUNT_CURRENT,
  4  L.CPU_COUNT_HIGHWATER,
  5  L.CPU_CORE_COUNT_CURRENT, L.CPU_CORE_COUNT_HIGHWATER,
  6  L.CPU_SOCKET_COUNT_HIGHWATER
  7  from v$license l;
SQL> set linesize 300
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER  USERS_MAX CPU_COUNT_CURRENT CPU_SOCKET_COUNT_CURRENT CPU_COUNT_HIGHWATER CPU_CORE_COUNT_CURRENT CPU_CORE_COUNT_HIGHWATER CPU_SOCKET_COUNT_HIGHWATER
———— —————- —————- —————— ———- —————– ———————— ——————- ———————- ———————— ————————–
           0                0                3                 12          0                 1                                            1

— Database Edition
SQL> select banner from v$version where BANNER like ‘%Edition%’;   
BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production

— Oracle Partitioning installed
SQL> select decode(count(*), 0, ‘No’, ‘Yes’)
  2  from dba_part_tables
  3  where owner not in (‘SYSMAN’, ‘SH’, ‘SYS’, ‘SYSTEM’) and rownum = 1;

DEC
—
No

— Oracle Spatial installed:
select decode(count(*), 0, ‘No’, ‘Yes’)
from all_sdo_geom_metadata where rownum = 1;

DEC
—
No

— Oracle RAC installed:
SQL> select decode(count(*), 0, ‘No’, ‘Yes’)
  2  from v$active_instances where rownum <= 2;

DEC
—
No