miércoles, abril 22, 2009

Oracle: Productos instalados

column COMP_ID format a10
column COMP_NAME format a40
column VERSION format a15
column STATUS format a7
column NAMESPACE format a10
column CONTROL format a7
column PARENT_ID format a10
column OTHER_SCHEMAS format a50
select * from dba_registry;

martes, abril 21, 2009

Oracle: Relación PROCESSES - SESSIONS - TRANSACTIONS (10g):

SESSIONS = (1.1 * PROCESSES) + 5
TRANSACTIONS = 1.1 * SESSIONS