Oracle Database 18c Client Released

Oracle Database 18c Client was released for on-premise as well. Oracle Database 18c, the latest generation of the world’s most popular database, is now available in Oracle Cloud and on Oracle Exadata. It provides businesses of all sizes with access to the world’s fastest, most scalable and reliable database technology for secure and cost-effective deployment […]

Read More

Manual Failover in Data Guard

We understood roles of the database in the previous article and explored SwitchOver of database roles. Manual SwitchOver in Oracle   In this article, we will see FailOver of the Database role. When we have planned maintenance activity we can simply switch roles of Primary and Standby database. But what if Primary Database crashes and […]

Read More

Manual SwitchOver in Oracle

Let us understand today whole switchover the scenario in Oracle Data Guard. I have written many articles of Oracle Data Guard that explains the architecture of Oracle Data Guard, Benefits of having Data Guard as your DR solution, different methods of creating Data Guard. Today, we will see How your database works before switchover after […]

Read More

Changing Protection Modes in Oracle

We have seen Protection Modes in depth in my previous Article. To read protection modes in data guard : Protection modes in Oracle Dataguard In this article, we will see changing protection modes . First, we need to decide what protection mode we want in our environment. Which protection mode suits better.What is important for […]

Read More

How to Flush Single SQL Plan out of Shared Pool in Oracle

Todays let ‘s have look at the query which we use to resolve this issue ” How to Flush Single SQL Plan out of Shared Pool”.      Find the address and the hash value SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID=’495fdyn7cd34r’; ADDRESS HASH_VALUE —————- ———- 00000005ODJD9BC0 247122679 Execute the purge procedure SQL> exec […]

Read More

Check Materialized View Refresh Schedule in Oracle

This post is about the view which we use in Oracle. What is  Materialized View? The view which we use to make a replica of a target master from a single point in a time is known materialized view. As we know why do we need materialized view in Oracle? redesign the system and eliminate those […]

Read More

Startup Procedure in Oracle

We are going to have look at the most basic but most important part of Database. It is the first step of Database. We can call it initial stage of Database. Let’s have look at this image. It indicates some hidden simple and most meaningful message. Ladders are to meant to climb only it shows we […]

Read More

Progress status of index rebuild in Oracle

  The game never ends after the creation of anything. It starts when it comes to the phase of maintenance. Today we are going to have look on the query which is used to look “Progress status of index rebuild/creation or long operation”.      Let’s have look on the query. select sid, target, to_char(start_time,’hh24:mi’) start_time, elapsed_seconds/60 elapsed, […]

Read More

Change User Password in Oracle

In the world of technology, we use “USERNAME and PASSWORD “ multiple time in a day. As per nature, rule “CHANGE “is a must.  Oracle Database also provides the option to change user’s password. The only superuser has a privilege to change the password. Let’s have look at the steps which we use to change the password. The […]

Read More