This post is small in content but most useful for all DBAs. We are going to have look at the most important part of Oracle RDBMS. Being Oracle DBA we all are well known about alert logs but few of us experts know how to read it. We re being a part of IT basic thing taught […]
Articles Tagged: Oracle Database
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]