Delphix is sponsoring a user webinar on Wednesday from 10 to 11 am California time. I and a couple of other technical Delphix users will take part in a panel discussion. The webinar will give you a good chance to hear about other users’ experience with Delphix and a chance to ask questions. Like any good user meeting it will not be a non-technical sales pitch but it will instead focus on users sharing helpful technical information with other Delphix users.
Noted Oracle (more...)
Some people get very excited with roles, and quickly the number of roles proliferates to huge numbers…Until this happens
ORA-28031: maximum of 148 enabled roles exceeded
But in helping someone out on AskTom, I just found a nice touch in 22.214.171.124. I had granted my account 200 roles (since the max_enabled_roles parameter is capped at 148), fully expecting to get the standard error when attempting to connect. But I didn’t (more...)
If you’re using AQ, then it’s simple to setup simple enqueue and dequeue facilities on your local database to provide all sorts of asynchronous style processing in your applications. As long as you’re applications are designed and built to handle it, the “fire and forget” model to keep user applications responsive, and all of the “heavy lifting” done in the background is a very attractive one.
You can also use AQ to achieve the (more...)
Thanks to all those who attended my session on “Policy Based Cluster Management In Oracle 12c” during Sangam16. I have uploaded my presentation here.
Your comments and feedback are always welcome.
You might be interested in this:
I’m off to UKOUG again this year. It’s an awesome conference, and I’ll be doing three talks there.
On Monday at 3:30 it’s my first keynote talk “12 Things You’ll Love About the Oracle Database 12.2”, followed up at 6pm by “AskTom – One Year On”.
On Tuesday, at 3:30 I’ll be doing a talk for anyone want to come up to speed on all of the partitioning features with “Partitioning 101”.
#DOAG2016, the largest Oracle Community gathering in Europe. Taking place in Nuremberg, at the Nuremberg Convention Center NCC, one of the more impressive places to hold such a conference, towering 4 stories high, with a big central atrium!!
It is a huge effort to get all of this together!
In this blog-post I want to highlight some of the crazy things I experienced this week… And… I did try to follow my own schedule (more...)
So in part1 and part2, we looked at creating tables with clustered data. If you’re ready to climb aboard the attribute clustering heading toward Fastville you might want to take an existing table and cluster it. In part 2 we saw how we had to be extra careful with syntax. The same rule applies with altering a table to cluster it. Lets start with our SOURCE_DATA table which was not (more...)
In the previous post, I demonstrated attribute clustering by
- creating a table of source data which contained data in randomised order, via
SQL> create table source_data as
2 select d.*
3 from dba_objects d
4 where object_id is not null
5 order by dbms_random.random;
- and then it loading into a table with attribute clustering defined to cluster the data into the desired order.
The obvious question is then “Why not just cluster the (more...)
Here I am going to explain how to configure Oracle EBS integrated soa gateway for SOAP services on 12.2.6.
The E business suite integrated soa gateway configuration require a Oracle SOA suite with weblogic on separate server.
Refer the document for how to install
Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)
In this note, Go to
Section 1: Configuring Oracle E-Business Suite Integrated SOA Gateway for (more...)
I did it: in my proudest moment at DOAG2016, at the very end of my second presentation, I presented a brilliant SQL query with a bug in it. After agonizing for awhile, I finally saw that the correction was simple and didn't change the timing.
I am trying to deploy the SOAP service in ebs 12.2.6 with integrated SOA gateway. I can able to deploy the wsdl file but I can’t able to view wsdl files. The below error appeared when I try to open view wsdl file
“Failed to Load a composite for composite identified by default”
So I realized the error seems to be part of SOA server. I looked the SOA server log from EM (more...)
I’m on call this week. Here are the steps that I took to speed up a query today.
First I got an AWR report and found the top query. Also, someone from support told me to look at November 11 before the latest release and I found a similar top query.
I got a plan for both the new and old top queries – they both use the same plan which makes me think that the (more...)
Short overview of some last week failing builds at our site
Since a while ago it’s possible to register proxy repositories in Nexus based on the Oracle Maven Repository.
To be able to proxy this repository you need to make use of an oracle account for the autenthication before you can download the artifact.
Let’s check the logging to understand what it does (i can rephrase the logfile or just copy/paste it ;), when others (more...)
This is the 39th installment of my blog series around Stream Processing and Analytics.
As usual, find below the new blog articles, presentations, videos and software releases from last week:
News and Blog Posts
So I subscribe to the idea that the only way to improve is to dive in on the deep end. Sink or swim.
With that in mind I sent in an abstract to RMOUG and actually got it accepted. Now, this is a conference I used to attend every year when I lived in Denver. I know the quality they have in most presentations nad I know that lots of people with “important” names in the (more...)
Oracle 12c has a new feature related to optimizer dynamic sampling. The new level 11 is supposed to put the dynamic sampling on auto pilot and make the statistics available to other users. However, as soon as this was set, I started noticing processes spending significant time waiting for row cache latch. This was strange, especially having in mind that ASMM was configured. I checked the V$ROWCACHE by using the following, fairly standard, query:
I needed to write a new script that was running on a Red Hat Linux 6 virtual machine and that would connect to databases using SQL*Plus. I was going to write a bash shell script but decided to use Python instead to see if I could do it using the Python that came with this version of Linux. I wont paste the entire script here but the key was to run SQL*Plus from Python instead of a shell (more...)
… and thanks for all the fish.
Today I removed myself from the OTN ACED program. This isn’t a reflection on the anything to do with the ACE program – quite the reverse, in fact – it’s because they’re introducing steps to ensure that the ACE Directors can justify their titles. Unfortunately, as anyone who has gone through (e.g.) ISO 9001 certification can tell you, quality assurance tends to translate into paperwork and (more...)
lately I wrote a couple of posts about bash scripting for DBAs (part 1 and part 2). I promised to post an example script as well, and I will. But before that I thought it’s important to give several examples of how scripts can be destructive. The examples in this post are real, and involved … Continue reading Bash Critical Mistakes
I created a new GitHub public repository with my SQL scripts. Here is the URL:
I’ve experimented with GitHub for my Python graphing scripts but wasn’t sure about putting the SQL out there. I don’t really have any comments in the SQL scripts. But, I have mentioned many of the scripts in blog posts so those posts form a type of documentation. Anyway, it is there so people can see it. Also, I get (more...)