Oracle Database Administration
- Undo Data Management
- Changing Database To Archive Log Mode
- Making Oracle Database Autostart
- Find Cause And Solution For Oracle Error With oerr
- Increase Concurrency By Indexing Foreign Key
- Global Login Script - glogin.sql
- Configure Oracle LISTENER
- Always Test Your Patch File
- Optimal Flexible Architecture (OFA)
- Oracle Initialization File SPFILE and PFILE
- Oracle Database Shutdown Process
- Oracle Database Startup Process
- Where is my database alert log file ??
- Guidelines for Managing Tablespaces
- Create Tablespace
- Rename Datafile
- Delete Tablespace
- Increase Tablespace Size Automatically and Manually
- Find Out Tablespace Free Space
- Backup Control File
- Recover Missing Control File From Multiplexed Copy
- Manage User Profile
- Profile Password Verification Function
- Tablespace Usage
- Print Table Vertically (Display)
- To Check Schema Size
- Not advisable to use ROWID in your application
- Shrink The Datafile of Undo Tablespace
- Detect Tablespace Fragmentation
- Oracle Database Health Check
- Automating Shutdown and Startup Oracle DB (6 Steps)
Middleware and Tools
- Installation Oracle GoldenGate 11g Consideration
- Oracle GoldenGate subdirectories
- Evaluating GoldenGate Initial Load
- Prepare GoldenGate Environment
- Oracle GoldenGate Setup Procedure
- GoldenGate Capturing from one source database in real-time mode
Database Design
- ACID Properties
- Two-Phase Commit (2PC)
- Potential Normalization Hazards
- Problem With Entity Relationship (ER)
Installation and Setup
- Download Software Needed
- Installation VMware Server 1.0.8 on Windows
- Create New Virtual VMware Server 1.0.8
- Installation Oracle Enterprise Linux 5 on VMware
- Installation Oracle 11g on Enterprise Linux 5
- Create Oracle Database with DBCA
- Add Solaris Packages