LINKS ÚTEIS

ORACLE ARCHIVE LOG

Oracle Archive Log Mode
Varios tutoriais

ORACLE ASH

5 Automatic Performance Statistics
cr request retry
GC Buffer Busy Waits in RAC Finding Hot Blocks Ardent Performance Computing
oracle aveactn.sql – Embarcadero DB Optimizer
Oracle wait classes
oradebug setmypid – Google Search
OS & Oracle » How to Interpret the Active Session History and Draw Histogram Using OMonitor
OTN Discussion Forums ‘global cahce cr request’ problem…
Signature Analysis of Wait Events

ORACLE ASM

10g RAC administration
11gR2 Database Installation with ASM on OEL5 AskDba.org Weblog
11gR2 Database Installation with ASM on OEL5 AskDba.org Weblog
Varios tutoriais
A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
Administering ASM Disk Groups
Administering ASM Instances with SRVCTL in RAC – Using Enterprise Manager (EM)
AskDba.org Weblog ORA-15063 – ASM Discovered Insufficient amount of Disks
asm Commanding ASM
ASM FAQ – ASM CREATES
ASM Metadata
ASM Support Guy ™ kfed – ASM metadata editor
ASM
ASSM, freelists and PCTFREE
Blog do Flavio Soares » oracle asm
convertendo para ASM
cvyqdisk
developerWorks AIX and UNIX AIX Forum reserve lock issue in dual vio servers
EMC-Powerpath commands on AIX for Oracle DBAs As goes Oracle
Get Upgrading Steps To Upgrade To 11gR2 AskDba.org Weblog
Get Upgrading Steps To Upgrade To 11gR2 AskDba.org Weblog
http–oracledbasupport.co.uk-how-to-safely-remove-a-data-guard-broker-configuration-under-racnon-rac-setup-2-
IBM Cluster information center
Instalação do software de banco de dados Oracle 11g R2 e criação de um banco de dados com ASM « Simple Write-Up
Kernel Files Editor (KFED )and KFOD ( OSM Discovery utility ) « Miladin Modrakovic’s Blog Oraclue
Managing ASM Disk Groups
ora-15042 ASM disk “N” is missing « Anand’s Blog
ORA-15063 – ASM Discovered Insufficient amount of Disks – AskDba.org Weblog  AskDba.org Weblog
Oracle 10g Automatic Storage Management (ASM), Part 2 Sample Implementation
Oracle 11g ASM install on Solaris 10 with RAW data files « Prune’s Blog
Oracle Applications DBA Blog Converting Oracle Applications to RAC with ASM
Oracle DBA Queries – Automatic Storage Management (ASM)
ORACLE-BASE – ASM using ASMLib and Raw Devices
ORACLE-BASE – Automatic Storage Management (ASM) in Oracle Database 10g
RaleighDBA.com
Realizando o upgrade de uma base de dados 10g para o Oracle 11g Release 2 …Oracle Blog
Surachart Opun’s Blog kfed… 11g tool
VMware Info How To Create a MetaLUN on an EMC Clariion CX4

ORACLE AUDITORIA

11 C onfiguring and Administering Auditing

A quick tutorial with examples on Audit Trail in Oracle 10g Release 2
Auditing Database Use
Auditing Oracle Database « Tamim DBA’s Blog
AUDIT_TRAIL « Tamim DBA’s Blog
Baixar Proactive Password Auditor 2.01- Proactive Password Auditor e uma senha garantia teste… – BAIXAJÁ
Banco de dados Oracle – Segurança e Escalabilidade Blog do LoFrano
Blog do DBA Valentim Habilitar auditoria em falha de logins – Oracle Database 10g e 11g
Blog do Marcio Portes May 2005
Configuring and Administering Auditing
D-Blog Descobrindo os dados e comandos enviados ao Oracle
Dicas de linux – Processo de auditoria em Unix AIX
Enable Listener Logging and Tracing
Fazendo auditoria sem inflar a tbs system
Google Tradutor
http–webgeek-tutorials.blogspot.com-2011-03-auditing-in-oracle-10g-release-2.html
linux AUDIT Auditoria de arquivos no Linux para conhecer quem fez alterações em arquivos [Artigo]
linux Auditoria de computadores com OPEN-AUDIT [Artigo]
Morgan’s Library Oracle Auditing Audit Examples Sample Code
Oracle 10g new features – Oracle10g
Oracle audit logon trigger – auditing user activity
Oracle Auditing for Risk Management and Regulatory Compliance
Oracle Database Docs UTILIZANDO LOGMINER PARA AUDITAR ALTERAÇÕES NA BASE DE DADOS
Oracle Flashback
Oracle in World About Audit_trail Parameter
ORACLE-BASE – Auditing in Oracle 10g Release 2
OraFAQ Forum Security » How to set Destination file for AUDIT_TRAIL=OS
OTIMO DOCUMENTO SOBRE SOBRE solucaoes de AUDITORIA
Processo de auditoria em AIX Sotware Livre, Linux e UNIX
Segurança em dados Oracle10g SQLNET – DRWiki
Tracking & auditing changes to your init.ora parameters
Vida de DBA Habilitando a Auditoria no Oracle 10g

ORACLE AWR

