I will explain the DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error in this post. let’s review the DDL_LOCK_TIMEOUT Parameter | ORA-00054: resource busy error.
Read More »Oracle
PostgreSQL – How to Eliminate Repeated Values
It’s possible that in a table, some field that has repeated values is necessary to leave it as unique. And how to proceed with repeated values without eliminating them all? …
Read More »Benefits of having a tool to monitor your SQL server
Effective, persistent monitoring of your SQL server is essential, but unless you understand the reasons behind this, you might not be adequately concerned with fulfilling your maintenance duties. To remedy …
Read More »Uninstall SQLT or Drop SQLT ( SQLTXPLAIN ) in Oracle
Hi, I will explain how to uninstall SQLT or Drop SQLT ( SQLTXPLAIN ) in Oracle.
Read More »How to Deinstall or Cleanup Grid Infrastructure ( RAC ) in Oracle
Hi, I will explain How to Deinstall or Cleanup Grid Infrastructure ( RAC ) in Oracle in this post.
Read More »Convert Single Instance Oracle Database to Oracle RAC
Hi, I will explain How to Convert Single Instance Oracle Database to Oracle RAC in this post.
Read More »How to set LOCAL_LISTENER using Alter System Set Command in Oracle
Hi, I will explain How to set LOCAL_LISTENER Parameter in Oracle using alter system set command in this post.
Read More »Is it Possible to Remove Duplicates of Thunderbird Files?
Thunderbird is a free email application that is loaded with incredible features. It protects you from email scams, allows you to set up a mail account wizard, has a one-click …
Read More »Purge RecycleBin in Oracle
Hi, I will explain Purge RecycleBin in Oracle in this post.
Read More »How to Move Lob Segment and Lob Indexes to Another Tablespace in Oracle
Hi, I will explain How to Move Lob Segment to Another Tablespace in Oracle in this post.
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial