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 […]
Author Archive | ittichai
Create Google Tasks by sending email to Google GMail Address
I use Google Tasks for a quick to-do list. It has clean interface and is easy to use. On desktop or laptop machine, it is built-in to Google Mail for a quick access. On smartphones, many to-do apps including Tasks N Todos sync with Google tasks. The neat thing is that in the Google Mail, […]
Resizing the filesystem using Logical Volume Manager within Oracle Linux
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 […]
Customize/Personalize Oracle APEX Workspace Environment
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 […]
Book Review: Android Application Testing Guide (Deigo Torres Milano) by PACKT Publishing
When I was offered to review this book, I was so excited. The topic is probably one of the least popular topics in the Android development circle based on the number of books written on Android. Most of the books in the market tend to cover solely on the area of actual development because it […]
Oracle APEX (Application Express) Built-in LDAP Test Tool Stand-alone Application
Oracle APEX provides multiple ways for authentication. The most commonly used one is the LDAP authentication. Configuring it is very straight-forward in most cases – just providing the LDAP host, port, whether or not to use SSL, and finally the DN string. See here and here for posts about APEX LDAP configuration. Sometime you want […]