In this post will share the steps to add space on local mount point of Exadata DB server nodes using logical volumes. I will use…
Author: Jiten
User registered ORA-00054 (Object Lock) issue while dropping a table. I checked the object lock on database and session details using that object. select c.owner,…
I will start with saying happy new year to anyone who is reading this! This is short post I will share the steps involved in…
PostgreSQL 13 Released on 24 Sep 2020 with significant improvements to its indexing and lookup system, including space savings and performance gains for indexes, faster…
In this short post I will share how you can install guest addition tools after you installed Oracle Linux VM on your virtual box. Before…
When the order of pages in a index does not match the physical order in a datafile, we consider it as fragmentation. This happens in…
If you are in IT industry, you know that cloud computing is the new normal. Whichever IT technology you are supporting Cloud Computing is a…
Previously we discussed how to take encrypted backups in SQL server, in this post will continue the encryption topic and implement Transparent Data Encryption (TDE)…
