This is short post I will share the steps involved in deleting not running datapump jobs in oracle databases. First of all we need to…
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…
Continuing my previous posts about cursor sharing and bind peeking, in this post will discuss about Adaptive Cursor Sharing (ACS), which is a mechanism introduced…
In my previous post I shared cursor’s role in SQL execution, and how cursors sharing is useful in case of bind variables. My this can…
In this post will share the steps to add nodes in RAC database deployed in Exadata machine. Environment Details: Total no. of nodes in the…
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…
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,…
Due to a great community we have in oracle technologies, there are n numbers for blogs and articles available on the internet when you need one, but…