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

Find users with DBA privilege in Oracle

Being Oracle DBA we are aware that Oracle provides lots of views and parameters which helps DBA a lot to maintain the database. In this article, we are going to know about the user’s privilege. We may find that different users have different permissions in the database. Let’s have look at the query which we use […]

Read More

Logical Standby Database Creation

In the previous article, we have seen Preparation and consideration we need to see before creating Logical Standby Database. Preparing to Create a Logical Standby Database We can use following steps to create Logical Standby Database. Prerequisites : Physical Standby database already created. Step 1: Check Physical Standby Database is created and is synchronized with […]

Read More

Lock and unlock statistics on a table in Oracle Database

Today we are going to have a look at steps we use for lock/unlock statistics on a table. In the world of technology, we all love to work with one click. The way we DBAs would like to work in the same tradition as we know sometimes we may not want to analyze a table automatically […]

Read More

Bypass the AFTER LOGON trigger in Oracle Database

Today we are going to have to look on “Bypass the execution of the AFTER LOGON trigger“. Problem: You might have AFTER LOGON trigger for auditing and because of faulty logic (infinite loop) or the space in auditing table is full or some other problem connected to trigger, no users are able to connect to […]

Read More

Setting NLS_LANG variable in Oracle Database

Today we are going to have look at a different topic of Oracle Database. As we all are aware that language is the most important and common element which we use in daily life. We can find the different county with different language. For more friendly nature oracle provides a parameter by which we can set language and […]

Read More

SQL Loader in Oracle

Today we are going to learn about “SQL Loader”. The journey of Oracle Database does not end here.  Let’s have look at the technical definition of SQL Loader. what is SQL Loader? The primary method for quickly populating Oracle tables with data from external files is called SQL*Loader. From its powerful data parsing engine that puts […]

Read More

HOW TO CONVERT SCN TO DATE AND DATE INTO SCN

Being DBA, we all are well aware SCN. We all known about it’s important. SCN is the most important element of Oracle Database. It helps DBA in the Recovery Database.       Database SCN number some time is very important 1) Particularly when you are doing rman recovery 2) Filling gaps of archive logs between the primary […]

Read More

Archivelog in Oracle Database

Today we are going to learn about the most important element of Oracle Database which come’s much important after it’s backbone.Being Oracle DBA we must aware of Archive logs.Now we are going to have look at the technical definition of archive log. An archived redo log file is a copy of one of the filled members of a […]

Read More