When using Oracle APEX hosted externally, such as on Oracle Cloud, if your application includes sending an email notification with embedded images from linked images, the image may look broken, as seen below. Based on the warning message, the embedded image’s host, which the email is referring to, is not on the safe list. Obviously, …
Embed images in the email when sending it from the Oracle APEX Application Read More »
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 »
Oftentimes we all run into the situation where the file system is full (or almost full) and need more space. This expansion task seems to be a lot easier when using the Logical Volume Manager (LVM) in Oracle Linux. Review the current size. [root@ol6 ~]# df -H Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_ol6-lv_root …
Resizing the filesystem using Logical Volume Manager within Oracle Linux 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 …
We’re working on the installation scripts for an internal PL/SQL applications. Multiple scripts are called from the main one. To capture errors from script execution, normally the spool syntax will be used in the scripts to pipe out all executions into log files, and then later the deployment team members will examine them using find/search …
Oracle 11g Release 2 for Windows was just released this month. With the availability of the grid infrastructure in this version, I plan to install it on my Windows 7 desktop to see what it can do even if it is just on stand alone environment. In order for database to use Automatic Storage Management …
Install 11g Release 2 Grid Infrastructure for Standalone Server on Windows 7 for Sandbox Read More »
