Steps / How to Migrate Non ASM Instance Database to ASM Instance
NOTE: Always Do Exercise on Test Environment, First. Assumptions : 1. ASM Instance is already Created and Ready to Use. […]
NOTE: Always Do Exercise on Test Environment, First. Assumptions : 1. ASM Instance is already Created and Ready to Use. […]
NOTE: This is One of the Hidden Oracle Parameters. DO NOT use it until and unless instructed by Oracle Support.
AWR is an enhancement/upgradation of statspack, which help us to tune the database. Oracle Database 10g uses a scheduled job,
On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there
Storage Options for RAC CFS (Cluster File System) – Easy to manage but only available on some platforms. Does not
The purpose of this article is to get acquianted with some of the recovery scenarios , this topic is useful
Note that the methods in this note will allow you to check upon an Oracle installation, it is still recommended
Embedding a SQL inside Shell Script:- Here is a tip on how to run sqlplus scripts within a shell script.
You can have various methods to identify the large or fragmented indexes in 11i or you can just configure the
Steps mentioned in this post is overview of Oracle database upgrade from 8i, 9i or 10g to 11g Rel 1 i.e. 11.1.X.X.X