I’ve been using Power BI for a couple months now, not as a developer, but as a system architecture. I may not deal with dashboard and report development on a daily basis, however, I, as an end user, use Power BI extensively to monitor Azure and Power BI usage including audit and billing. I would …
Validate Performance Improvement Using Query Folding Feature in Power BI Read More »
This post is just a quick note to myself on how to configure JBDC on Oracle Enterprise Data Quality (OEDQ) to connect to different databases. First let’s talk about connecting to Oracle database. By default, OEDQ’s Data Store can only connect Oracle database by SID, but not by Service Name. Fortunately, the JDBC connection …
Installation Install the Oracle Database Gateways 11g R2 (11.2). See the screen snapshots of the installation here. Configuration During the installation, the following+ default initialization parameter file is created: [ORACLE_DG_HOME]\dg4msql\admin\initdg4msql.ora dg4msql = Database gateway for Microsoft SQL Server. If you choose a different database option, use the appropriate path name. Copy initdg4msql.ora to a new …
The LAST_REFRESH_DATE column of the DBA_MVIEWS or the LAST_REFRESH column of the DBA_MVIEW_REFRESH_TIMES indicates the start refresh time. But what if we’d like to find out how long the refresh of the materialized view really takes. Well, we can query the DBA_MVIEW_ANALYSIS. For Complete Refresh, the refresh duration will be in the FULLREFRESHTIM column of …
How long did Oracle materialized view refresh run? Read More »
When you have multiple Oracle APEX environments, e.g., development, test, UAT and production, and for multiple groups, one of the confusing things is that sometimes developers are lost on which environment they’re working on. Most of technically proficient developers can make a distinction easily from the URLs they’re currently using. However, most of less technically …
Customize/Personalize Oracle APEX Workspace Environment Read More »
Oracle Real Application Cluster (RAC) becomes the technology of choice for highly available and highly scalable deployment of enterprise Oracle database environment. With its innovative technology it comes with no surprise its complexity. The complexity is not only with the underlying database technology itself, but also how well you design and implement it to work …