5 Automatic Performance Statistics
A Tour of the AWR Tables
ASH Views – Oracle Database
Automatic Performance Statistics
Bind variable – Oracle FAQ
DBAsupport.com Oracle 10g Central Oracle 10g A Self Managed Database
Diagnosing Locking Problems using ASH – Part 2 – Doug’s Oracle Blog
GC – automatic performance statistic – astinux
Varios tutoriais
http–oracledbasupport.co.uk-how-to-safely-remove-a-data-guard-broker-configuration-under-racnon-rac-setup-2-
iSelfSchooling – Oracle DBA_ tables
July « 2009 « Oracle DBA – Tips and Techniques
Oracle AWR Automatic Workload Repository Grid DBMS_WORKLOAD_REPOSITORY
Oracle AWR Retention period
Oracle Performance Tuning – How to Use AWR
ORACLE-BASE – Automatic Workload Repository (AWR) in Oracle Database 10g
ORACLE-BASE – Oracle Database 10g Performance Tuning Enhancements
OraFAQ Forum Server Administration » V$ACTIVE_SESSION_HISTORY not populating
OraFAQ Forum Suggestions & Feedback » OraFAQ Forum Guide
PROVA -ENTREVISTA_DBA
v$active_session_history

ORACLE BI

Connect to the Database from Oracle BI 11g « Oracle BI By Bakboord
Creating Dimensions and Cubes
http–www.oracle.com-technetwork-database-enterprise-edition-downloads-developing-awm-plugins-133398.pdf
initrans, ITL waits freelists and freelists groups
NinGoo’s Notes Database & Datawarehouse Materialized View Refresh Log Population and Purge
Oracle Business Intelligence OBIEE 101 OBIEE Date, TimeStamp and ORACLE Indexes
Oracle OLAP
Time Dimension with Surrogate Key
Using Oracle OLAP With Oracle BI Enterprise Edition 10g Rel 3

ORACLE BIND VARIABLE

Chen Guang’s Blog bind variable

ORACLE BULK COLLECT

10G Bulk Collect and FORALL, Improves your performance Articles – Content
Oracle Bulk Collection FORALL Bind

ORACLE COMPRESS

Find cause of Oracle Buffer Busy Waits
Sachin Arora’s Blog Oracle table compression
Table and Index Compression in Oracle – dbapool.com

ORACLE CONSTRAINTS

ALTER TABLE – Examples – OraDBPedia
Ask The Real Tom » Enable and Validate Constraints in Parallel (Oracle)
constraint
constraints How to resolve the duplicated primary key exceptions (Oracle Database Lets explore it)
Exception – Oracle FAQ
Insert many millions of lines coming from text files [Archive] – DBAsupport.com Forums
ORACLE – DBA Tips Corner
Oracle Constraints Primary Key Foreign Unique Check Referential Integrity
Oracle Sessions
Primary Key constraint has a mind of its own…!! [Archive] – DBAsupport.com Forums
re possible to use an exceptions table in parallel – oracle-l – FreeLists

ORACLE CONVERT DATABASE

Convert databases to different platforms using RMAN
Convert Datafiles using RMAN – Tablespace Conversion
CONVERT
Dien Dan CSDL ORAVN – Transportable tablespace
How Convert full Database 10g Linux-x86-64bit to AIX-64bit different Endian Format « Levi Pereira
http–www.oracle.com-technology-deploy-availability-pdf-TheHartfordProfile_XTTS.pdf
https–support.oracle.com-CSP-main-articlecmd=show&type=NOT&doctype=BULLETIN&id=243304.1
Oracle DBA Tips Tip#13 Big Vs Little Endian
ORACLE-BASE – RMAN Enhancements in Oracle Database 10g
OTN Discussion Forums how to convert a 32-bit database linux
RMAN Cross-Platform Transportable Databases and Tablespaces
Using RMAN CONVERT to Copy Files Between ASM and Non-ASM Storage

ORACLE DATA HORA

Date – Time Arithmetic with Oracle
Funções e operadores para data e hora
How does one get the time difference between two date columns Oracle FAQ
Introdução ao tipo de dado TIMESTAMP e suas variações …Oracle Blog
Oracle-PLSQL Date Functions
Oracle-PLSQL To_Date Function

ORACLE DATAGUARD

