APEX – Dynamic Actions with trigger conditions

Dynamic Actions making the difference! This marketing slogan belongs to the fact that the quality and usage of dynamic actions in your application influencing the user experience a lot. It helps to improve the functionality and let the users believe, that they work with a desktop application instead in browser window. Someday ago I’ve tried…

Read More… on APEX – Dynamic Actions with trigger conditions

Get latest data record

Sometimes I have a request to search within a table find out for example when a server delivered his data last time. Here some sample data. As you maybe recognize for some days some servers have not delivered any data: With following SQL which use analytic function, you’ll find the latest data for each server…

Read More… on Get latest data record

Instance Caging

Since Oracle Database 11g Release 2 there is a feature called “Instance Caging” managing and limiting the number of CPUs used by a database. This feature is very helpful if you administrating a RAC cluster and want to limit the CPU-resources per databases. Comparing to the “normal resource manager-way” where you define a percentage value…

Read More… on Instance Caging

Securefiles

I’ve faced the task to create a daily job which generates a CSV-files and store it for an an indefinite period in a table. As you know CSV-files are not the tiniest ones and “indefinite period” could be result into “ORA-01653: unable to extend table YYY by 128 in tablespace XXX“. So I’ve looked deeper…

Read More… on Securefiles

First Post

This is my first blog post. This blog will deal with several topics about the Oracle universe. As you maybe noticed from the blog heading, most articles will describe my daily work with oracle technologies like Oracle Database, Oracle APEX or interesting SQL-stuff. I thought it makes sense to share my thoughts and provide some…

Read More… on First Post