This Post is about the trick by which we can use to monitor the CRDs of Oracle Database. Monitoring is the most important and common task in RDBMS. Without monitoring CDR Let’s have look on the query which we use to monitor main elements of Oracle Database CDRs. — MAXDATAFILES Select ‘MAXDATAFILES ‘ || records_total […]
Articles Tagged: Oracle
Step by Step Creation of Cascading Standby
Cascading Standby Database works in two layers. As per normal the standby configuration, standby database receives redo from the primary database. In Layer 2 standby database will receive redo from another standby database rather than directly from the primary database. With Cascading standby database we can minimize the load of Primary Database. As per Oracle […]
Using the RMAN Recovery Catalog in a Data Guard Configuration
Recover Catalog: A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. Benefits and Restrictions of RMAN in DataGuard In easy words, RMAN metadata is stored in a different database instead of the control file. That database works as a repository. Recovery catalog and data guard : Use of the RMAN recovery […]
Benefits of Using Data Guard Broker
Oracle Data Guard Broker automates configuration and monitoring tasks for data guard. Data Guard Broker Architecture With Oracle Data Guard Broker we can enable FAST_START FAILOVER which helps in case of crash scenario or inoperativeness of production, it directs Primary Database role to standby database in this scenarios. It provides simplified switchover and failover operations. […]
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 Flush Single SQL Plan out of Shared Pool in Oracle
Todays let ‘s have look at the query which we use to resolve this issue ” How to Flush Single SQL Plan out of Shared Pool”. Find the address and the hash value SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID=’495fdyn7cd34r’; ADDRESS HASH_VALUE —————- ———- 00000005ODJD9BC0 247122679 Execute the purge procedure SQL> exec […]
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 […]
Startup Procedure in Oracle
We are going to have look at the most basic but most important part of Database. It is the first step of Database. We can call it initial stage of Database. Let’s have look at this image. It indicates some hidden simple and most meaningful message. Ladders are to meant to climb only it shows we […]