A cursor is a pointer used to fetch rows from a result set. One can think of a cursor as a data structure that describes…
TDE transparently encrypts data at rest in Oracle Databases. It stops unauthorized attempts from the operating system to access database data stored in files, without…
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…
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…
