Every Oracle user, customer, administrator, developer or student must have used My Oracle Support (aka MOS) for one thing or another, be it for Service…
Oracle LiveLabs portal is a place for DIY workshop for Oracle’s tools and technologies. It caters a wide variety of labs with workshops for Developers,…
Sangam is the largest independent Oracle users group conference in India, conducted each year by All India Oracle User Group (AIOUG) which is a biggest…
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…
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,…
Alibaba cloud is one of the top cloud service provider in the world right now. They provide many cloud services in IaaS, Paas, SaaS, etc.…