To check database -link
New Features
Support for Multiple Indexes on the Same Columns -link
Partial Indexes for Partitioned Tables -link
Top - n -link
DDL
auto_increment -link
Threshold -link
Sending notification after an event has remained open for a specified period -link
PERFORMANCE TUNING OF DATABASE
Performance Tuning -link
Active Session History (ASH) -link
SQL Tuning -link -link
SQL Tuning manually with the sql_id -link
Get The SQL Plan -link
SQL Plan Management 12C R2 -link
SQL Plan Management 12C R1 -link
SQL Stored Outlines and Plan Stability -link
SQL Plan Purge from shared SQL AREA -link
SQL Plan to check history about a plan -link
SQL Plan to display plan table output -link
Migrating stored outlines to SQL Plan Management -link
SQL Hints -link
AWR report to compare between two times -link
Create Plan Table -link
Plustrace Role -link
SQL Plan with dbms_xplan -link
SQL Plan with utlxpls.sql -link
SQL Plan with Explain Plan Tool AUTOTRACE -link
STATSPACK -link
Lock -link
Waiting Event -link
Query Transformer
System Statistics -link
File Statistics -link
Latches -link
Waiting Statistics -link
Proccess
Background Process
DATABASE DESIGN
To find foreign keys that don't have corresponding indexes -link
MEMORY
to check Memory -link
AMM -link
ASMM -link
SQL
SQLPlus -link
AWR Automatic Workload Repository
AWR -link
ADVIDOR
Memory Advisor -link
SQL Tuning Advisor -link
RMAN Data Recovery Advisor -link
DATA GUARD BROKER
Duplicate database from ASM to File System by using OMF -link
dgmgrl - Performing a Manual Failover Operation with dgmgrl -link
dgmgrl - DataGuard FastSync : Define the Redo Transport Mode SYNC NOAFFRIM -link
FLASHBACK
Flashback -link
Flashback Recovery Area -link
Flashback Transaction Query -link
Flashback Database -link
Flashback Drop -link
Flashback Table -link
Flashback Data Archive -link
OPATCH
opatch -link
OEM
Oracle Enterprise Manager -link
emctl agent -link
DATABASE EXPRESS
Database Express -link
CDB and PDB
CBD AND PDB concepts -link
CBD AND PDB -link
DATABASE
ADRCI - Automatic Diagnostic Repository Command Interpreter -link
Health Monitor -link
Block Corruption -link
OMS - Oracle Manager Server -link
DATABASE FILE
Control file -link
LogFile -link
Temporary Tablespace -link
MIGRATE
Migrate from ASM groupdisk to another -link
Moving Logfile in ASM from DATA to DATA_GROUP -link
Moving Temporary Tablespace from DATA to DATA_GROUP -link
Moving Controlfile from DATA to DATA_GROUP by using RMAN -link
Moving Datafiles within ASM from DATA to DATA_GROUP -link
Moving spfile from DATA to DATA_GROUP -link
Setting up parameter of Database after moving database to another location -link
Setting up parameter of CRS after moving database location -link
Drop diskgroup within ASM after moving data to another diskgroup -link
ASM - Automatic Storage Manager
ASM - Administration -link
RMAN
RMAN - Creating Catalog -link
RMAN - Configure -link
RMAN - Script within RMAN Catalog -link
RMAN - Moving or Multiplexing Control File by Using RMAN - link
RMAN - Duplicate -link
RMAN - To check backup of database by script from target database -link
RMAN - Crosscheck -link
RMAN - Estimated time of backup and restore -link
EXPORT AND IMPORT
Directories -link
expdp -link
expdp and impdp transporte tablespace -link
STATISTICS
Automated Statistics -link
Manual Statistics -link
Historical Statistics -link
HISTOGRAM
Histogram -link
TABLESPACE
Taplespace - scripts size of tablespace -link
INSTALATION
Checking Hardware and Memory Configuration Grid Infrastructure 12c r1 -link
Setting system parameters with yum -link
creating oracle user and groups -link
Setting Oracle Environment -link
Installing Oracle 12c R1 standalone on Oracle Linux 7 with ASM and Oracle Restart -link
OPERATION SYSTEM (Oracle Linux 7)
SWAP - Increasing /tmp on Oracle Linux 7 with Logical Volume -link
Creating File System /u01 with Volume Group -link
Miscellaneous -link
Grep command -link
Promp under Linux -link
.bash_profile -link
OPERATION SYSTEM (Oracle Solaris 11)
zone -link
networking -link
VIRTUABOX
Virtualbox Commands -link
EXADATA
Check List -link
lounch query (llanza consulta) -link
Interview -link
Flashback -link
Flashback Recovery Area -link
Flashback Transaction Query -link
Flashback Database -link
Flashback Drop -link
Flashback Table -link
Flashback Data Archive -link
OPATCH
opatch -link
OEM
Oracle Enterprise Manager -link
emctl agent -link
DATABASE EXPRESS
Database Express -link
CDB and PDB
CBD AND PDB concepts -link
CBD AND PDB -link
DATABASE
ADRCI - Automatic Diagnostic Repository Command Interpreter -link
Health Monitor -link
Block Corruption -link
OMS - Oracle Manager Server -link
DATABASE FILE
Control file -link
LogFile -link
Temporary Tablespace -link
MIGRATE
Migrate from ASM groupdisk to another -link
Moving Logfile in ASM from DATA to DATA_GROUP -link
Moving Temporary Tablespace from DATA to DATA_GROUP -link
Moving Controlfile from DATA to DATA_GROUP by using RMAN -link
Moving Datafiles within ASM from DATA to DATA_GROUP -link
Moving spfile from DATA to DATA_GROUP -link
Setting up parameter of Database after moving database to another location -link
Setting up parameter of CRS after moving database location -link
Drop diskgroup within ASM after moving data to another diskgroup -link
ASM - Automatic Storage Manager
ASM - Administration -link
ASM - Using UDEV SCSI Rules Configuration for ASM disks -link
ASM - Add and drop some disks at the same time -link
ASM - Add and drop some disks -link
ASM - ASMCMD -link
ASM - Diskgroup -link
ASM - Droping diskgroup -link
ASM - Create Diskgroup -link
ASM - Select on ASM Instance or asmcmd -link
User Enviroment -linkASM - Add and drop some disks at the same time -link
ASM - Add and drop some disks -link
ASM - ASMCMD -link
ASM - Diskgroup -link
ASM - Droping diskgroup -link
ASM - Create Diskgroup -link
ASM - Select on ASM Instance or asmcmd -link
RMAN
RMAN - Creating Catalog -link
RMAN - Configure -link
RMAN - Script within RMAN Catalog -link
RMAN - Moving or Multiplexing Control File by Using RMAN - link
RMAN - Duplicate -link
RMAN - To check backup of database by script from target database -link
RMAN - Crosscheck -link
RMAN - Estimated time of backup and restore -link
EXPORT AND IMPORT
Directories -link
expdp -link
expdp and impdp transporte tablespace -link
STATISTICS
Automated Statistics -link
Manual Statistics -link
Historical Statistics -link
HISTOGRAM
Histogram -link
AUTOTASK
Autotask -link
TABLESPACE
Taplespace - scripts size of tablespace -link
INSTALATION
Checking Hardware and Memory Configuration Grid Infrastructure 12c r1 -link
Setting system parameters with yum -link
creating oracle user and groups -link
Setting Oracle Environment -link
Installing Oracle 12c R1 standalone on Oracle Linux 7 with ASM and Oracle Restart -link
OPERATION SYSTEM (Oracle Linux 7)
SWAP - Increasing /tmp on Oracle Linux 7 with Logical Volume -link
Yum - Oracle Linux 7 -link
I/O on Disk - Solaris, Linux -link
Disable Firewall on Oracle Linux 7 -link
NTP configuration on Oracle Linux 7 -link
Creating File System /u02 -linkCreating File System /u01 with Volume Group -link
Miscellaneous -link
Grep command -link
Promp under Linux -link
.bash_profile -link
OPERATION SYSTEM (Oracle Solaris 11)
zone -link
networking -link
VIRTUABOX
Virtualbox Commands -link
EXADATA
Check List -link
lounch query (llanza consulta) -link
Interview -link
