I would like to be able to analyze large PL/SQL code base to identify internal PL/SQL subprograms called in PL/SQL application code. I know that I can get package level dependencies with DBA_DEPENDENCIES and that PL/Scope should give subprograms level information. But I cannot ma...

Hello Connor/Chris, Hope you are doing well. Recently, I came to know about the PART_NAME parameter for multiple APIs of DBMS_REDEFINITION package from the documentation. However, I could not find much about what kind of changes are permitted (and prevented) at partition level, e...

Hi Tom How do I confirm that the following event has been set: SQL>alter system set events '12899 trace name errorstack level 3'; ? ORA-12899 has occured after the event was set but no trace file is found in the udump catalog. The event was not set by me and I am trying to confir...

HI TOM, Tnx for this oppurtunity again, Can You explain how does the ORA-4068 occurs and how can I go about it? How does oracle manages the freelist (8i) on LMT's? And how can we track the freespace, used space, and fragmentation on LMT's? What's the difference between creating t...

Hi, I have created an application that is tracking a set of processes that are being run from a master table. When a process is completed, a flag in a column name PROC_EXEC_STATUS changes from N to Y for each process. I want my oracle apex application to refresh when the flag for...