Dear Readers, Trust you are doing well, Today I am writing this post related to recent issue which I faced after DB upgrade to 19c. We saw sudden increase in waits for event “Enq: HW – contention” wherein HW stands for High Watermark not Hardware 😉 Lets start with some […]
Dear Readers, Recently I was working on one of the projects wherein a requirement was to compare two DB schemas (Both structure and data) & synchronize it. Requirement was as follows: Current application version is 1.0. It is using schema S_APPS in Oracle database as a backend. New upgrade pack […]
Does a delete on a table with where condition requires select privileges along with delete on a table???
Dear Readers, Trust you are doing well. Today I am writing about an interesting issue which we faced today. The application team did complain about one of the job failure with error “ORA-01031: insufficient privileges” while running delete statement on one of the table: Ofcourse first check I did was […]
Dear Readers, I have published two more articles on KT EXPERTS. This articles focuses on new DB features that have been introduced in Oracle 18C along with its significance. Oracle 18C new feature: Cancel SQL instead of killing session Oracle 18C new feature: Schema Only Account Hope u will find […]