I’ve been aware of some of the ways that Oracle database optimises index accesses for queries, but I’m also aware that you have to test each critical query to ensure that the expected optimisations are taking effect.
I had this simple query, the requirement of which is to get the “previous status” for a record from a journal table. Since the journal table records all inserts, updates and deletes, and this query is called immediately (more...)
Johan Louwers shares a how-to on his blog showing you how to connect Oracle Developer Cloud Service to send notification to the popular Slack collaboration tool.
You can use similar steps to hook DevCS to other collaboration services such as hipchat and Oracle Social Network.
I don’t know about you guys but as we’ve doing more and more upgrades to 12c we’ve been seeing some bugs creeping up. So in hopes to assist in how to manage these bugs, we will be producing more posts to try to help you guys out. Thanks to Jan-Peter AuraPlayer’s Form’s Rockstar for leading the charge!
One thing we saw today in a few customers, was a strange crash that happened sometimes at runtime (more...)
Today everyone got the very scary news that Firefox will no longer support Java applets. Well guess? It’s not news at all!
It’s just another attempt to scare poor Form’s users into to getting them to do a million dollar multi year migration project. Well have no fear, because we have found not one BUT two very simple ways for you to continue to work with Forms for the year to come without worry.
At 9:00 AM I had no problems starting my Forms-Runtime. Firefox 51.0 was the actual version at that point.
After lunch and restarting my Firefox I was running 52.0 with the new feature "no JAVA please" :-)
Very bad is, that firefox didn't give you any hint, when starting a Forms-URL. The only thing you see is an empty screen.
AuraPlayer has been pretty busy working on new groundbreaking solutions and we can’t wait to show you!
We developed a new version of our product that can create microservices from Peoplesoft and JD Edwards applications. If you’re challenged on how to mobilize your existing systems and want to try a breakthrough solution for fast mobilization, we’d be happy to have you see what we can do in our Beta testing program! All you would need (more...)
It is a very common requirement. You need to be able to log the start and end of procedure and function calls. You also need to log error and exception events and sometimes some informational messages as well. This is typically done by writing a simple logging package that uses autonomous transactions so that any transaction rollback does not rollback the diagnostic logging information as well. Apart from logging text (and usually other things as (more...)
- Java 8: Java 8 in JDBC/UCP and OJVM; JDBC 4.2
- Performance: JIT (OJVM), Network Compression over WAN (JDBC), Configurable connection health check frequency (UCP), PL/SQL Callback interface (JDBC)
- Scalability: Shared Pool for Multi-Tenant Database (UCP), Shared Pool for Sharded database (UCP), Sharding Key APIs (JDBC, UCP), DRCP (more...)
My three year old approached me with her bottle of milk and requested more, insisting it was empty.
|Exhibit A - One non-empty receptacle|
I assessed what was presented to me:
- There was milk in the container
- The straw reached the current milk level
- The straw was not blocked (I didn't feel like milk. I (more...)
- Online Statistics Gathering: seit Oracle 9 werden die Statistiken für Indizes im Rahmen der Anlage eines Index automatisch erfasst: da in diesem Zusammenhang ohnehin ein Full Scan der Daten und Sortierungen erforderlich sind, kann man die zusätzliche Erfassung der Statistiken problemlos in die Operation integrieren. Mit Oracle 12c wird diese Technik jetzt auch für (more...)
If you have an Interactive Report with the Subscription feature enabled, users can “subscribe” to the report, getting a daily email with the results of the report. Unfortunately, however, this feature doesn’t work as expected if it relies on session state – e.g. if the query uses bind variables based on page items to filter the records. In this case, the subscription will run the query with a default session state – Apex doesn’t (more...)
We came across a use case where the Oracle Developer Cloud Service was being used to build a zip archive and then the requirement was to upload this zip file on GitHub from Developer Cloud Service for a public usage. This blog will help you understand how to push an artifact generated on Developer Cloud to GitHub repository.
Prerequisites for GitHub:
- To have a valid GitHub account.
- Have created a GitHub repository, (more...)
The EasyGUI library is a nice tool for developing GUI applications. It doesn’t require you to know event-driven programming to write basic GUI applications because it’s based on Python functions.
You can download and install the EasyGUI library with
yum utility like this:
yum install -y python-easygui
It should generate the following list:
Loaded plugins: langpacks, refresh-packagekit mysql-connectors-community | 2.5 kB 00:00 mysql-tools-community | 2.5 kB 00:00 mysql56-community | 2.5 kB 00:00 (more...)