There are two nodes in oracle RAC database [rac1] and [rac2] Below tasks has to be executed from the first node…
This examle shows how to multiply control files in Oracle Database RAC 11g. An example cluster database racdb1 is up and…
View Also: Oracle DBA Interview Questions Answered: UNIX 60 Oracle Database Administration (DBA) Interview Questions (Technical) 1. What is an Oracle…
Copying SQL Profiles from one database to another involves the following steps: Creating a staging table to store the SQL Profiles…
Physical Oracle Database Limits Item Type of Limit Limit Value Database Block Size Minimum 2048 bytes; must be a multiple of operating…
Managing VMware images in VMware Server 2.x can be done in several ways. One way is to utilise Web based GUI…
Try on this in Linux or UNIX platform: [email protected] [~]$ cal 9 1752 September 1752 Su Mo Tu We Th Fr…
DBMS_STATS in an Oracle Database Using DBMS_STATS package to gather Oracle dictionary statistics. 1. To gather table statistics with DBMS_STATS SQL>…
V$SESSION_LONGOPS view This view displays the status of various operations that run for longer than 6 seconds (in absolute time). These…
This article describes how to disable SSL protocol and redirect to port 8333 in VMware Server 2.0 in Linux By default…