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, […]
Articles Tagged: Oracle
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 […]
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 […]
Fix Invalid Or Unusable Index in Oracle
Being Master of RDBMS world. We must aware of Index on the database. Indexes play an important role in the life of Database management. Today we are going to have look at the steps which we use to “Fix Invalid Or Unusable Index“. Let’s have look at the steps. Check Unusable or Invalid Index: select index_name name,’No Partition’ partition,’No […]
Preparing to Create a Logical Standby Database
Prior to that, we need to create the Physical Standby. Logical Standby Database : SQL Apply Architecture We need to perform following steps before creating Logical Standby Database : 1. Primary Database must be in Archive log mode. Check your database is in archive log mode or not. If not enable it for archive log. […]
Lag in an Active Data Guard Configuration
Oracle 11g comes up with a New Feature on Oracle Data Guard that is Active Data Guard. In Active Data Guard we can use a real-time query on Standby Database and can gain benefits by offloading read-only workload to Standby Database. To know more about Active Data Guard Oracle Active Data Guard Overview and Architecture […]
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 […]
Managing Role in Oracle
Today we are going to have look at Role in Oracle database. It is the most important part of Oracle database. User Privileges and Roles is the most common task that is performed by Oracle DBA. With roles and privileges, we can easily point out which user has what responsibilities in databases. Let’s […]
OCM 12C Journey
I wrote two OCM exams back to back because I wanted to write 2-days OCM 12C exam but there was no schedule in India for 2-days OCM 12C exam, So first, I wrote 2-days OCM 11G on 9th & 10th April and then I wrote an exam of OCM 12C Upgrade on 23rd April in […]
Create Standby Database using duplicate database for standby RMAN command
We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides. In this article, we will see Physical Standby creation using RMAN duplicate database for standby command. Note: For this process, we need to copy password file from primary side to standby side under $ORACLE_HOME/dbs Database Detail : Connect to Primary Database […]