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 […]
Monthly Archives: July 2018
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 […]
Shrink Lob segment in Oracle
Today we are going to have look on “Shrink Lob segment”. Before we start the article we must know about the heading. What does it stands every one must know. Shrinking Segments: Overview Shrinking a sparsely populated segment improves the performance of scan and DML operations on that segment. It resolves mainly two issues:- • Full table scans […]
How to add Datafile in Oracle
Today we are going to learn about modifications of Tablespace. In production Database, we do update tablespace on daily basis. Being a DBA it must be on our key tips. Right decision on correct time is more fruitful. Being DBA our brain must be active about database health on daily basis we must do a modification […]
How to Stop MVIEW from auto refresh
As we are well known that whole technology is getting change towards advancement. All things are working on automatic. Even software works on autonomous. In RDBMS we have a feature to stop automatic refresh MView. Let’s have look how do we stop automatic refresh MView Connect as mview owner. select * from user_jobs where broken =’N’; […]
Prerequisites a Data Guard Broker Configuration
Before configuring Data Guard Broker, following prerequisites must be fulfilled. To know about DG Broker Architecture Data Guard Broker Architecture 1. To configure Data Guard Broker , we need an enterprise edition of a database. 2. We can configure data guard broker on a single instance and RAC [multiple] instance. 3. DG_BROKER_START initialization parameter must […]
Data Guard Broker Architecture
Before understanding, Architecture let us first understand the components of Data Guard Broker. To know more about it Oracle Dataguard Data Guard Components : Oracle Data Guard Broker consists of Client side and Server side components. Client Side Components Oracle Enterprise Manager DGMGRL [command line interface] 2. Server Side Components DMON Process Configuration Files DMON Process […]