Edition-based redefinition in Oracle Database 11gR2//12c/18c/19c allows multiple versions of PL/SQL objects, views, and synonyms in a single schema, which makes it possible to perform upgrades of database applications with zero downtime. It also means we can maintain multiple copies of the same object What is Edition in Oracle? An edition is effectively a version […]
Basic elements(Application,Forms,functions,menu) of Oracle EBS Application
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 […]
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 […]
