Category Archives: Oracle Database

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.Many companies has implemented their data in Oracle. Most of them are mission critical. So Oracle database concept need to be very clear to manage these mission critical things. At the same time Oracle database needs to deliver high performance also. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Below section I have tried to present all the important features in Oracle Database management

PDB Relocate in Oracle database 12c Release 2

A pluggable database is a self-contained, fully-functional Oracle database. We often need to move the pluggable database from one CDB to another CDB. This will be a unplug/plug operation where outage will depend on the location of source and destination CDB 1) When moving between servers with shared storage, such as is typically the case in Cloud environments when the PDB is being moved for … Continue reading PDB Relocate in Oracle database 12c Release 2 »

RMAN connection decoded

RMAN is a important tool used in Backup and recovery. Whenever you use RMAN tool in $ORACLE_HOME/bin and connect to database, it makes multiple connection to the database.Here are RMAN connection decoded Whenever we make RMAN connection to database for backup with or with out catalog,many processes are spawned and worked upon. RMAN always spawns TWO processes (sessions) when connected to a target database: • 1st … Continue reading RMAN connection decoded »

Step by Step instructions for Oracle Virtual Box Installation

VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use VirtualBox runs on Windows, Linux, Macintosh, and Solaris hosts and supports a large number of guest operating systems including but not limited to Windows (NT 4.0, 2000, XP, Server 2003, Vista, Windows 7, Windows 8, Windows 10), DOS/Windows 3.x, Linux (2.4, 2.6, 3.x and 4.x), Solaris and OpenSolaris, OS/2, … Continue reading Step by Step instructions for Oracle Virtual Box Installation »

Oracle Create table Syntax,Tip and Examples

Last updated on September 7th, 2018 at 04:17 amThis article talks how to create table in Oracle,primary key ,Foreign keys,create table syntax in oracle witrh Examples. This will be very useful for Oracle DBA’ s and Developer both.They play with it many times in the day and an good knowledge can definitely help them expedite the task.They often get confused the datatype and what to … Continue reading Oracle Create table Syntax,Tip and Examples »

Latches and Mutex

INTRODUCTION To LATCH Latches are low level serialization mechanisms used to protect shared data structures in the SGA. The implementation of latches is operating system dependent, particularly in regard to whether a process will wait for a latch and for how long. A latch is a type of a lock that can be very quickly acquired and freed. Latches are typically used to prevent more … Continue reading Latches and Mutex »

Useful Cluster command in Oracle clusterware 10g , 11g and 12c

Last updated on September 7th, 2018 at 04:25 amOracle clusterware is the clusterware technology from oracle to Manage Oracle RAC database on various platform.Oracle  has provide cluster utilities to manage it. Here are some of the useful Cluster command  in 10g ,11g and 12c  CRSCTL Cluster Control utility performs various administrative operation of oracle clusterware. It is located in $ORA_CRS_HOME/bin and must be executed by … Continue reading Useful Cluster command in Oracle clusterware 10g , 11g and 12c »

5 ways to delete duplicate rows from Oracle table:Step by Step

Last updated on September 7th, 2018 at 04:21 amWe often need to find  and delete duplicate rows from oracle table due to many reasons in the database. We need to delete to clear off the data issues often. There are many ways to oracle delete duplicate rows but keep original .I would be showing off few  faster method to achieve it in this post. Please note … Continue reading 5 ways to delete duplicate rows from Oracle table:Step by Step »

Flashback PDB in Oracle Database 12c Release 2

Oracle database 12c Release 2 provides flashback capability at the individual PDB level. Lets discuss the new feature. we can learn about Flashback database in general from below links Flashback Database explained and limitation For the oracle database to be flashback, archive log mode and flashback mode should be on How to put database in archive log mode sqlplus “/ as sysdba” SHUTDOWN IMMEDIATE STARTUP … Continue reading Flashback PDB in Oracle Database 12c Release 2 »

REGEXP string Manipulation

String manipulation and searching contribute to a large percentage of the logic within a Webbased application. Regular expressions are a method of describing both simple and complex patterns for searching and manipulating. Usage ranges from the simple (“Find the word SAN in the text”) to the more complex (“Extract all URLs from the text”) to the archaic (“Find all words in which every second character … Continue reading REGEXP string Manipulation »

How to use Optimizer hints

What is Optimizer? When a query is submitted in Oracle server. optimizer attempts to generate the best execution plan for a SQL statement. The best execution plan is defined as the plan with the lowest cost among all considered candidate plans. The cost computation accounts for factors of query execution such as I/O, CPU, and communication. The best method of execution depends on myriad conditions … Continue reading How to use Optimizer hints »