Background REST Service Access with A-Team Mobile Persistence Accelerator

REST service transfers light data, but service execution time could bring significant delay to the enterprise mobile application. I have already introduced you to the A-Team Mobile Persistence Accelerator (AMPA) in previous post - REST Service Access with A-Team Mobile Persistence Accelerator. Based on AMPA author - Steven Davelaar suggestions, I will post today updated application, where REST service call will be handled in background. This will allow mobile user to continue working with the (more...)

HP Mini T210 3F0 boot failure and System Rollback Data disk space issues with Roxio BackOnTrack / aswrvt.sys

If you have an HP Mini 210 or 100 and have had issues with disk running out of space, failures to boot, I feel for you. After a heap of hassle, I sorted my out problems without having to reinstall Windows, and so I'm sharing my experiences as I found many many people with the same issue, but no central resolution. The issues I've had are as follows

  • Failure to boot: 3F0 Harddisk does not (more...)

Proper Preparation Prevents Piss Poor Performance – my tale of woe


Not really an excuse but when it is your conference, you don't have time in the run up to 'polish your slides', so my top tip, Never agree to a new presentation at you own event, stick to one you are happy with so you can simply switch on the projector and go.

Great advice, wish I had listened to it.

Thursday in Ireland I had two presentations, the first was a great slide (more...)

What’s this ‘WHERE 1=1′?

Since some time I have been adding WHERE 1=1 to all my queries.
I get queries like this:

SELECT *
  FROM emp e
 WHERE 1=1
   AND e.ename LIKE 'A%'
   AND e.deptno = 20

Lots of people ask me what’s the use of this WHERE 1=1.

You know I like to type as little as possible but here I am typing a lot of extra characters. And yet, it makes my development life a (more...)

Oracle Database Transactions and Locking Revealed, by Tom Kyte and Darl Kuhn

I recently came across the book called “Oracle Database Transactions and Locking Revealed” by Tom Kyte and Darl Kuhn. Usually, any new book by Tom Kyte is a big deal and acquires a huge following very quickly. Strangely enough there was only a single review on the Amazon, before I added my own.

For the reasons unknown to me, this book is literally ignored. I haven’t seen posts on the oracle-l about it, on the (more...)

apex.oracle.com has been upgraded to a pre-production version of Oracle APEX 5.0

If your an Oracle APEX developer you will want to try http://apex.oracle.com.  We have just upgraded this free service to a close (but not yet) production version of Oracle APEX 5.0.  If you already use apex.oracle.com login and validate your applications work as before.  If you don't have an account create one; it should take less then a minute.

Oracle APEX 5 has a new feature called "Universal Theme".  A (more...)

PostgreSQL Hints and DBMS_STATS

For those who don’t know,‭ ‬it is now possible to use hints on PgSQL.‭ ‬Here
is how things work:

-‭ ‬Download and install the extension from the home page:

‭  ‬http://sourceforge.jp/projects/pghintplan/

If you are using Red Hat derivative,‭ ‬like me,‭ ‬it’s a simple RPM package.‭ ‬Check the content of the package,‭ ‬like this:

[‬mgogala@pg91‭ ~]‬$‭ ‬rpm‭ ‬-qa|grep pg_hint

pg_hint_plan93-1.1.3-1.el6.x86‭_‬64‭
[‬mgogala@pg91‭ ~]‬$
‭[‬mgogala@pg91‭ ~]‬$‭ ‬rpm‭ ‬-ql pg_hint_plan93-1. (more...)

Re-Creating Datafiles When Backups Are Unavailable

I found an old copy of the Oracle 9i User-Managed Backup and Recovery Guide and read the following:
 
If a datafile is damaged and no backup of the file is available, then you can still recover the datafile if:
 