Varios tutoriais
1 O racle Data Guard Broker Concepts
10 Data Guard Scenarios
10g RAC – Physical Standby (Dataguard) Setup As goes Oracle
ALTER DATABASE
Become Oracle Apps DBA Oracle Dataguard in Apps 11i E-Business Suite as Disaster Recovery
Blog da Lilian Barroso » Scripts
Blog do Marcio Portes Broker, Dataguard e Real-Time Apply – 10g
Contents
Creating a Logical Standby Database
Creating a Managed Standby with RMAN
Creating a Standby Database with Recovery Manager
Data Guard Broker Improvements
Data Guard cenarios de recuperação e desastre
Data Guard Creating a Physical Standby Database
Data Guard implementation for Oracle 10gR2 – Oracle FAQ
Data Guard na versão 10g Release 2 (10.2) – Parte 01 – Renato Osterne – Oracle
Data Guard na versão 10g Release 2 (10.2) – Parte II – Renato Osterne – Banco de Dados
Data Guard Redo Apply and Media Recovery (??ID387343.1) – vecentli????? – ITPUB???? – powered by X-Space
Data Guard Redo Apply and Media Recovery Best Practices 10g « H.Tonguç Y?lmaz – Oracle Blog
Data Guard Scenarios
Data Type and DDL Support on a Logical Standby Database
Dataguard broker setup and Standby Redo Logs – Yann Neuhaus Blog
Dataguard creation in 10g using RMAN Borndba
Dataguard e Real-Time Apply – 10g
DBMS_LOGSTDBY
docu Creating A DataGuard Broker Configuration Using DGMGRL
failover manual melhor solução para SPC
Fast Start Failover In oracle 10gr2 Dataguard
General Improvements with Oracle 10g Data Guard
Getting Started with Data Guard
helpRac And Single Instance Standby Database TheDailyReviewer
How to Upgrade to Oracle Grid Infrastructure 11g Release 2
http–oracledbasupport.co.uk-dgmgrl-ora-16789-standby-redo-logs-not-configuredora-16826-apply-service-state-is-inconsistent-with-the-delaymins-property-
http–oracledbasupport.co.uk-how-to-safely-remove-a-data-guard-broker-configuration-under-racnon-rac-setup-2-
https–support.oracle.com-CSP-ui-flash.html
Ilmar Kerm DB blog Refreshing test database from production using incremental backups
Khurram Siddiqui Log switch trigger for recovery at standby database
Logical Standby 10gR2 – Open Issues « Oracle High Availability
Logical vs Physical Standby database Oracle FAQ
MAA WP 10gR2 Data Guard Network Best Practices
Managing a Logical Standby Database
Managing a Physical Standby Database
Montar Dataguard – 10g
Optimize Oracle Network Tips
ORA-00328 archived log ends at change 29604569404, need later change 29605086441 « Oracle DBA Stuff
ORA-16069 You May Need A New Standby Controlfile The Pythian Blog
Oracle – COMO MONTAR DATAGUARDA — ÓTIMO
ORACLE – DBA daguardbroker
ORACLE – DBA gaps
Oracle – Tricks of the Trade How to Create a Logical Standby (10g Release 2)
Oracle 10g – Manually Create a Physical Standby Database Using Data Guard Oracle FAQ
Oracle 10g Data Guard – Quick Switchover with Physical Standby Database Oracle FAQ
Oracle Data Guard DataGuard High Availability Failover TAF
Oracle Data Guard DataGuard passo a passo -muito bom
Oracle Data Guard Installation
Oracle DBA Queries – Dataguard-Standby databases; startup,shutdown,status,etc
Oracle DBMS_LOGSTDBY Logical Standby Data Guard
OraFAQ Forum Data Guard » failover steps when primary DB server problem occurs
OTN Discussion Forums Data Guard Replication Failed
OTN Discussion Forums disable dataguard configuration
OTN Discussion Forums Oracle Dataguard WAIT_FOR_GAP error
OTN Discussion Forums WARNING inbound connection timed out
PASSO A PASSO Data Guard(Data Guard Physical Standby Switchover )
Peformance Tuning « Liang’s Blog
prereqs Criar banco standby
re Oracle 10g Data Guard
RELATORIO
RMAN DUPLICATE DATABASE – Oracle DBA Forums
SQL Statements
Switochover e Role Transitions
The Arup Nanda Blog Resolving Gaps in Data Guard Apply Using Incremental RMAN BAckup
Troubleshooting Data Guard
Visão Geral Sobre o Oracle Data Guard « 4DBA
What’s New in Oracle Data Guard Broker
» Data Guard Broker Setup Oracle Database Experts Maintained by Charles Kim

ORACLE DATAPUMP

como resolver problemas de switchover e outros
Data Pump – Parte 02 – Vanberto Zuim – Oracle
Datapump – Oracle FAQ
DBMS_DATAPUMP
EXPDP DATAPUMP EXCLUDE-INCLUDE parameters
http–oracledbasupport.co.uk-how-to-safely-remove-a-data-guard-broker-configuration-under-racnon-rac-setup-2-
Optimize Oracle import (data pump impdp) performance
Oracle Data Pump – Part II Oracle FAQ
Oracle Data Pump
Oracle DBMS_DATAPUMP DATA PUMP DATAPUMP IMPORT EXPORT LOAD
Oracle DBMS_OUTPUT
ORACLE-BASE – Oracle Database 10g Data Pump
Priming the Oracle Data Pump
Resumable Import Sessions
Week 4 Oracle Database 10g Top 20 Features for DBAs

ORACLE DOCS E TUTORIAIS

