This is a small compilation of Oracle RAC interview Questions which include both the Oracle RAC-specific questions and Oracle Clusterware questions. This is good for experienced level Professional Oracle RAC-specific Questions Question 1. What are Oracle RAC and its uses? Answer Oracle RAC is a cluster database where multiple instances of Oracle run multiple nodes […]
Oracle RAC interview Questions Read More »
Putty is a wonderful client to connect to Linux or Unix servers easily. It has the option to connect using both telnet or ssh protocol. It has the option of RAW, serial, RLogin also It is available for Windows 95, 98, XP, Vista, and 7,10 and It can downloaded from the below link Download Putty
How to use Putty for SSH Read More »
Why Multitenant Architecture introduced with 12c? Many Oracle customers have large numbers of applications built on Oracle RDBMS. They do not use a significant percentage of the hardware on which they are deployed.Customers have instance and storage overhead preventing large numbers of databases from being placed on the same physical and storage server. They are not
Understand Oracle Database 12c/18c/19c – Multitenant Architecture Read More »
Parallel execution is a important aspect of increasing throughput in oracle database.So often use Parallel execution in Oracle database. In this post, i will touch upon Important Parallel processing data dictionary views and How to monitor parallel queries in oracle database Parallel Processing Data Dictionary views In this section we are trying to give a
How to monitor parallel queries in oracle database Read More »
What is Unique Key Unique key in Oracle Uniquely identifies every row in the database. It basically enforces uniqueness on the column definedImportant things There can be more than one Unique key per table It can be defined on one or more columns Columns comprising Unique key may be null-able How to create the Unique
Unique Key in Oracle with Examples Read More »
Patches can be downloaded using command line download manager utility such as wget. 1.First we need to check if we have wget installed in the system You can use below command which wget or locate wget 2. Make sure it is compiled with SSL option $ wget –help (Below output shows that wget is compiled
How to download Patch from Oracle using Wget Read More »
