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…
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…
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,…
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…