Category Archives: Oracle

ORACLE TUTORIALS

Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

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 »

PDB Relocate in Oracle database 12c Release 2

Last updated on December 17th, 2017 at 05:25 pmA 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 … Continue reading PDB Relocate 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 »

Refreshable PDB in Oracle Database 12.2

Refreshable PDB is a new features introduced in 12.2 . It builds upon hot clone capability in Oracle Database 12.2. It basically means we can refresh the remote PDB from source PDB on regular intervals by just applying the incremental redo This feature eliminates the need to re-create a cloned environment from scratch and also ensures that a cloned PDB can be periodically synchronized with … Continue reading Refreshable PDB in Oracle Database 12.2 »

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 »