Skip to main content

Posts

DB - Degree Of Parallelism

English Version Neste post escrevo sobre gestao manual do do DOP ( Degree of Parallelism). A gestao do paralelismo pode ser feita manualmente de 3 formas :  1 - Paralelismo ao nivel da Sessao  ALTER SESSION ENABLE | DISABLE | FORCE Parallel QUERY | DML | DDL  2 - Paralelismo ao nivel do Objecto create table my_tab(i number) parallel 5 ; alter table   my_tab p arallel 10 ; select table_name, degree   from dba_tables where table_name = 'INDX_P_5'; -- tabelas particionadas  -  -- aplica- se ano nivel da tabelas  nao das particoes  --  Table IOT  create table my_iot_tab( i parallel key ) organization index parallel; -- index create index indx_p_5 on Tabela (i) Parallel 5 ; alter index indx_p_5 Parallel 10 ; select index_name, degree   from dba_indexes where index_name = 'INDX_P_5'; 3 - Paralelismo Hints * tem precedencia sobre todos as outras opcoes (MANUAL ou AUTO) ...
Post a Comment
Read more

DB - Fast Recovery Area

Let's  distillate  a bit the Fast Recovery Area (FRA)   Central location for backup data Logs Archive logs Backups Control file Location (either) ASM filesystem Allow RMAN Retention policies Parameters ( location and size) DB_RECOVERY_FILE_DEST DB_RECOVERY_DEST_SIZE FRA - Maintenance other notes The maintenance is done automatically, and if is properly sized are not expected issues Use the RMAN commands to remove backups and file copies that are not required. If gets full - database stops RMAN> REPORT OBSOLETE  RMAN> DELETE OBSOLETE  Get Info SQL> show parameter DB_RECOVERY_FILE_DEST NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/flash_recovery_area db_recovery_file_dest_size big integer 3852M SQL> col name form a30 SQL> col value form a30 SQL> select name, v...
Post a Comment
Read more

WMS - Dest ID

English Version Em Oracle Retail os armazens ( e outras facilities ) tem um ID unico. Neste caso especifico WMS, o RIB vai mandar informacao especifica para esse armazem. Esse ID , tera que estar no RMS, ficheiro TAFRs , e no WMS. A query em baixo retorma essa informacao , na base de dados do WMS, esse ID. set lines 20 col description a30 col description form a30 set lines 200 select l.facility_id,description,dc_dest_id from transshipment_setup t, facility l where l.facility_id = t.facility_id; Obrigado pela leitura, espero que este post o tenha ajudado. Rogerio Referencias e Mais Info : https://docs.oracle.com/cd/E82085_01/1303/operations_guide/Chapter%207%20-%20Message%20and%20Routing%20(TAFR).htm https://docs.oracle.com/cd/E12456_01/rwms/pdf/141/html/impg/wms-integration.htm
Post a Comment
Read more