Emergency Call + *983*987...
Monday, February 18, 2013
Thursday, February 7, 2013
Windows / FORFILES - [ To delete old archives ]
command : Forfiles
-p = PATH
-d = DAYS
-m = REGEX
-c = NEW COMMAND
C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl
"IdaDB_03122012.pl"
"IdaDB_Windows_SRV.pl"
"IdaDB_Windows_SRV_03122012.pl"
"tmp1.pl"
C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80...
Wednesday, February 6, 2013
ORACLE - [ spreport ]
1:
SQL> exec perfstat.statspack.snap
2:
SQL> exec perfstat.statspack.snap
3:
SQL> @$ORACLE_HOME/rdbms/admin/sprepor...
ORACLE - NLS_LANG
SQL> select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
'NLS_LANGUAGE', 'LANGUAGE',
'NLS_TERRITORY', 'TERRITORY') name,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');
NAME VALUE
------------- ----------------------------------------------------------------
LANGUAGE AMERICAN
TERRITORY...
Tuesday, February 5, 2013
Rman catalog - Time Retention
SQL> show parameter keep
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_keep string
control_file_record_keep_time ...
Oracle Rman Show Backups
select operation as "OPERACAO",
object_type as "TIPO",
status,
output_device_type as "MEDIA",
to_char(end_time,'DD-MM-RRRR HH24:MI:SS') as "DATA",
round(MBYTES_PROCESSED/1024,2) as "TAMANHO(MB)"
from
v$rman_status
where
operation = 'BACKUP'
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time
SQL> /
OPERACAO TIPO STATUS MEDIA ...
ORACLE / RMAN - Status
set pages 120
set lines 120
column MEDIA format a10
column STATUS format a10
column OPERACAO format a10
select operation as "OPERACAO",
object_type as "TIPO",
status,
output_device_type as "MEDIA",
to_char(end_time,'DD-MM-RRRR HH24:MI:SS') as "DATA",
round(MBYTES_PROCESSED/1024,2) as "TAMANHO(MB)"
from
v$rman_status
where
operation <> 'CATALOG'
and trunc(end_time)>=trunc(sysdate-1)
order...
Monday, February 4, 2013
Oracle - [ Alter Database Datafile ]
1* select file_id,file_name,bytes/1024/1024,maxbytes/1024/1024 from dba_data_files order by file_id
SQL> /
FILE_ID FILE_NAME BYTES/1024/1024 MAXBYTES/1024/1024
---------- ------------------------------ --------------- ------------------
1 +DSKDATA/oralee/datafile/syste 740 32767.9844
m.334.783430381
2 +DSKDATA/oralee/datafile/sysau...