Varios tutoriais
3 Monitoring Performance
Archive vs noarchive log mode
Blog do Marcio Portes May 2005
Blog do Rodrigo Almeida » Blog Archive » Entendendo a Marca d’água e fragmentação de tabelas
Criando conexão com banco de dados (passo-a-passo) MX Masters – Conhecimento a um clique
Designer Documentation
documentação completa oracle
Getting Started – Oracle Application Server Documentation
How ORACLE Uses Memory on AIX. Part 1 Processes « Intermediate SQL
How To Install,start,test and stop OC4J server
HowTo – OraWiki
http–www.java2s.com-Tutorial-Oracle-0100__Sequences-Whenyouselectcurrvalnextvalremainsunchangednextvalonlychangeswhenyouselectnextvaltogetthenextvalue.htm
INFO Online – Fórum – Acentos e ç no Oracle 10g
MATRIX – Linux and Oracle
OCP related doubts
ora-01031 insufficient privilege error – DBAsupport.com Forums
Oracle 10g O Manual do DBA – Google Books
Oracle 10g Tutorials Tables
Oracle Access Manager – Pax Tecnologia Knowledgebase
Oracle Blog Removendo registros duplicados de uma tabela usando o ROWID
Oracle Database Online Documentation 10g Release 2 (10.2)
Oracle DBA FAQ – Creating New Database Instance Manually
ORACLE Interview Questions and Answers
Oracle wait events, Oracle Database Administration, SQL, Application, Programming Tips
oracle « Guenadi N Jilevski’s Oracle BLOG
Oracle’s Freelists and freelist groups, oracle
prereqs para instalar oracle no linux
Previsão da tabela Oracle Crescimento
Qual é mesmo o tamanho de uma tabela no OracleOracle Blog
res [oracle_br] Alteração do parâ metro NLS_CHARACTERSET
Scripts EveryDay Practical Solutions for an Oracle-SQL Server DBA
Search and Download Oracle Database, Application Server, and Collaboration Suite Documentation
Student Academic blog – maximum number of columns included in Primary Key Index-Constraint
varios exemplos
What’s New in Oracle Database Administrator’s Guide
XMLType Operations

ORACLE FLASHBACK

Varios tutoriais
Data Guard Scenarios
Oracle 10g Flash Back Features
Oracle 10g New Features Flashback and RMAN Oracle FAQ
oracle 10g new features flashback database flashback features
Oracle 11g Snapshot Standby Database for Oracle 10g
Oracle Flashback
Oracle in World How to Enable Flashback Database
Using Oracle Flashback Technology

ORACLE GOLDENGATE

GoldenGate Tutorial 1 – Concepts and Architecture « Oracle DBA – Tips and Techniques
Oracle GoldenGate 11g Dados em Tempo Real Faitec
Oracle GoldenGate Tutorials now available ….. « Oracle DBA – Tips and Techniques

ORACLE GRID AGENTS

How to Point an Agent to a different Grid Control OMS and Repository « dbamac

ORACLE GRID OEM

1 Introduction to Enterprise Manager Advanced Configuration
Add-Configure a newly created ASM Instance into Enterprise Manager
DBAzine.com – Oracle 10G OEM Grid Control Tips, Tricks and Techniques
Enterprise Manager Configuration Assistant (EMCA)
Grid Control Common Configurations
Grid Control « John’s Oracle Experiences
GRID
How To Install Grid Control OMS 10.2.0.4 Using an Existing Database – Oracle Database
Introduction to Enterprise Manager Advanced Configuration
Maintaining and Troubleshooting the Management Repository
Manually configure the Oracle 10g EM dbconsole
Oracle Day to Day blog Unsecuring dbconsole(10gR2)
Oracle Enterprise Manager Desktop Widgets
Oracle in World An Stack of Problems while creating Repository using emca
ORACLE-BASE – Oracle 10g Release 2 Grid Control Installation On Red Hat Enterprise Linux and CentOS
OraFAQ Forum Enterprise Manager » OMS Admistrator password
Os Dedés – Os Dedes Apresentam Os Manos na Internet
OTN Discussion Forums How to change the password of SYSMAN
OTN Discussion Forums How to check agent name.
OTN Discussion Forums Time Zone Problem in Linux RedHat
RELATÓRIO
Starting and Stopping Enterprise Manager Components

ORACLE HINTS

HINTS ORACLE 10G
Optimizer Hints
Oracle Hints SQL PL-SQL
Oracle SQL hints
Oracle SQL undocumented tuning hints

ORACLE INDEXES

Index of -dpsoundz
Index-organized table – Oracle FAQ
IOT
Oracle Business Intelligence OBIEE 101 OBIEE Date, TimeStamp and ORACLE Indexes
Oracle Index Organized Tables (IOTs), Oracle Database Administration, SQL, Application, Programming Tips
Reverse Engineering a Data Model using the Oracle Data Dictionary
The Secrets of Oracle Bitmap Indexes
Unique Bitmap Indexes Part II (You Can’t Do That) « Richard Foote’s Oracle Blog

ORACLE JAVA

10g RAC administration
A DBMS_JAVA Package
http–www.idevelopment.info-data-Programming-java-jdbc-High_Availability-FastConnectionFailoverExampleThin.java
Introducing JDBC
Morgan’s Library Oracle DBMS_JAVA Demo Examples Source Code Sample Code Tutorial SQL PL-SQL
PreciseJava.com – Best practices to improve performance in JDBC

ORACLE JOBS

DBMS_JOB
Francês para Todos – Aprendendo Francês Online e de forma Gratuita
My Oracle Support Knowledge Browser 783357.1
ORACLE – DBA Tips Corner
oracle 10g dbms_scheduler explained
Oracle Day to Day blog ORA-12012
Oracle DBMS_JOB
Oracle DBMS_SCHEDULER Job Scheduling
Oracle Ebs Jobs Indeed.com

ORACLE KILL

Oracle Kill Session -9 Alter Session System UNIX Windows

ORACLE LISTENERS

