Listar Arquivos Tablespace
select name from v$controlfileunion allselect name from v$tempfileunion allselect name from v$dbfileunion allselect member from v$logfile...
Banco de Dados (restaurando / restoring)
RESTORE DATABASE [database_name] WITH RECOVERY Referencia: https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/...
Android – Manter teclado virtual ao conectar leitor de código de barras
...
Android – Teclado com código de barras
App de teclado para Android com recurso de leitura de código de barras....
Mover tabelas e índices para outra tablespace
Índices select ‘alter index ‘|| owner ||’.’||segment_name||’ rebuild tablespace USERS;’from dba_segmentswhere 0=0and owner = ‘xxxx’and tablespace_name<>’USERS’and segment_type=’INDEX’; Tabelas select ‘alter table ‘||owner ||’.’||segment_name||’ move tablespace USERS;’from dba_segmentswhere owner=’xxxxx’and tablespace_name<>’USERS’and segment_type=’TABLE’;...
IMP/EXP
Backupexp user/pass@server file=’c:\folder\file.dmp’ owner=XXXX Restoreimp user/pass@server file=’c:\folder\file.dmp’ fromuser=XXXX touser=YYYY...
SQLServer liberar memoria/cache
DBCC DROPCLEANBUFFERSDBCC FREEPROCCACHE...
lock
SELECT session_id, wait_duration_ms, wait_type, blocking_session_id FROM sys.dm_os_waiting_tasks WHERE blocking_session_id <> 0...
trace
SELECT sqltext.TEXT,req.session_id,req.status,req.command,req.cpu_time,req.total_elapsed_time,start_time,right(convert(varchar,dateadd(ms, datediff(ms, start_time, getdate()), ‘1900-01-01’),121), 12) as ‘batch_duration1’,wait_timeFROM sys.dm_exec_requests reqCROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext...
criar usuário com privilégio de dba
CREATE USER usuario IDENTIFIED BY senha DEFAULT TABLESPACE USERS; GRANT CONNECT,RESOURCE TO usuario; GRANT DBA TO usuario WITH ADMIN OPTION; obs: no oracle 12 é necessário executar o comando abaixo antes de criar o usuário: alter session set “_ORACLE_SCRIPT”=true;...