New feature in Oracle 11g database to kill session

Now we can kill session after finishing existing transaction to be finished. Means in previous release there was no scope to finish on going transaction. Instead of “alter system kill session” here we can use “alter system disconnect session”. Using syntax “POST_TRANSACTION” we can kill session for active transaction has to be completed first and […]

Read More

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

Read More

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

Read More

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.

You will see mview refresh job […]

Read More

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

Read More

Fix Invalid Or Unusable Index in Oracle

Being Master of RDBMS world. We must aware of Index on the database. Indexes play an important role in the life of Database management.  Today we are going to have look at the steps which we use to “Fix Invalid Or Unusable Index“. Let’s have look at the steps. Check Unusable or Invalid Index:

Rebuild […]

Read More

Apply Patch without shutting the Database

Most of the time, we can shut down the database and listener for patching the database home. But there is a method to apply the patch without shutting down the database and listener. Checking the database and listener running

Checking the lsinventory

Now, we can apply the patch

Again, check the lsinventory […]

Read More

Network link in expdp

The export operation is performed with data that is consistent up to the specified SCN. If the NETWORK_LINK parameter is specified, then the SCN refers to the SCN of the source database. Follow following steps to the export database using network-link. Source database: demo Target database: uat Database platform : 11.2.0.4.0 Step 1 : Create a tnsnames.ora […]

Read More

ORA-30032: The Suspended (Resumable) Statement Has Timed Out

PROBLEM: While doing a transaction, it was hung for few seconds and got the below error. SQL> create TABLE TEST_3 as select * from dba_objects; create TABLE TEST_3 as select * from dba_objects * ERROR at line 1: ORA-30032: the suspended (resumable) statement has timed out   CAUSE & SOLUTION: Let’s check the alert log: […]

Read More

Generic error(Failed Jdk Version Is Incompatible.Please Use A Jdk Version With Opatchauto)

While running the opatchauto command in oracle grid you may face the jdk version error as below. We are going to learn about the steps which we use to solve this issue. root # /crsapp/app/oracle/product/grid12c/OPatch/opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -analyze -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp  OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI […]

Read More