Oracle DBA and RAC DBA Expert Overview of Transparent application Failover (TAF) in Oracle
OraFAQ Forum Performance Tuning » ORA-12520 TNSlistener could not find available handler for requested type of server
RAC listener TNS-12520 error – Oracle DBA Forums
tns-12520 TNSlistener could not find available handler for requested type of server
TNSNAMES and Listener.ora

ORACLE LOADER

exception handling in sql loader oracle, 10.2
Oracle SQLLoader Loader
Oracle SQLLoader The Definitive Guide Chapter 1 Introduction to SQLLoader
sqlldr direct

ORACLE LOCKS

enqueue_resource parameter in 10gR2
Locks DML
Oracle 10.1 Lock Types
Oracle Locks
Oracle Wait-Time Tips Locking and Enqueue
PL-SQL Lock Timer « Tamim DBA’s Blog
Wait Event Enhancements in Oracle 10g

ORACLE LOGMINER

My Oracle EBS Dba Blog Using logminer
Oracle DBMS_LOGMNR Log Miner Archive Archivelog
Oracle LogMiner
Using LogMiner to Analyze Redo Log Files
Using Oracle Log Miner Utility

ORACLE MATERIALIALIZED VIEWS

DBMS_MVIEW
Materialized View Fast Refreshes are Slow Oracle FAQ
Materialized Views Join Queries
Oracle 10g Materialized View Enhancements, Part 1 — DatabaseJournal.com
Oracle DBMS_MVIEW Materialized View
Oracle Materialized Views Fast Refresh Complete Log
Views Materializadas – Rodrigo Almeida – Oracle

ORACLE MIGRAÇAO 10g para 11g

Varios tutoriais
Upgrade and Migrate on Multi Terabyte Mission Critical RAC with Nea…
Upgrade Oracle 10g to Oracle 11gR2

ORACLE MISCELANIA

10g RAC administration
alter database in Oracle
Alter system in Oracle
alterar global name
CASE WHEN [Oracle SQL]
Changing the Current Schema « Coskan’s Approach to Oracle
Chen Guang’s Blog bind variable
CREATE SPFILE
create table [Oracle SQL]
Data Masking and Data Obfuscation for Sensitive Data Records
dba_dependencies
dba_hist_sqlstat
Documents Tagged with oracle Scribd
Error on UTL_FILE
Execute Immediate
External Tables Concepts
Fixing Corrupt System Managed Undo Segments
GRANTS
http–psoug.org-reference-tables.html
https–support.oracle.com-CSP-main-articlecmd=show&type=NOT&doctype=HOWTO&id=730365.1
Installing and Upgrading Oracle interMedia
Interpreting Explain plan
Mais_dba_dependencies
Monitoring Oracle Table Usage
Novidades do Oracle 10g – Shrink segmentos em objetos
ORACLE – DBA Tips Corner
Oracle – Tricks of the Trade
Oracle Archive Log Mode
Oracle Articles for experts only
Oracle Date and Time data types – um knol por Pradeep Nair
Oracle Exception Handing WHEN OTHERS SQLCODE SQLERRM PRAGMA INIT
Oracle Internals
Oracle NLS Character Sets Changing
Oracle Processes
Oracle SQL Create Profile
Oracle SYS_CONTEXT Function
Oracle Timestamp Data Type
Oracle VM Templates for Oracle RAC 11g Release 2
Oracle’s alert.log
Oracle-PLSQL Date Functions
Reorganizando o Tablespace …Oracle Blog
res [oracle_br] UTL_SMTP em Servidor com aute nticação
SAVEPOINT » Alterando Tablespaces de tabelas e índices no Oracle
sql plan enhancements in 10g
SQL to compare two date ranges
Undocumented OVERLAPS Function, Don’t Use it Yet Oracle FAQ
Use EXECUTE IMMEDIATE to call procedure and save the returning value Execute Immediate « PL SQL « Oracle PL – SQL
utl_smtp
What is the Meaning of the %CPU Column in an Explain Plan « Charles Hooper’s Oracle Notes

ORACLE ONS

Varios tutoriais
10g RAC administration
8 Fast Connection Failover
Diagnosing a Connection Pool
Oracle DBA and RAC DBA Expert Overview of Transparent application Failover (TAF) in Oracle
oracle thin driver connection url string with RAC Xinotes
Using Oracle RAC Features

ORACLE PARALLEL

Ask Tom append hint with dblink
Ask Tom Removing Duplicate Rows While Loading fr
Guy Harrison – Yet Another Database Blog – The parallel_degree_policy parameter in 11gR2
Parallel Execution in Oracle Parallel Server Environments
Parallel Execution
Parallel Query FAQ – Oracle FAQ
parallel_degree_policy tips
Using Oracle’s Parallel Execution Features
Using Parallel Execution

ORACLE PARTICOES

Managing Partitioned Tables and Indexes
Oracle Partition Tables SubPartition Partition Range List Hash
partitioning Partition Decisions

ORACLE RAC

