Skip to main content

Posts

DB - Instance caging

English Version Neste post partilho uma forma de identificar a utilização de CPU por utilizador (usuario como dizem no Brasil ) em ambientes Linux com múltiplas instâncias de base de dados Oracle.Estes comandos são útils para  configurar Database Instance Caging.
Post a Comment
Read more

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