Búsqueda
Puedes encontrar los resultados de tu búsqueda abajo. Si no has encontrado lo que buscabas, puedes crear una nueva página con tu consulta utilizando el botón Crea esta página.
Resultados
errores_oracle:rman:rman_00550-20506: 271 Entradas
the error.
==== RMAN-00552: syntax error in command line arguments ====
Cause: The arguments supplied... : Check that the filename was specified correctly and that the file exists and that the user running RM... : Check that the filename was specified correctly and that the file exists and that the user running RM
oracle_sql_scripts:bloqueos: 47 Entradas
S.v_$session b
WHERE a.session_id = b.SID
AND lock_id2 in (SELECT lock_id2 Lock_addr
FROM DBA_LOCK_INTERNAL
WHERE mode_requested<>'None'
AND mode_requested<>mode_held
AND session_id IN ( ... sys.v_$process p
where s.paddr = p.addr(+)
and l.sid = s.sid
and l.id1 = o.obj#(+)
a
oracle_sql_scripts:indexacion_monitor: 39 Entradas
blemente no se usan.
rem Como regla a seguir, cuando el indice no es bitmap, un indice es pobre
rem ... $ i,
sys.obj$ oi
where ot.owner# = u.user#
and i.bo# = ot.obj#
and nvl(t.rowcnt, 0) > 100
and i.bo# = t.obj#
and i.distkey < 7
and oi.obj# = i.obj#
and oi.owner# != 0
order by 1
/
spool
oracle_sql_scripts:scripts_utiles_para_dbas: 32 Entradas
ysstat b
Where a.name = ‘redo log space requests’ and
b.name = ‘redo entries’;
REM ********************... t p2,p3 from v$session_wait
where event=’enqueue’ and wait_time=0) sw
where id1=sw.p2 and id2=sw.p3;
R... ext from v$sqlarea q,v$session s
where s.sid=&sid
and s.sql_address=q.address
and s.sql_hash_value=q.ha
oracle_sql_scripts:indices_redundantes: 30 Entradas
rom DBA_IND_COLUMNS
Where COLUMN_POSITION=1
And TABLE_OWNER not in ('SYS','SYSTEM')
Group By ... user$ o2
Where
o1.name not in ('SYS','SYSTEM') and
o2.name not in ('SYS','SYSTEM') and
ic1.pos# = 1 and
ic2.bo# = ic1.bo# and
ic2.obj# != ic1.obj# and
ic2.pos# = 1 and
ic2.intcol# = ic1.in
oracle_sql_scripts:objetos_invalidos: 29 Entradas
owner in ('PUBLIC', d.owner)
and db_link = d.referenced_link_name)
and d.referenced_link_name is not null
and (d.owner, d.name, d.type) in (select owner, object_name, object_type... dba_dependencies d
where ro.status = 'INVALID'
and ro.owner = d.referenced_owner
and ro.object_nam
wiki:syntax: 29 Entradas
iki supports **bold**, //italic//, __underlined__ and ''monospaced'' texts. Of course you can **__//''c... iki supports **bold**, //italic//, __underlined__ and ''monospaced'' texts.
Of course you can **__//'... __** all these.
You can use <sub>subscript</sub> and <sup>superscript</sup>, too.
You can use <sub>
oracle_tuning:tuning_rac: 27 Entradas
Tuning:
-- a) Identificar si existen sesiones causando contención.
-- b) Identificar los objetos que ca... file_id = (Select FILE_NUMBER From GLOBAL_RAC)
AND (Select BLOCK_NUMBER From GLOBAL_RAC) between block_id AND block_id+blocks-1;
*/
Drop Table GLOBAL_RAC;
PROMPT
PROMPT Paso (c): Modificar los objetos
oracle_varios:iniciacion: 19 Entradas
o tipo (desde el punto de vista físico). Ahora cuando decimos “del mismo tipo” queremos decir que los ... una tabla se almacenan uno detrás de otro, respetando las longitudes de cada columna. Esto es una norm... s 50 caracteres, es base de datos se están almacenando los restantes con el carácter “•”
Si a la base
oracle_sql_scripts:almacenamiento:datafile:segmentos_no_extendibles: 17 Entradas
t
WHERE ( seg.segment_type = 'TABLE'
AND seg.segment_name = t.table_name
AND seg.owner = t.owner
AND NOT EXISTS (
SELECT tablespace_name
FROM ... espace_name = t.tablespace_name
AND BYTES >= t.next_extent)
)
UNION
SELECT seg
oracle_sql_scripts:rollback:rollbacks: 15 Entradas
g$ sg,
sys.ts$ ts
where ud.us# = s.usn (+)
and ud.file# = sg.file#
and ud.block# = sg.block#
and sg.ts# = ts.ts#
/
rem
rem ====================================================================... sed
-- in some 'ALTER SYSTEM KILL SESSION' command), the text of the
-- associated SQL query, how
backup:data_pump: 15 Entradas
res del proceso y de la cola, se pueden definir usando el parametro JOB_NAME.
Cancelando el proceso CLI... no para el Proceso de DATA PUMP Asociado.
Pulsando "ctrl+c" en el cliente lo que ocasiona es la par... devuelve el control al prompt.
</quote>
Tecleando el comando 'STATUS' en el prompt permite monitor
oracle_sql_scripts:esperas: 14 Entradas
====== Esperas ======
===== Waiters, Status And Parameters =====
<code sql>
PROMPT Waiters, Status And Parameters
PROMPT ==============================
Select w.Event,
s.sid,
s.status,
s.program,
w... ansaction t,v$session_wait w
Where s.taddr=t.addr and s.sid=w.sid;
</code>
===== Waiters Time = 0 ===
oracle_varios:histogramas: 13 Entradas
e "Peso - Balanceado", la columna es dividida en bandas, cada banda contiene
aproximadamente el mismo ...
Los histogramas de fecuencia pueden ser vistos usando las vistas *TAB_HISTOGRAMS.
==== VISTAS de CON... T COUNT(*) FROM servers WHERE srvr_id BETWEEN 522 AND 568;
SELECT COUNT(*) FROM servers WHERE srvr_id