TUDO SOBRE RAC
Use Oracle RAC and TAF to guarantee availability
10g RAC administration
11g RAC Delete or Remove Node Linux
5 Adding and Deleting Nodes and Instances
Adding a new node to an existing Oracle RAC (10g)
AskDba.org Weblog » Verification of CRS Integrity Was Unsuccessful
cluster oracle comandos
Configuring IPMP on Solaris with Oracle RAC
Contents
Convert a Single Instance Database to Oracle RAC 10g on RHEL3
Convert an Oracle 10g RAC database to single instance – Server Fault
Converting a RAC database to single instance database – Oracle RAC 10g « IN ORACLE MILIEU …
Converting a Single Instance Database to RAC Manually – Oracle RAC 10g « IN ORACLE MILIEU …
Converting to Real Application Clusters from Single-Instance Oracle Databases
cr request retry
CRSCTL Oracle Clusterware Service Administration EveryDay Practical Solutions for an Oracle-SQL Server DBA
Database Administration
DBAsupport.com Oracle 10g Central Oracle RAC Administration – Part 3 Administering the Clusterware Components
GC Buffer Busy Waits in RAC Finding Hot Blocks Ardent Performance Computing
gc current request « Dion Cho – Oracle Performance Storyteller
Glossary
http–c2anton.blogspot.com-2007-08-asm-and-ora-29701-unable-to-connect-to.html
http–oracledbasupport.co.uk-how-to-safely-remove-a-data-guard-broker-configuration-under-racnon-rac-setup-2-
https–support.oracle.com-CSP-main-articlecmd=show&type=NOT&doctype=HOWTO&id=730365.1
IBM – Server running AIX with Oracle RAC reboots itself
Installing Oracle Clusterware
links-SPC-interconect
Management of RAC in the OCR (Oracle Cluster Register) kods.net
Managing Oracle AIX based RAC reboots nodes by itself
Monitoring and Troubleshooting
Open Source Job Scheduler FAQs
ora-15042 ASM disk “N” is missing « Anand’s Blog
ORACLE – DBA Tips Corner
Oracle Cluster Registry OCR CRSCTL Command
Oracle Database High Availability Solutions
Oracle DBA and RAC DBA Expert RAC Admin
ORACLE DBA Convert RAC instance to SINGLE instance DATABASE
ORACLE DBA Recover Corrupt-Missing OCR and Voting Disk with No Backup
Oracle in World cluvfy fails with PRVF-5436 PRVF-9652 Cluster Time Synchronization Services check failed
Oracle Interface Configuration (OIFCFG) Command Reference
Oracle Real Application Clusters RAC TAF Transparent Application Failover Vote CRS
Oracle Real Application Clusters RAC TAF
Oracle Silent Mode, Part 5 Adding a Node to a 10.2 RAC The Pythian Blog
Oracle Study Notes by Denis RAC misconfigured or faulty interconnect
Oracle Wait-Time Tips Oracle RAC Wait Events
ORACLE-BASE – DNS Configuration for the SCAN used with Oracle RAC Database 11g Release 2
ORACLE-BASE – Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2
ORACLE-BASE – RMAN Enhancements in Oracle Database 10g
ORACLE-BASE -add rac service
OraFAQ Forum RAC & Failsafe » Cluster ware not starting
OTN Discussion Forums One RAC node is down give the following
OTN Discussion Forums RAC 10g AIXL 5.3without HACMP-GPFS
Padraig’s Blog Oracle 10gR2 RAC with Solaris 10 and NFS
Pre-Installation Tasks for Installing RAC on Solaris Operating System (SPARC 64-Bit)
Pre-Installation Tasks for RAC on AIX
RAC – Nodes
RAC « Christian Bilien’s Oracle performance and tuning blog
re RAC problem, TAF in primary-secondary role
reboot rac
Redolog Corrupted
RemoveNode PSSGroup TWiki
Removing Oracle RAC and ASM Software
Removing Oracle RAC sequence contention
Sachin’s RAC Blog diagcollection.pl commands
Server Control Utility Reference
Server side load balancing in RAC Oracle-Hands-On
The Lazy Tech’s Blog Oracle11gR2 RAC Adding Database Nodes to an Existing Cluster
Troubleshooting Oracle Clusterware
Using Cloning to Add ASM and Oracle RAC to Nodes in a New Cluster
Using Free Lists and Free List Groups in Real Application Clusters (Optional)
Wait Event Enhancements in Oracle 10g
Your saviour at times of utmost need. Important RAC FAQs

ORACLE RECYCLEBIN

Purge recyclebin – Oracle DBA Forums
THE RECYCLE BIN in Oracle 10g – dbapool.com
Using Oracle’s recycle bin Oracle FAQ

ORACLE RMAN

Varios tutoriais
1 Backup and Recovery Overview
8 Managing Backup and Recovery
About RMAN Channels
Administering Oracle Database on AIX
ALLOCATE CHANNEL
Configuring the RMAN Environment
Duplicating a Database with Recovery Manager
GRID
HOM_CURITIBA
How to fix Target Database Incarnation Is Not Current In Recovery Catalog RMAN-20011 « Oracle Spin for Project Managers
http–shonythomas.blogspot.com-2012-02-database-recovery-from-corrupted.html
http–www.mydba.co.za-tips-week35_2009.pdf
MyDBA – Oracle, SQLServer, MySQL and Linux consulting services
new cross platform transportable tablespaces oracle 10g new features data dictionary
Oracle – Tricks of the Trade
Oracle DBA and More… Step-by-step RAC Cloning with ASM
Oracle DBA and RAC DBA Expert Cross Platform Transportable Tablespace using RMAN
Oracle DBMS_BACKUP_RESTORE Backup Restore
Oracle in World When and How to Recreate the Controlfile
Oracle Recovery Manager RMAN Backup Demos
Oracle Recovery Manager RMAN Backup
ORACLE-BASE – RMAN Enhancements in Oracle Database 10g
Restoring and Recovering with Recovery Manager
rman Backup & Recover Control file – Rodrigo Almeida – Oracle
rman Backup em NOARCHIVELOG – Rodrigo Almeida – Oracle
RMAN Backup RAC Example « PeopleSoft
RMAN catalog views
RMAN Configure Settings – dBforums
rman CONTENTS
RMAN Cross-Platform Transportable Databases and Tablespaces
RMAN effective use
rman passo a passo
RMAN restore
Tuning Rman Backups « David Marcos’ Blog
Week 16 Oracle Database 10g Top 20 DBA Features

