Online Oracle Apps DBA Training Course Part 1

Oracle’s E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications Oracle applications is the widely used EBS application in the world.Oracle’s E-Business Suite requires extensive work from Oracle Application Database Administrator(Oracle apps DBA). So Oracle Application Database Administrator is a rewarding career with great potential to scale … Continue reading Online Oracle Apps DBA Training Course Part 1 »

Oracle Create table Syntax,Tip and Examples

This article talks how to create table in Oracle,create table syntax in oracle,oracle create table example, Oracle is the most RDBMS used everywhere for system Table of content What is Oracle database Table How to create table in oracle create table syntax in oracle Privilege required to create table Other characteristics associated with table How to modify the oracle database table Creation of table using sub … Continue reading Oracle Create table Syntax,Tip and Examples »

Output post Processor(OPP)

The Output Post Processor (OPP) is an enhancement to Concurrent Processing and is designed to support XML Publisher as post-processing action for concurrent requests. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it will contact the OPP to apply the XML Publisher template and … Continue reading Output post Processor(OPP) »

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 »

Top 10 Useful oracle apps queries for DBA

Oracle apps DBA has to often trouble shoot various issues. I am giving here Top 10 Useful oracle apps queries for DBA To find forms sesssion in database set linesize 1000 column username format a8 heading “User|Name” column sid format 9999 column serial# format 99999 column user_form_name format a25 column spid format a5 column unix_process format a7 heading “UNIX|Process” column user_name format a15 trunc heading … Continue reading Top 10 Useful oracle apps queries for DBA »

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

Oracle 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 the “root” user. Starting and stopping Oracle Clusterware … Continue reading Cluster command in Oracle clusterware 10g , 11g and 12c »

How to delete duplicate rows from Oracle table

Last updated on December 22nd, 2017 at 06:14 pmWe 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 How to delete duplicate rows from Oracle table »

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 »

ASM best practice to add disk

Here are ASM best practice to add disk which should be always use to manipulate the ASM disks 0) First check the newly added disk is visible in ASM  disksselect header_status,path from v$asm_disk where path= ”; It should show candidate .1) Create a new temporary diskgroup: CREATE DISKGROUP TEST_DISK EXTERNAL REDUNDANCY DISK ”; 2) Check if the diskgroup is created and mounted: SELECT STATE, NAME FROM … Continue reading ASM best practice to add disk »

How to use Patch wizard in Oracle EBS environment

How to use Patch wizard  You can submit a specific patch analysis request through the Patch wizard to determine the impact of a patch on your system. Patch Wizard Impact Analysis provides reports on: • The total number of files in the patch • The number of files the patch will install • The products that will have updated files • The files that will … Continue reading How to use Patch wizard in Oracle EBS environment »