Skip to main content

Posts

Getting Started with DBMS_PROFILER in Oracle Database

Oracle PL/SQL · Performance Tuning What is DBMS_PROFILER ? An interface to profile existing PL/SQL applications and identify performance bottlenecks - collecting and persistently storing granular execution data at the virtual machine level. Overview DBMS_PROFILER provides an interface to profile existing PL/SQL applications and identify performance bottlenecks. It lets us collect and persistently store profiler data. The profiler gathers information at the PL/SQL virtual machine level , including the total number of times each line has been executed, the total time spent on that line, and the minimum and maximum execution times for each line. Data Tables Table Name Description PLSQL_PROFILER_RUNS Metadata per run (run ID, owner, date, comment, total time) ...
Post a Comment
Read more
Recent posts

Interactive Grid Tips (Part-1)

Selection Toolbar Events Validation Styling Advanced Selection 1 Get Selected Row Primary Key Return selected row PK values to a page item. Two approaches depending on APEX version. Selection APEX 24.2+ Before 24.x Copy // Initialization JavaScript Function function (options) { options.defaultGridViewOptions = { selectionStateItem: "P22_SELECTED_IDS" }; return options; } Copy var ig$ = apex.region( "EMP" ).call( "getViews" , "grid" ); var model = ig$.model; var selectedIds = []; ig$.view$.grid( "getSelectedRecords" ).forEach( function (rec) { selectedIds.push(model.getValue(rec, "EMPNO" )); }); $s ( "P22_SELECTED_IDS" , ...
1 comment
Read more

Dynamic Column Labels in Oracle APEX Interactive Grid Using Page Items

Dynamic Column Labels in Oracle APEX Interactive Grid Using Page Items Oracle APEX / JavaScript  ·  Interactive Grid When building data-driven applications in Oracle APEX, column headers sometimes need to reflect dynamic labels rather than hardcoded ones. This post walks through generating column names from a page item value. The Requirement The goal was straightforward: an Interactive Grid whose column headers are generated dynamically based on a page item, updating both on page load and whenever the user changes the item value manually. The page item P24_LABEL_ITEM holds a range string in this format: RESULT1-RESULT5 This means the grid columns should be labeled RESULT1,RESULT2, RESULT3 ... RESULT5 sequentially — without any hardcoding in the region or column settings. The JavaScript Solution Place the following code under Execute when Page Loads . The same block can be reused inside a Dynamic Action triggered on...
Post a Comment
Read more

Oracle APEX Calendar Region - Beyond the Basics

This article explains how to build a complete Internal Meeting Scheduler using the APEX Calendar with dynamic UI behavior, registration tracking, and strong business validations. . Oracle APEX PL/SQL JavaScript Calendar Region Table of Contents Overview & Features Step 1 — Table Design Step 2 — Calendar Page Setup Step 3 — Calendar Attribute Mapping Step 4 — Filter Control Step 5 — Calendar Customization Step 6 — Meeting Details Popup Step 7 — Registration Handling Step 8 — Add New Meeting Step 9 — Save Meeting Logic Step 10 — Register Button Action Step 11 — Department-Based Styling Step 12 — Business Validations Overview This solution provides a structured and interactive way to manage internal meetings using Oracle APEX. Here are the key capabilities it offers: ...
Post a Comment
Read more