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 […]
All posts by Anuradha Mudgal
Anuradha Mudgal
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’; […]
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 […]
Progress status of index rebuild in Oracle
The game never ends after the creation of anything. It starts when it comes to the phase of maintenance. Today we are going to have look on the query which is used to look “Progress status of index rebuild/creation or long operation”. Let’s have look on the query. select sid, target, to_char(start_time,’hh24:mi’) start_time, elapsed_seconds/60 elapsed, […]
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 […]
Find users with DBA privilege in Oracle
Being Oracle DBA we are aware that Oracle provides lots of views and parameters which helps DBA a lot to maintain the database. In this article, we are going to know about the user’s privilege. We may find that different users have different permissions in the database. Let’s have look at the query which we use […]
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: select index_name name,’No Partition’ partition,’No […]