Oracle Sql Tips
SELECT
to_char(sysdate,'DD/mm/YYYY') "FecQry",
owner "Esquema",
object_type "Tipo",
count(1)"Cantidad"
FROM dba_objects
WHERE status != 'VALID'
GROUP BY owner,object_type
;
SELECT
to_char(sysdate,'DD/mm/YYYY') "FecQry",
owner "Esquema",object_type "Tipo",
count(1) "Cantidad"
FROM dba_objects
WHERE status != 'VALID'
GROUP BY owner,object_type
;
SELECT
count(1)"Tot_Inv"
FROM dba_objects
WHERE status != 'VALID'
;
################################################################################################################
STARTUPINSTANCIA
========================
select to_char(sysdate,'dd/mm/yyyy') FecQry ,'Fecha_Startup'
,to_char(i.STARTUP_TIME,'dd/mm/yyyy hh24:mi:ss')
from v$instance i;
DIMENSIONES========================
SELECT
to_char(sysdate,'dd/mm/yyyy') FecQry
,to_char(sum(Numero_Archivos),'999G999') "Nro_Archivos"
,to_char(sum(Tamano),'999G999G999D99') "Tamano_Mb"
FROM (
SELECTcount(file_name) Numero_Archivos, sum(bytes)/1024/1024 Tamano FROM dba_data_files
UNION ALL
SELECT count(file#) Numero_Archivos, sum(bytes)/1024/1024 Tamano FROM v$tempfile
UNION all
SELECTcount(group#) Numero_Archivos, sum(bytes)/1024/1024 Tamano FROM v$log
);
select to_char(sysdate,'dd/mm/yyyy') FecQry
,'Fecha_Startup'
,to_char(i.STARTUP_TIME,'dd/mm/yyyy hh24:mi:ss')
fromv$instance i ;
show sga;
select
to_char(sysdate,'dd/mm/yyyy') FecQry
,(SELECT to_char(value,'999G999')FROM v$parameter WHERE name='processes' )"Nro_Max_Proc"
,(SELECTto_char(value/1024/1024,'999G999G999D99') FROM v$parameter WHERE name='pga_aggregate_target' )"PGA_Size"
,(SELECT to_char(value/1024/1024,'999G999G999D99') FROM v$parameter WHERE name='sga_max_size' )...
Regístrate para leer el documento completo.