ORACLE SESSIONS

How to query a session’s active initialization parameters from other session
JDBC Connection Pooling

ORACLE SHARED SERVERS

4 Configuring a Database for Performance shared

ORACLE SQLPLUS

10 Awesome PuTTY Tips and Tricks You Probably Didn’t Know
Dynamic Sampling – Oracle Practicals…
http–oracledbasupport.co.uk-how-to-safely-remove-a-data-guard-broker-configuration-under-racnon-rac-setup-2-
Oracle Dynamic Sampling tips
Oracle-PLSQL Topics Functions (By Category)
SQL FAQ – Oracle FAQ
SQLPlus FAQ – Oracle FAQ

ORACLE STREAMS

Varios tutoriais
1 Introduction to Streams
10 Managing Staging and Propagation
10 Performing Instantiations
14 Monitoring a Streams Environment
16 Best Practices for Propagation
2 Instantiation and Streams Replication
APOLO
DBMS_STREAMS_ADM, 2 of 2
Instantiation and Streams Replication
Oracle 10G RAC – Streams config intra
Oracle Advanced Queueing
Oracle and me October 2007- queue-to-queue
Oracle DBA for Beginners Oracle Streams
Oracle DBMS_AQADM Advanced Queuing
Oracle Streams Replication Example « I’m just a simple DBA on a complex production system
Replicating Data Using Oracle Streams
Scheduling slightly irregular events
SetupStreams.sql
Simple Streams Replication Configuration
Stream capture process start failure
streams comcepts ans administration
Streams

ORACLE TEMP

apagando tablespace groups
Oracle Tablespace Groups
Temporary tablespace group tips

ORACLE TRIGGERS DE SISTEMA

Oracle System Triggers

ORACLE TUNING QUERYS

Ask Tom How to retrieve values from bind variabl
Avoid full table scans in Oracle 10g redflo.de
Bind variable – Oracle FAQ
Chen Guang’s Blog bind variable
GC Buffer Busy Waits in RAC Finding Hot Blocks Ardent Performance Computing
Historical Bind Variable Storage
Mandela Community – Waiting for read by other session
optimizer_index_cost_adj
ORACLE – DBA Scripts
Oracle blog How to bypass buffer cache for full table scans
Oracle Optimizer Moving to and working with CBO Part 3
Oracle PL-SQL Database Code Library and Resources
Oracle SQL
Oracle tuning steps SQL statements
oracle tuning
Oracle Wait-Time Tips Read By Other Session
ORACLE-BASE – TKPROF And Oracle Trace
OTN Discussion Forums maximum setting of sort_area_size
parameter cursor_bind_capture_interval
Peformance Tuning « Liang’s Blog
Sachin Arora’s Blog Execution plan of a running SQL statement
Secret Oracle – Unleashing the Full … – Google Books
ShowDoc
sort_area_size
SQL Scripts
SQL Trace – Oracle FAQ
Top 10 Reasons for poor Oracle performance
Tuning Oracle’s Buffer Cache
Wait Event Enhancements in Oracle 10g
Workload characterization using DBA_HIST tables and kSar « Karl Arao’s Blog
??AWR??STATSPACK??(1-????) – redhouser????? – ITPUB???? – powered by X-Space
????? how to find the executing subprogram’s name ?????????????

ORACLE UPGRADE 11G

Varios tutoriais
11gR2 Grid Infrastructure Installation (Oracle XPS The Netherlands On HA)
About Oracle Restart
Blog do Portilho » Blog Archive » Oracle RAC 11gR2 Adicionar Node
Cross-platform migration – large Oracle 9i db from Solaris 64bit to Linux 32bit Marko Sutic’s Oracle Blog
GUOB – Passa-a-passo para migração do Oracle Database 11g
How to Modify or Deinstall Oracle Grid Infrastructure
https–support.oracle.com-CSP-main-articlecmd=show&type=NOT&doctype=HOWTO&id=730365.1
Oracle – Tricks of the Trade Upgrade Notes from 10g RAC to 11g
Oracle 11g Database New Features
Oracle Database 11g New Features for Administrators – Self-Study CD Course NEW
Oracle Database Online Documentation 11g Release 2 (11.2)
Oracle Database Search Results 11g new features
ORACLE-BASE – DNS Configuration for the SCAN used with Oracle RAC Database 11g Release 2
ORACLE-BASE • View topic – 10gR2 RAC to 11gR2 RAC upgrade articles
Patchset 8202632
Realizando o upgrade de uma base de dados 10g para o Oracle 11g Release 2 …Oracle Blog
StartOracle 11
Tuning Log Switches

