Problem Statement Recently we have noticed global temporary tables (GTT) with the option “Preserve rows after commit” not working as expected post-migration to oracle 19c with the distributed transaction...
Archive - January 2023
Internet is full of questions and queries about oracle database or DBA(database administrator) interview questions for fresher, intermediate and experienced administrator. There has been multiple blogs available on this but seems...
Problem Statement Sometimes, one may need to invalidate a statement i.e. flush execution plan for a SQL, for example because the current execution plan is not the right one (as consequence of bind variable peeking) and you...
Problem Statement Lately, there have been some questions post upgrading an oracle database from version 12c to 19c and moving to Multi-tenant architecture. One specific question catches attention, where a third-party...
Problem Statement Event Monitor Process in short called as EMON is generally used by oracle to send notification. Often applications uses Database Change Notification process also known as DBCN to be aware of changes in the...
To perform Session Level Tracing alter session set tracefile_identifier='10046'; alter session set timed_statistics = true; alter session set statistics_level=all; alter session set max_dump_file_size = unlimited; alter...