On Thursday, December 8th, Fishbowl had the privilege of presenting a webinar with Mike Ernst – VP of Contruction Operations – at Ryan Companies regarding their use case for Fishbowl’s ControlCenter product for controlled document management. Mike was joined by Fishbowl’s ControlCenter product manager, Kim Negaard, who provided an overview of how the solution was implemented and how it is being used at Ryan.
Ryan Companies had been using Oracle WebCenter for many years, but (more...)
I stumbled upon a convenient way to rename a pluggable database:
SQL> alter system enable restricted session;
SQL> alter database rename global_name to test12.home.com;
SQL> alter session set container=cdb$root;
SQL> select name from v$pdbs;
In other words, to rename a pluggable database, one only needs to rename its global name. Cute!
Many people are using DBMS_STATS to gather optimizer statistics. This package has many different options, and I wanted to tell you about one option for disabling automatic statistics gathering. When we need to disable the automatic statistics gathering we usually do one of the following: Disable the job itself (using DBMS_AUTO_TASK_ADMIN). This completely disables the job so no … Continue reading Did You Know #17 – DBMS_STATS
After my Masterclass on indexes at the UKOUG Tech2016 conference this morning I got into a conversation about creating extended stats on a table. I had pointed out in the masterclass that each time you dropped an index you really ought to be prepared to create a set of extended stats (specifically a column group) on the list of columns that had defined the index just in case the optimizer had been using the distinct_keys (more...)
Excited to see the announcement of Amazon RDS Performance Insight feature for database performance monitoring and tuning.
Having met the team for this project I can say from my personal view point that the importance and future success of this feature is clear as day to me. The team is awesomely sharp, the architecture is super impressive, and this is by far the most exciting performance monitoring and feedback system I’ve been involved with, surpassing the (more...)
I would think installing SQL*Plus on the Mac would be point, click download, point click, install bam it works.
It did install mostly straight forward on my old Mac. Got a new Mac and no dice.
Tried installing myself guessing at the downloads. First of all why isn’t there just one download?
Downloaded instantclient and instantclient with SQL*Plus which turns out to be correct, but no dice. Still got errors.
Got errors. Gave up.
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 188.8.131.52. 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...)
One of the nice facilities in 12c is the ability to instruct the database to co-locate data during loading in order to facilitate reduced resource consumption for subsequent queries.
Here’s an example of it in use. First I’ll create table SOURCE_DATA to mimic some randomised incoming data feed
SQL> exec dbms_random.seed(0)
PL/SQL procedure successfully completed.
SQL> drop table source_data purge;
drop table source_data purge
ERROR at line 1:
ORA-00942: table or view does (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...)
We had a question on AskTom recently asking for the best way to update a new column on a very large table. Four in-place update options are at our disposal:
- Serial update SQL
- Parallel DML update SQL
- PL/SQL batching (as long as sensible restart-after-error logic is readily available)
all of which will achieve the required outcome but they have a significant redo and undo cost associated with them. Also, depending on the (more...)