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 […]
How to Create User in Oracle and Assign privileges
We will be posting information on User access and security in the oracle database. This post will give good information on Create User in Oracle, System Privileges and Oracle Object Privileges, How to grant the privileges to users, How to show all privileges from a user in oracle CREATE USER statement It is employed to […]
