Controlling Diagnostic and Tuning Pack
In this blog, we will see what controls Automatic Workload Repository in Oracle. For those who arrived to this blog and new, you will need to know more about Controlling…
Read MoreIncrease oacore process in Oracle EBS 12.1.3
How to increase oacore/jvm processes in R12.1.3 Below are the steps to increase oacore process: STEP1: Take a backup of context file and opmn.xml file. a. /u01/inst/apps/<CONTEXT_NAME>/ora/10.1.3/opmn/conf/opmn.xml b.$CONTEXT_FILE STEP2: Modify…
Read MoreTablespace Level Fragmentation — Defragmentation/Shrink A Big Tablespace In Oracle
The most efficient/effective way to defrag/shrink a big tablespace in oracle is to migrate the tables/indexes to new tablespaces. Here below are the steps: Step 1. find tablespace “BMW” whether…
Read MoreHow to choose the Best Offshore Oracle Service Provider?
In the current business environment, cloud-based services have grown in high popularity among companies. Statistically, 93% of enterprises preferred the multi-cloud approach, while 87% focused on hybrid cloud strategies in…
Read MoreOracle APEX Page Item shuttle with filter
Introduction: Here is small tip how to create filter / search field for APEX shuttle item values. For this you need just place jQuery code to page JavaScript Function and…
Read MoreInteractive Report Row Highlight Based on Application User
Introduction First create interactive report. In this example rows where manager name equals APP_USER value are highlighted. I have used following query joining EMP and DEPT tables for interactive report:…
Read MoreCreating Excel File in Oracle Forms
Below is the example to create an excel file in Oracle Forms. Pass the Sql query string to the below procedure to generate an Excel file using Ole2 package. Sample…
Read MoreUsing Find_Alert and Show_Alert in Oracle Forms
Introduction Show_alert is used to display model window messages in Oracle Forms and Find_alert searches the list of valid alerts in Form Builder, when the given alert is located, the…
Read MoreUsing Post_Query Trigger in Oracle Forms
Introduction When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block. The trigger fires once for each record…
Read MoreHow To PLAY_SOUND in Oracle Forms
Introduction Play sound is used to play audio files in Oracle Forms, Play Sound plays the sound object in the specified sound item PLAY_SOUND examples The following plsql block you…
Read More