·         All archived log files written after the creation of the original datafile are available
·         The control file contains the name of the damaged file (that is, the control file is (more...)

TNSNAMES.ORA Learning

If I have an alias entry named “TEST1″ in tnsnames.ora twice with different descriptions, which one will Oracle*Net use when connecting to database? What if the duplicate alias entry is in the IFILE referenced from tnsnames.ora – which entry will be used? In my tests, Oracle*Net reads the tnsnames.ora file from bottom up. So if there […]

Join Tables on Date Ranges

A recent question on the OTN SQL forum asked how best to join two tables related by ID and date range, in order to insert one row per date into a data warehouse. One solution was to expand the data from each table, creating one row per date, then join on date. I think it's more efficient to join on date range, then expand.

OUG Ireland 2015 : The Journey Home

After saying a quick goodbye to everyone, I got in a taxi and headed for the airport. I was a little on the early side, but as I’ve said before, it’s better to be early than late where airports are concerned. I wanted do have a Guinness in the bar in the airport, like I did with Patrick Hurley last year, but the queue was too long, so I settled for an authentic Irish diet (more...)

OUG Ireland 2015 : The Event

Having got to OUG Ireland, here’s what happened…

The first session I got to see was Nikolay Kovachev from TechnoLogica speaking about “12c PDBs, Snapshots & Change Management”. Bulgaria in da house! The session started with an intro to ZFS (snapshots, copy-on-write (COW), clones), then a quick intro to the Oracle multitenant architecture. From there it was on to PDB snapshot cloning using ZFS. Because of the ZFS COW functionality, this is really quick. (more...)

OUG Ireland 2015 : The Journey Begins

The day started early, about 1 hour before my alarm in fact. I got up, lay in the bath for a while drinking a can of Monster and considering the day ahead, got out of the bath, puked, then got my shit together ready for the taxi. I’ve been ill this week. That combined with sleep deprivation, nerves and the Monster kinda turned my stomach.

The taxi ride to the airport was really good. The (more...)

WHEN OTHERS … sometimes just not enough

We currently are working on a bug with Oracle Support with dbms_stats in 12.1.0.2.

That may be the subject of a latter post, but in a nutshell, here’s the issue

SQL> exec dbms_stats.gather_table_stats('MY_SCHEMA', 'MY_SCHEMA');
BEGIN dbms_stats.gather_table_stats('MY_SCHEMA', 'MY_SCHEMA'); END;
 
*
ERROR at line 1:
ORA-21700: object does not exist or is marked for delete

Now obviously that’s not meant to be happening, and it pertains to incremental stats on a database (more...)

Oracle Priority Support Infogram for 19-MAR-2015


RDBMS

A new blog I’ve never seen before, Emre Baransel, Support Engineer's Blog, looks good and hands-on. Here are some links:




MySQL

Two from MySQL Enterprise Backup:



Java

WebSocket Client API – Java 8, from Pavel Bucek’s Blog.

Update a grails project from version 2.3.8 to version 2.4.4

At first I changed the version of the application to 2.4.4.
> grails set-grails-version 2.4.4

I also created a new appliction with grails 2.4.4. From this application I took the BuildConfig.groovy and copied the content into to the BuildConfig.groovy of the application I wanted to update. Then I added the changes to the BuildConfig which  are necessary for the application.

In the datasource of the application I (more...)

Might need to use Tunneling with Discoverer 11g

I have noticed a few instances recently of Discoverer 11g Plus failing to open or taking an awful long time to open. In both of the cases where this has been reported to me by my clients, changing the plus communication protocol from Default to Tunneling did the trick.

To enable tunneling for use with Discoverer Plus, use this workflow:

  1. Launch Enterprise Manager using something like: http://server.domain.com:7002/em
  2. Enter your Username and Password. Username (more...)

An Irish Blessing (for my friends at #OUG_IRE)

Maybe a day or so late (for St Patrick’s Day) but a bunch of my Oracle pals (#ACEs and #ACEDs) are all over in Dublin at an Oracle User Group event (#oug_ire on Twitter) so this seemed appropriate. Looks like they are having a good event (based on the tweets), with a fun evening to […]

The Secret Feature of Bucketsets in Oracle Business Rules

In Oracle Business Rules one can use so-called "Bucketsets". I never liked the term as it is not in the dictionary (did you mean bucketseat?), and never understood what is wrong with "list of values" (LoV) as that is what it is.

See for example the following bucketset that defines a list of values to be used for some status field:


Anyway, bucketsets are typically used in decision tables to define the set (more...)

Time to Update the Feed

For those of you who enjoy our content via the feed (thank you), I have news.

Next week, I’ll be changing the feed’s name, so if you want to continue to receive AppsLab goodness in your feed reader of choice or in your inbox, you’ll need to come back here and subscribe again.

Or maybe it’s time to switch over to our Twitter (@theappslab) or Facebook Page, if that’s your thing. I did nuke (more...)