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 […]
Category: ORACLE DATABASE
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 […]
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 […]
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 […]
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. [root@localhost ~]# cat /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log |grep high License high water mark = 169 You can query […]
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 […]