Oracle June 10, 2011 0

How to multiply control files in Oracle DB RAC 11g

This examle shows how to multiply control files in Oracle Database RAC 11g. An example cluster database racdb1 is up and…

Oracle May 16, 2011 0

Oracle DBA Interview Questions Answered: Technical

View Also: Oracle DBA Interview Questions Answered: UNIX 60 Oracle Database Administration (DBA) Interview Questions (Technical) 1. What is an Oracle…

Oracle April 13, 2011 0

Copy SQL Profiles to another Oracle database

Copying SQL Profiles from one database to another involves the following steps: Creating a staging table to store the SQL Profiles…

Oracle March 15, 2011 0

Physical Logical Oracle Database Limits

Physical Oracle Database Limits Item Type of Limit Limit Value Database Block Size Minimum 2048 bytes; must be a multiple of operating…

Linux Articles January 20, 2011 1

Managing VMware images from command line using vmrun tool

Managing VMware images in VMware Server 2.x can be done in several ways. One way is to utilise Web based GUI…

Linux Articles December 20, 2010 2

UNIX Calendar – missing days in 1752

Try on this in Linux or UNIX platform: [email protected] [~]$ cal 9 1752 September 1752 Su Mo Tu We Th Fr…

Oracle, Oracle Database December 1, 2010 1

DBMS_STATS in an Oracle Database

DBMS_STATS in an Oracle Database Using DBMS_STATS package to gather Oracle dictionary statistics. 1. To gather table statistics with DBMS_STATS SQL>…

Oracle November 29, 2010 0

A very cool dollar view V$SESSION_LONGOPS

V$SESSION_LONGOPS view This view displays the status of various operations that run for longer than 6 seconds (in absolute time). These…

Linux Articles November 2, 2010 2

How to disable SSL and redirect to port 8333 VMWare Server 2.0

This article describes how to disable SSL protocol and redirect to port 8333 in VMware Server 2.0 in Linux By default…

Oracle November 1, 2010 0

Types of SQL Statements

A Data Manipulation Language (DML) is a family of computer languages used by computer programs and/or database users to…