-
Continue reading →: Parallel MadnessI’ve noticed at a few clients with data warehouses recently that the Developers and, upon occasion, Business Users have a real fondness for hinting the SQL they are producing with one particular hint. PARALLEL. As any fule kno, this IS the magic go-faster hint. PARALLEL(2) is obviously twice as fast…
-
Continue reading →: Where’s my Oracle SQL Plan Baseline?No so long ago I was having fun creating SQL Plan Baselines in a old 11.2.0.3 database due to be decomissioned but which needs to keep running for a while (no doubt several years) – so minimal time/money to be expended on it. Then, one day, I couldn’t create a…
-
Continue reading →: Proactive Oracle Support?You may not be aware but Oracle have been talking about their new ProActive support with user groups like the UKOUG. It’s basically trying to show you best practices you should be implementing before stuff goes wrong, and many other useful bits of information. It covers a lot of areas…
-
Continue reading →: Oracle 19C New Feature AvailabilitySince Oracle Open World 2018, Oracle have been trumpetting a few cool new features in the Oracle 19C database, the headline two for administrators being “Automatic Indexing” and “Real-Time Statistics“. With the release of Oracle 19.2 on Exadata (on-premises – not yet on Cloud!) this week, we also got the…
-
Continue reading →: Oracle SQL Monitor not monitoring my SQLI needed to monitor a SQL statement in 11.2.0.3 (the limits mentioned below are the same in 12.1, 12.2, 18.4 and 19C) to determine what is was doing and why it was slow. Usually I would use SQL Monitor [NOTE: You need to license the Oracle Tuning Pack to use…
-
Continue reading →: Data Guard Unexpected LagWhen configuring a physical standby database for Oracle using Data Guard, you need to create Standby Redo logs to allow the redo to be applied in (near) real time to the Standby. Without standby redo logs, Oracle will wait for an entire Archive Log to be filled and copied across…
-
Continue reading →: UKOUG Oracle Conferences – why bother?The excellent DOAG Oracle conference is currently taking place in Nuremberg in Germany. I’ve been thinking about the UKOUG Conference due to take place in Liverpool on 3rd-5th December 2018. About 2 weeks away. Why would you bother paying to attend these conferences? Why should I, or my company, use…
-
Continue reading →: Oracle Open World Presentation: REST Enabled Neural NetworksHi! I’m currently at Oracle Open World 2018 in San Francisco and I’ve so I thought I would provide a copy of my slide deck for the presentations this morning. If you are interested in how to provide good Neural Networks Machine Learning to developers in a simple to ingest…
-
Continue reading →: Off to Spain!Next week I will be in Madrid to speak at the Spanish Oracle User Group – SpOUG! I am really looking forward to this. Great content, an opportunity to look around Madrid – somewhere I have not been for 26 years – and catch up with fellow techies, some of…
-
Continue reading →: POUG18So that was POUG18 – the Polish Pint with Oracle User Group. This is the 3rd annual conference (and the 4th event) I have attended. A new location, many new speakers but the same vibe, energy and level of fun. Taking place in Sopot on the Baltic Sea, it was…
-
Continue reading →: Off to Poland…
This week I will be speaking at the Polish Oracle User Group annual conference in Sopot, Poland. It looks like a beautiful location for what is a really fun conference. As well as being surrounded by some of the most knowledgeable and excellent technology speakers in the world, there’s also…
-
Continue reading →: Which Oracle Release are you using?
Post Date: August 2018! Recently an awesome Oracle Guru friend of mine questioned someone who was installing 11.2.0.4 with the word “seriously”, which is think shows that Oracle staff sometimes don’t live in the same technological world as the rest of business. My response was: 11.2.0.4 is normal. In the…
-
Continue reading →: Riga Dev Days 2018Last week I spent some time in Riga, Latvia. It was unusually warm, much to the consternation of the locals who wanted it to return to more normal sub-20C instead of the current 27C. Riga is a long way North. It is also beautiful, friendly, and hosts a great conference! RigaDevDays…
-
Continue reading →: UKOUG Call For Papers: Tech18, Apps18 and JDE18The call for papers for Tech18, Apps18 and JDE18 is now open until Monday 4th June at 09:00. You have until then to submit an abstract for whatever you would like to talk about! What would you like to talk about? You’re telling me you have nothing? I don’t believe…
-
Continue reading →: See me in Riga!I will be speaking about the Oracle Optimizer in Riga, at Riga Dev Days! The biggest tech conference in the Baltic states takes place on the 29th/30th/31st May – click on the logo below for full conference details. I really hope to see you there
Neil Chandler's DB Blog 