A customer called me up and said that he’s hitting “ORA-14766: Unable To Obtain A Stable Metadata Snapshot” and he’s coming up dry on his google search.
This was the first time I encountered this problem, so I thought I’d investigate and write a few words about it, because the problem seems it might be pretty common and the solution was a bit weird.
The customer is using 220.127.116.11 and (more...)
Since the various announcements about NetBeans transitioning to Apache, what's been going on and what's the current status?
Before reading on, take a look at the following:
Well, if you're asking "what's been going on?" it simply means you're not part of the discussion, which is a simple step-by-step process to be part of:
After following (more...)
Linux Container (LXC) management is now often dealt with by LXD, the Canonical lead project built on top of LXC. LXD offers a suite of options for controlling Linux Container resources and setting limits where appropriate. This post will talk about setting constraints on CPU, however other options are available for limiting almost any
Configuration files allow the developer to manage environment specific
values during deployment. FlexDeploy supports the use of these
configuration files and extends them to using tokens in the
configuration file that will get replaced with configured properties
from FlexDeploy. This way we do not need to generate a customization
file for every environment where we are going to deploy the project. We
can have one configuration file that will work across (more...)
Partitioning allows a single database table and its associated indexes
to be broken into smaller components depending on the table and choice
of index partitioning methods. This can sometimes improve performance of large EBS databases significantly. Several E-Business Suite modules take
advantage of database partitioning right out of the box, and custom partitioning is also possible.
Our Applications Performance Group has just released a major update to their best-practices white paper on EBS database (more...)
When dealing with a RANGE partitioned table, the defined partitions dictate all of the data that can be placed into the table. For example, if I have a SALES table as per below
SQL> create table SALES
2 ( cal_year date,
3 txn_id int,
25 partition by range ( cal_year )
27 partition p_low values less than ( date '2000-01-01' ),
28 partition p2000 values less than ( date '2001-01-01' ),
This is still all WIP and if you stay with me, I will provide all the sequences for export and import.
Too much info put in one post.
EXP-10 Usernames Which Cannot Be Exported (Doc ID 217135.1)
Did you know from $ORACLE_HOME/rdbms/admin/catexp.sql there is view EXU8USR providing which schemas will not be in full export?
This looks rather similar to column oracle_maintained from dba_users for 12c database.
Schema bold red will not be (more...)
This is the 53rd edition of my blog series blog series around Stream Processing and Analytics!
From this week onward, I’ll be updating the following two lists with all the presentations and videos I mention each week:
As usual, find below the new blog articles, presentations, videos and software releases from last week:
News and Blog Posts
Are you a member of UKOUG?
How would you like to join the editorial team of Oracle Scene magazine as a deputy editor?
If you are interested we are looking to recruit 1 deputy editor to cover the Applications area and 2 deputy editors to cover the Tech area (DBA, Developer, BA, etc)
How much time is required? about 4 hours per edition, or maybe less.
What does a deputy editor do?
As part of (more...)
Well, not really. If you read my co-worker Gurmeet's Blog, you’ll see the Exadata SL6 is one incredible machine. However, I want to talk about a very important aspect of the Exadata SL6 that I don’t think is getting enough play: its security features.
We’ve been fighting the security battle for years now and it has become a booming business estimated at $445 billion in 2016. You could even say that (more...)
Blogging and long-form content seem so tedious to me nowadays, but if you’ve read here for a while, you’ll recall that I used to post several times a week.
One of the reasons I’ve kept this blog running in the era of ever-shorter content is that it keeps a historical record of this team’s work and our thoughts. As an emerging technologies team, we know that not all our thinking will make it to daylight, so we (more...)
When reviewing Oracle APEX applications I often see hardcoded date or timestamp formats.You can define your date formats in multiple places in your application. In your item or column attributes, as part of your code e.g.TO_CHAR(sysdate, ‘DD-MON-YYYY HH24:MI’) or if you want to make it more reusable you might create a... [Read More
When reviewing Oracle APEX applications I often see hardcoded date or timestamp formats.
You can define your date formats in multiple places in your application. In your item or column attributes, as part of your code e.g.TO_CHAR(sysdate, ‘DD-MON-YYYY HH24:MI’) or if you want to make it more reusable you might create a substitution string. That will all work, but you can make your life easier and for the ones looking or needing to (more...)
In general, one would expect components to be fairly limited in scope and only have to define a single UI (albeit one that might be reasonably dynamic as discussed in this previous article). However, the occasion may arise where the component needs to be more complex and maybe needs some scoped sub-views. A good example of this might be a wizard-style UI in which you need to encapsulate several distinct "pages" to step though, (more...)
In several previous articles on Apache Kafka, Kafka Streams and Node.JS for interacting with Apache Kafka, I have described how to create a Node.JS application that publishes messages to a Kafka Topic (based on entries in a CSV file), how to create a simple Kafka Streams Java application that processes such messages from that Topic and how to extend that Java application to produce a running Top-N aggregation from that Topic. In this (more...)
is no doubt that web [Rest] APIs have become extremely popular and its
usage has gone well beyond just building APIs in support of mobile apps.
We can see the adoption of resource-oriented architectures (ROA)
by probably all SaaS vendors who provide out-of-the-box APIs as the
means to connect and interact with their cloud applications. Take for
example the Oracle Cloud. To discover and consume publicly available Oracle SaaS APIs, all one need to (more...)
One of the optimizer enhancements that appeared in 12.2 for SQL is the “band join”. that makes certain types of merge join much more efficient. Consider the following query (I’ll supply the SQL to create the demonstration at the end of the posting) which joins two tables of 10,000 rows each using a “between” predicate on a column which (just to make it easy to understand the size of the result set) happens (more...)