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 […]
All posts by Anuradha Mudgal
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 […]
SQL*Plus Customize User Profile in Oracle Database
Being Oracle DBA we all are aware of the relationship between instance and database. Today we are going to have look on “SQL*Plus Customize User Profile“. On daily basis, DBAs works on SQL*Plus at many stages of the database. Execution of all commands on the correct database is the main focus of any DBA. We have to perform multiple […]
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 […]
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 […]
Flashback in Oracle
We are going to have look at another part of the Oracle database. Flashback is going to be the topic of our discussion of today. Let’s start with its introduction after that with its example. Being DBA we have to make us familiar with Flashback technology. It is considered as a good feature of Oracle Database. What is […]
Basic of Data Pump in Oracle
This post is going to explain about the Oracle Data Pump. We may find n number of articles on Google regards, Oracle DataPump. Let’s add one more. Being Oracle DBA we must explore Oracle RDBMS as much as possible to be veteran in our field. Normal water become Lemonade after adding lemon as we can see the […]
Redolog in Oracle
As DBA we are aware that Oracle is a mixture of CRD files. Now we are going to have look at Redolog. Let’s have a technical definition of Redolog. The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as […]
Controlfile in Oracle Database
Today we are going to have look at the most important element of the Oracle Databases.Being Oracle DBA we must have good knowledge about Controlfile. It plays an important role in Oracle Database. If something happens wrong with it we are not able to start our database. Let’s have some important knowledge about Controlfile. Whenever we […]