Advantage Of RMAN in Oracle

This post is for those who are new in “Oracle RDBMS”, Being a part of Oracle technology in Database. “RMAN” plays an important part in “Backup&Recovery”. “RMAN” has its own benefits. Let’s have looked over the “RMAN” benefits.     RMAN helps to DBA have incremental where only modified data blocks will be copied It integrity checks for the […]

Read More

Feature Enable In Oracle

Note: Just illustration for fun It in fact violates the license. This is only study purpose. All Features are enable in EE (Enterprise Edition). Actually some features not enabled, if you are using Oracle SE (Standard Edition). Follow the point to see the feature is enable or not in  (SE) . In my case 1. […]

Read More

How to connect to ASM Instance Remotely

Today we have looked over ASM Instance Remotely. We can see that the normal instance of RDBMS is different from ASM. Connect to ASM Instance Remotely Being DBA we are aware that By Default Oracle ASM don’t allow remote sysdba connection since ASM instance is in NOMOUNT state. You Might get ORA-12528: TNS:listener: all appropriate […]

Read More

Writing data into OS text file from Database Using UTL_FILE

Today we are going to have a look at “how to write data into OS text file from Database Using UTL_FILE?” In the journey of DBA sometimes in some cases, we need to perform this activity. To prepare every time to let’s have look on the post. Before we start it we must know what does UTl_File […]

Read More

Read Alert log from x$dbgalertext in Oracle

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 […]

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

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

License High Water Mark in Alert Log

License High Water Mark in Alert Log The message was originally intended to let you know the maximum number of users sessions were used between bounces so that you could check this against how many sessions you were licensed for.

You can query the V$LICENSE data dictionary view for the high water mark, it […]

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