- Businesses need data to make intelligent decisions better and faster than their competitors.
- Most of the critical data for businesses runs in enterprise applications and the data has to be extracted and loaded into reporting environments, which are then loaded into large, unwieldy data warehouses.
- Enterprise applications, however, are often overloaded and pegged for performance, with data growing every year and batch windows shrinking due to the need for 24/7 production availability.
- Reporting systems, often (more...)
Well…it was a great day with over 100 people attending.
I had the standard fail of trying to show people 200 things that I think are important, in a time allowing only for 50 things, but better to be overfed than starving
Links to the slides are below. Thanks everyone for coming – hope you had a great day.
There is the Mandel approach to power points in presentations where one is suppose to spend 3 minutes per slide, thus a 60 minute presentation is 20 slides or less.
How about going the other way, showing 3 or more slides per minute?
Sound crazy? I like this approach. It’s the median between a film and a speaker with no slides. I like visuals in presentations and too many words tend to overwhelm me and (more...)
As I recently blogged, APEX Evangelists is undergoing a transformation (stay tuned for what that means for me).
For those of you who don’t know Paul, he started working for APEX Evangelists back in July 2009 (wow time flies!) and has been involved in many client facing projects (and very recently was presented with an award (more...)
At Fishbowl Solutions we’ve been focusing heavily on Mobile solutions over the last 4 years – working on both award winning native and hybrid apps aswell as adaptive and responsive web sites and portals for tablet and mobile devices. Last year we decided to expand our reach with ADF Mobile and Cordova based hybrid applications targeting the WebCenter Suite for Android and IOS (aswell as (more...)
We appear to be hitting this bug on our production Exadata RAC system:
Bug 14383007 – Sort runs out of temp space in RAC even when temp space is available
One particular job errors out with ORA-01652 errors on the TEMP tablespace even though there is tons of free space in the sort segments. So, I got the idea of building a work around to have this job only login to the node that (more...)
Congrats to the WildFly team on releasing their 8.0.0.Final!
For integrating the AeroGear UnifiedPush Server with WildFly only a few steps are required!
First, download and start the server, like:
$WILDFLY_HOME/bin/standalone.sh -b 0.0.0.0
Now you just need to build the
master branch of the mobile push server. For that you simply need to clone the repo:
git clone email@example.com:aerogear/aerogear-unifiedpush-server.git
and build the source code:
cd aerogear-unifiedpush-server (more...)
I’ve been having issues for a long time now with an Exadata RAC database that has user reports experiencing library cache lock waits. The challenge is to figure out what is holding the library cache locks that the queries are waiting on.
My starting point on library cache locks has always been this Oracle support document:
How to Find which Session is Holding a Particular Library Cache Lock (Doc ID 122793.1)
But it (more...)
Every year we at APEX Evangelists come together to discuss the past and the future of the company.
In the past 7 years a lot has changed; the APEX market changed, the community changed, we personally changed, …
We really like APEX, we are all passionate about it, we love to have technical discussions with each other and come together to share our thoughts, but we also like our independence and make our own trade-offs (more...)
Imagine you have a textarea in your app where you want your users to be able to type in large quantities of text, click a button to store this in the database and then later retrieve this large quantity of text and redisplay it in that textarea.
You can’t do this as you would with other page items (i.e. just submit the page and have the values stored in session state). Any value over (more...)
A simple example would be.
Apex Application Process
HTP.p(‘You passed “‘||APEX_APPLICATION.g_x01 ||’” as the value for x01. ‘);
HTP.p(‘You passed “‘||APEX_APPLICATION.g_x02 ||’” as the value for x02. ‘);
HTP.p(‘You passed “‘||APEX_APPLICATION.g_x03 ||’” as the value for x03. ‘);
I wanted to find out if queries against a particular table were experiencing parse time during the week. We had previously seen issues where queries on the table would be stuck parsing for tens of minutes before they started actually running. I think this has been resolved but I’m looking for some validation from ASH. I know that on Sundays we recompress some subpartitions for the table and this leads to higher (more...)
Suddenly a big thunder rolled through the APEX community -> Version 5.0 has arrived in an early adopter version, as published on Joel Kallmans Blog (as usual on a friday, late night over here in europe).
Over the past 10-15 month we saw numerous presentations of what we can expect in APEX 5, and many of us had our own ideas.
As soon as I got word through twitter I applied for a workspace (more...)
As a system grows, it accumulates technical debt – improvements and cleanup that your really ought to get around to doing. However, no-one ever budgets time for this kind of refactoring and cleanup.
The consequence is that any major change opens a Pandora’s box of interrelated problems. I’m involved in a project where we thought we could simply make a minor change to all 2768 tables, but due various historical design decisions over the year (more...)
A coworker of mine cleaned up a bunch of old data to improve performance on an older system of ours and one of the queries started running slower. It looks like the optimizer was choosing a full table scan when an index existed that was much faster. So, I took at look at why it was choosing the full scan and what could be done to get the query to run with the (more...)
http://uptimerobot.com is service that can monitor if you sites are up and running. I have been using it for more than 3 years and it works very well.
The service is free and you can add up to 50 monitors. It is easy to configure a monitor. You don’t have many options, but it can do just what I need.
You can create 4 types of monitors.
- http(s): that’s perfect for website monitoring. The (more...)
Got a massive day of goodies coming to anyone in Perth..for absolutely no cost – just your time and your enthusiasm.
There’s something for
- database developers
- Apex developers
- ADF developers
See you all there …
So…the future is container databases ?
Cool ! I’ll create all my databases as container databases….I’m so happy….until
SQL> CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH; CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH * ERROR at line 1: ORA-65131: The feature Flashback Data Archive is not supported in a pluggable database.
It is documented but seriously….that’s not so flash
Yeah yeah, you can argue with me about backward compatibility, but I’m so glad someone snuck this into 12c…
SQL> grant resource, connect to demo identified by demo; Grant succeeded. SQL> select privilege 2 from dba_sys_privs 3 where grantee = 'DEMO'; PRIVILEGE ---------------------------------------- UNLIMITED TABLESPACE
SQL> grant resource, connect to demo identified by demo; Grant succeeded. SQL> select privilege 2 from dba_sys_privs 3 where grantee = 'DEMO'; no rows selected