Oracle OpenWorld   Latin America 2009 10 a 12 de março de 2009 - Transamérica Expo Center, São Paulo

Bem-vindo ao maior evento Oracle da América Latina. O maior encontro regional de clientes, parceiros e desenvolvedores da Oracle promete ser mais sensacional do que nunca em 2009. Nesta TERCEIRA edição, a conferência oferece oportunidades dinâmicas para aprender e interagir não só com especialistas do setor, como também profissionais de toda América Latina. Com sessões aprofundadas e networking durante a exposição, você conhecerá às últimas Tecnologias e Aplicativos Oracle, além de ouvir dos líderes do setor as previsões quanto ao futuro da tecnologia e dos negócios.

Operations on Oracle log files :

1. Forcing log file switches:
ALTER SYSTEM switch logfile;
or
ALTER SYSTEM checkpoint;
2. Clear A Log File If It Has Become Corrupt:
ALTER DATABASE CLEAR LOGFILE GROUP group_number;
3. This statement overcomes two situations where dropping redo logs is not possible: If there are only two log groups and if the corrupt redo log file belongs to the current group:
ALTER DATABASE CLEAR LOGFILE GROUP 4;
4. Clear A Log File If It Has Become Corrupt And Avoid Archiving:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP group_number;
5. Use this version of clearing a log file if the corrupt log file has not been archived:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
6. Privileges Related To Managing Log Files:
ALTER DATABASE
ALTER SYSTEM
7. Init File Parameters Related To Log Files:
log_checkpoint_timeout … set to 0
8. Managing Log File Members:
ALTER DATABASE
ADD LOGFILE MEMBER ‘log_member_path_and_name’
TO GROUP group_number;
9. Adding log file group members:
ALTER DATABASE
ADD LOGFILE MEMBER ‘/oracle/dbs/log2b.rdo’ TO GROUP 2;
10. Droping log file group members:
ALTER DATABASE
DROP LOGFILE MEMBER log_member_path_and_name’;
ALTER DATABASE
DROP LOGFILE MEMBER ‘/oracle/dbs/log3c.rdo’;
11. To create a new group of online redo log files, use the SQL statement ALTER DATABASE with the ADD LOGFILE clause:

The following statement adds a new group of redo Oracle log files to the database:

ALTER DATABASE ADD LOGFILE (’/oracle/dbs/log1c.rdo’, ‘/
oracle/dbs/log2c.rdo’) SIZE 500K;

–// Analisar Objetos Fragmentados no Banco de Dados (Performance)

SELECT SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, BYTES / 1024 / 1024 TAM, EXTENTS

FROM DBA_SEGMENTS

WHERE EXTENTS > 100 ORDER BY EXTENTS

Abraços.