COL resource_name for a30
COL limit_value for a20
SELECT 
  resource_name, 
  current_utilization, 
  max_utilization, 
  limit_value
FROM 
  v$resource_limit
WHERE 
  resource_name IN ( 'sessions', 'processes');

hostgator