Author: techgoeasy

How to find the waitevent History of the Oracle session

In this post , we will look at the different queries to retrieve the waitevent history of the Oracle session. History of wait events in a specific session from start can be found using below query set lines 120 trimspool on col event head “Waited for” format a30 col total_waits head “Total|Waits” format 999,999 col tw_ms head “Waited|for (ms)” format 999,999.99 col aw_ms head “Average|Wait … Continue reading How to find the waitevent History of the Oracle session »

How to run sql tuning advisor for particular sql -id in the Cursor cache

Many times a sql may be running long and we may need to run sql tuning advisor to get the recommendation to resolve the long running issue.In this post, we would be looking at the steps to achieve it Steps for running  sql tuning  advisor on the particular sql -id in the Cursor cache Create sql Tuning Task DECLARE my_task_name VARCHAR2(30); BEGIN my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK( … Continue reading How to run sql tuning advisor for particular sql -id in the Cursor cache »

What you need to know about Oracle Flashback query

Oracle has introduced Flashback Technology  that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery. With flashback features, you can do the following: Perform queries that return past data Perform queries that return metadata that shows a detailed history of changes to the database Recover tables or rows to a previous point … Continue reading What you need to know about Oracle Flashback query »

Recover drop/truncate/delete table on primary using flashback on standby database

Many times because of human error, Table accidentally get dropped/truncated or partially deleted in the primary database.Such errors can result in “logical” data corruption or cause one or more components of the IT infrastructure to cease operating We will discuss about recovering from this error by enabling Flashback technology on the standby database.we will be able to recover database without any interruption the primary database … Continue reading Recover drop/truncate/delete table on primary using flashback on standby database »

What is current view APPL_TOP snapshots

What is APPL_TOP snapshots? 1) It is record the current set of files and file versions in your APPL_TOP 2) Current view snapshots are created once and updated when appropriate to maintain a consistent view of the APPL_TOP content 3) Snapshots are current views of your system: they are created once, and then updated when appropriate to maintain a consistent view. There are two types of … Continue reading What is current view APPL_TOP snapshots »

Recover Database after loosing FRA diskgroup

Sometime back ,I  hit a problem where FLASH diskgroup of my ASM cluster went bad and it was set  to external  redundancy . My all database went down and it created lot of panic. I had to go through the below steps to Recover Database after loosing FRA diskgroup Let’s first see what all things are present in FLASH or FRA Second Control-file Multiplex redo … Continue reading Recover Database after loosing FRA diskgroup »

Identity domain Concept in Oracle Cloud

What is identity domain An identity domain is a construct for managing users and roles, integration standards, external identities, secure application integration through Oracle Single Sign-On (SSO) configuration and OAuth administration. OAuth is an authorization protocol — or in other words, a set of rules — that allows a third-party website or application to access a user’s data without the user needing to share login … Continue reading Identity domain Concept in Oracle Cloud »

Must Read Oracle Database Cloud Service Overview and various options

Introduction to Oracle Database Cloud Service Oracle database cloud service is an service of Cloud Category PaaS. It enables businesses to reap all the benefits of Platform as a Service, including subscription-based, self-service access to reliable, scalable, and elastic cloud environments. Earliar you need to purchase hardware ,install OS and then install Oracle software and create database for using the database. Now You can be … Continue reading Must Read Oracle Database Cloud Service Overview and various options »

How To Check Environment Variables for a Running Process

This post we will talking about one of the useful things which administrator often has to use. The topic is How To Check Environment Variables for a Running Process . Let’s first start with what is environment variable and then find out How To Check Environment Variables for a Running Process in different flavor of Unix systtem What is environment Variable An environment variable is a dynamic-named … Continue reading How To Check Environment Variables for a Running Process »

How to use Virtual Index in Oracle

Last updated on September 21st, 2017 at 05:23 pmWhat is  Virtual Index in Oracle ? a) A virtual index is a “fake” index whose definition exists in the data dictionary, but has no associated index segment. b) Many time tuning advisor recommends you creating new index and you want to test the new index. In this case It can take good amount of time to … Continue reading How to use Virtual Index in Oracle »

Step by Step resolution for the problem oacore not coming up in R12

Last updated on September 21st, 2017 at 05:20 pmI would be presenting some solutions for oacore not coming up  in R12 EBS  version. First let me give brief idea about oacore mechanism in R12 In R12 we have 3 groups of OC4J’s. oacore OC4J – Supports framework based applications forms OC4J – Supports forms based applications oafm OC4J – expands to Oracle Application Fusion Middleware … Continue reading Step by Step resolution for the problem oacore not coming up in R12 »

Oracle E-Business Suite on Oracle Cloud Overview

Oracle E-Business Suite on Oracle Cloud Oracle E-Business Suite on Oracle Cloud is exactly the same EBS applications that you run on premises in your data center today—the same applications you may have customized—on .This is same EBS application which you know from years. Difference is just that this is hosted on a combination of Oracle’s Infrastructure as a Service (IaaS) and Platform as a … Continue reading Oracle E-Business Suite on Oracle Cloud Overview »