O DATAPUMP é uma feature excelente que foi introduzida no oracle 10g, pois ela roda no lado servidor, se der algum problema em seu job podemos reinicializar do ponto de parada sem perder Gibabytes de trabalho entre outras. Uma funcionalidade que mais me chamou a atenção para essa feature foi o network_link, e eu vou[…]
Usando profiles para eliminar sessões que ficam inativas por um longo tempoconsumindo recursos do servidor Oracle. 1). Altere o parâmetro de inicialização RESOURCE_LIMIT para TRUE, vem default FALSE ALTER SYSTEM SET RESOURCE_LIMIT=TRUE SCOPE=BOTH; 2). Crie um profile com um nome desejado por você Create profile Meu_profile limit idle_time 1 — Tempo em Minutos (1 minuto);[…]
When your sysadmins change the TZ from your Oracle server to adjust daylight, follow the steps here to correct EM hour. By example, in Rio de Janeiro the normal time zone is equivalent to Etc/GMT+3. This solutions works for my production environment without patching anything. 1. Setting TZ environment variable TZ=Etc/GMT+3 export TZ 2 –[…]
This query is a complex query that was figure as one of top 5 on my AWR reports, the complexity of him is caused because is a Auto Join query (Hierarchical query) and the rows returned by query are a mix of columns from first resultset and second resultset. Even being a partitioned table[…]
When you asked to convert data by using Oracle built-in functions as trim, to_date, to_number and etc, to migrate data from some columns in a big table on your production system the better path to follow is a CTAS (Create table as select). On Friday one developer sent me an e-mail asking to use trim[…]
In yesterday I was asked about the possibility of Oracle Database generate a trace file of 122 Gb only cause this is work in archivelog mode. My answer was “not”, it is one process totally independent of other. Maybe this trace was generated by DBA monitoring some user session and forgot DBMS_MONITOR tracing for ever.[…]