Here in this post, I am trying to explain the Basic elements(Application, Forms, functions, menu) of the Oracle EBS Application Application An Application is a collection of Forms,Reports and PL/SQL objects to meet a particular business objectives Oracle Applications like 11.0,11i,R12 is a collection of predefined inter linked applications A custom application can be designed […]
How to use oracle optimizer hints for tuning
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 […]
Oracle cloud storage : Block Volume
We will be checking about oci block storage in this post. What is block storage and what are the features of block storage What is Block Volume OCI Block storage is the NVMe SSD based storage that you can attach to any compute instance that was launched It can hold applications, installations, or even software […]
Cloud Computing Basics: iaas paas saas
We have heard a lot about iaas paas saas in cloud computing terms. IaaS stands for Infrastructure as service, PaaS stands for Platforms as a service and SaaS stands software as a service Let’s take a look at the key difference between them and examples of them (1) IAAS This is known as Infrastructure as a […]
Recover Database after losing FRA diskgroup
Sometime back, I hit a problem where the FLASH diskgroup of my Oracle ASM cluster went bad and it was set to external redundancy. My all database went down and it created a lot of panics I had to go through the below steps to Recover Database after losing FRA asm diskgroup Let’s first see […]
How to drop the oracle database
In this post, we will discuss how to drop the oracle database. The below procedure drops the spfile also but it does not touch Oracle Home. You may want to backup the spfile before dropping the database sqlplus / as sysdbastartup mount (If database not started)create pfile=’/tmp/pfile.ora’ from spfile; How to drop the database Now […]
