- Oracle 12c instance
- Git Client
1. First you will need a 12c Database and the (more...)
Read and monitor Oracle related blogs and news sources, all in one place.
And here we are. The last day of Oracle OpenWorld 2016…
The first session I went to was a panel session called “Thinking Clearly About Database Application Architecture” with Gerald Venzl, Bryn Llewellyn, Connor McDonald, Toon Koppelaars, Cary Millsap. The session started with an introduction by Toon, explaining how the thick database architecture model is provably superior to the thin database model, especially from a performance perspective. I am definintely in (more...)
The Oak Table network is a closed membership of about 100 technical scientists who have a passion for technology and the world around them. These men and women, representing some of the brightest minds from each of their companies, are individuals who have built companies and major technical innovations.
The new version of OBIEE 12c, 126.96.36.199 to be exact, is out, so let’s talk about it. It’s my intent that after reading this, you can expect some degree of comfort in regards to possibly doing this thing yourself (should you find yourself in just such a circumstance), but if not, feel free to drop us a line or give us a ring. It should be noted that Oracle documentation explicitly (more...)
I have been working with BI Applications since OBIA switched to ODI in version 188.8.131.52.0. I have installed and worked with all of the 11.x versions using several different sources. This most recent version of OBIA may only be a Patch-Set release, but it has some new features that make it very compelling; ETL automatic error handling, Health Check, ETL Diagnostics, and built in Email notifications.
If you've been using (more...)
Last year I did a presentation on table functions at KScope. One of the questions I got was: ‘If pipelined table functions provide their results faster, why would you want to use a normal table function?’ I couldn’t come up with the answer then, maybe you can help?
Erik van Roon
Let’s start with explaining a bit what table functions are. Table Functions are functions that return a collection of (more...)
Don’t forget Oracle Midlands Event #17 next week!
I don’t know about you, but I would like to know what Oracle have been up to. There has been very little in the way of publicity from them recently…
If you live near, please show your support for the event and come along. It’s free thanks to the sponsorship by RedStackTech.
I started the day by meeting up with a bunch of people at the Dbvisit breakfast. This has become a regular event over the last few years. Followers of the blog know I like the Dbvisit folks and they tend to attract people I find fun and interesting. After food, loads of coffee and interesting conversation, it was time to head across to the conference.
We had question in the OpenWorld panel about why queries on date columns are “always slow”. Well….they aren’t but here’s a common cause of that misconception.
Let’s create a table as a copy of DBA_OBJECTS, and index the CREATED column (which is a date).
SQL> create table t as 2 select * 3 from dba_objects; Table created. SQL> SQL> create index t_ix on t ( created ); Index created.
The problems start when (more...)
Today an application team had a problem with a production system and they wanted the database restored to a point a couple of days ago. It is a configuration management system and they figured they could lose any changes . Their call.
I did all the good things
select flashback_on from v$database;