All Posts |
How to Install Red Hat Enterprise Linux 5A step by step guide for installing Red Hat Enterprise Linux 5 (RHEL 5) 32-bit. I usually do this kind of installation for Oracle Server. |
How to Configure ASM disks using ASMLib or Raw DisksThere are two very common ways to configure disks for ASM, using ASMLib or Raw Disks. This article covers both of them. |
How to migrate Oracle datafiles to ASM storage via RMANThis article shows how to migrate or move oracle datafiles to ASM diskgroups using RMAN after installing ASM instance with a non-asm database. |
How to perform Block Media Recovery using RMANIf you have corrupt blocks in datafile and you have RMAN backup or copies of the file, just those blocks can be recovered via RMAN Block Media Recovery feature. |
Automatic Shared Memory Management in Oracle 10gThis article is a brief explanation of Oracle 10g Automatic Shared Memory Management (ASMM) and is explained with examples. |
How to configure Raw Disks in RHEL 5Red Hat Enterprise Linux 5.0 and 5.1 does not have rawdevices services. This post shows how to configure raw disks in RHEL 5.0. and 5.1 using UDEV. |
Recyclebin with Flashback Table in Oracle 10gA great feature in oracle 10g is recycle bin. Accidental table drops are now quite minimized with this feature. Just do a Flashback Table and the table is back. |
How to install ASM instance on a non-asm Oracle databaseThis artical is a step by step demonstration of how to install ASM instance with Database Configuration Assistant to work with a non-asm Oracle Database. |
Oracle 10g db_nk_cache_size ParametersThis is an article to show how to configure multiple size buffer caches in SGA and create tablespaces with different block sizes. |
Handling Nulls in a Primary and Foreign key relationshipNULLS are the most mysterious element of a database, always behave different. This post shows how NULLS behave with Primary/Foreign Key relationships. |