CERTIFICAÇÂO

Certificação – Mufalani – DBA Oracle RAC
CertView – Certification History
Managing Jetty

MYSQL

ADV – Curso Prático de MySQL 5
Curso de banco de dados MySQL em video aulas! – T2Ti.com
Curso de MySQL – TreinaWeb
Curso de PHP + MySQL – iPED
Curso grátis aprenda MySQL & PHP em 24 horas – celsojunior.net
Free Web Hosting ftp, php, MySQL
MySQL – Curso Prático
MySQL MySQL Documentation MySQL Cluster
VTutOnline – 01.- Curso de Drupal. Instalación y uso de Cron. (Powered by ClipBucket) (do Firefox)
VTutOnline – 01.- Curso de Drupal. Instalación y uso de Cron. (Powered by ClipBucket)

SHELL LINUX UNIX AIX SOLARIS

326343-1 Virtualizando Microsoft e Oracle no VMware vSphere benefícios e práticas recomendadas
AIX File Commands Tips Support
AIX Health Check – SDD
Aix Tips & Troubleshootings
An Awk Primer-Awk Command-Line Examples – Wikibooks, open books for an open world
Apostilando.com 2009 Download Apostila completa de Linux (354 Páginas)
Append a date to a filename in DOS – Tech Support Guy Forums
Atualizando os Sistemas para o Horário de Verão no Brasil
Auto Estudo LPI Certificação Linux LPI
Awk Command – Luke Jackson
Batch file to login to putty
Canivete Suíço do Shell (Bash) aurelio.net
Command Line Hack for Terminal Server Has Exceeded the Maximum Number of Allowed Connections the How-To Geek
Configuration Directives in httpd.conf
Creating ASM devices on AIX AskDba.org Weblog
Desvio Condicional em Shell Script Nação Livre
Dialog –tudo – O guia completo sobre o dialog, em português aurelio.net
dialog(1) dialog boxes from shell scripts – Linux man page
Easy Way To Install Oracle Database 10g Release 2 on Linux (CentOS) – Step By Step Guide – um knol por Mayur V
Emc powerpath does not create hdiskpower devices – Toolbox for IT Groups
Entendendo o básico de CHMOD
Fibre Channel and Storage Area Network
Horário de Verão – Retificação para servidores AIX e esclarecimentos
Hour 17 Filtering Text with awk What is awk
How to Add a Disk on AIX Logical Volume Manager (LVM) « Ryan’s Tech Notes
How To Start GUI From Linux UNIX Shell Terminal Commands
IBM – System i – Simplifique sua Infra-estrutura – Nossas soluções – LPAR – Brasil
ibm AIX – Large Amount of Page Faults
Internal Commands and Builtins
Joyce Babu » Blog Archive » Copying multiple files simultaneously using scp utility
Júlio Battisti – Tutoriais
lf216, UNIXBasics Programação Shell
linux Aumente a sua área de swap [Dica]
Linux Command 7 – more, less, head, tail, cat « Linux from beginning
Linux Commando Using sed to extract lines in a text file
Linux in Brazil ( Tutorial de AWK )
Linux Shell Scripting Tutorial – A Beginner’s handbook
linux Usando o RPM (Red Hat Packet Manager) [Dica]
Managing AIX logs
O que é o Crontab – Tecnologia, Software, Tutoriais
Oracle ASM with Oracle 10g RAC on AIX – Oracle Database – Jaggy Inc
Pax Tecnologia Knowledgebase – Linux
Problem with IF – CAT – GREP in simple shell script – The UNIX and Linux Forums
Programando em shell-script – Devin
Progress Dialog
scp Command
Shell Programs Arithmetic
Shell Script e Banco de Dados
Simulado LPI 117-101 Central do Linux
Simulados Central do Linux
Solaris Command Reference
Terramel – WordPress Toolbar
Testking Linux Lpi 117-101 v8
TIAGO.DIAS.ETI.BR » Solaris
time – How to change timezone to UTC without rebooting AIX – Unix and Linux – Stack Exchange
Tutoriais-Apache-Apache-performance – UnderLinux Wiki
windows 7 – A putty shortcut that automatically launches a profile – Super User

1Z0-048 Oracle Database 10g R2=Administering RAC Dumps
Android Apps 101 Best Android Apps
Calculo PJ – Simule o valor hora de acordo com seu salário CLT
Dialog –tudo – O guia completo sobre o dialog, em português aurelio.net
Download Free LPI TestKing Pass4Sure – ExamCollection.com
gomo An Initiative From Google
Hide My Ass! Free Proxy and Privacy Tools – Surf The Web Anonymously
Oracle DBA and Apps DBA blog How to prepare for 1Z0-048 – Oracle 10g RAC Certified Expert Exam
OTN Discussion Forums 1Z0-048-RAC Certified Expert
Passed Oracle 1z0-048~~~~~~ – Nairaland
Run away by Linkin Park on Unknown – Grooveshark
TinyPic – Free Image Hosting, Photo Sharing & Video Hosting
UOL – Blog
Using Oracle RAC Features
XGH – eXtreme Go Horse Process « Blogaro!

Anúncios

Deixe um comentário

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s