-
Continue reading →: Goldengate Install ErrorSometimes you waste much more time than you can believe because the instrumentation of the system isn’t great. If you don’t know what a system is doing, you can’t easily fix it. Time should be take to instrument your code, and ensure that any outputs from that instrumentation are readily…
-
Continue reading →: Oracle Database GLOBAL_NAME, DB_DOMAIN and database linksI needed to create a database link on a 19.7C Oracle DB recently. Importantly, the database link name must match the database name as security dictates that GLOBAL_NAMES=TRUE for this set of databases. The DB was created using the gui on an ODA, meaning there were quite a few initialisation…
-
Continue reading →: UKOUG Techfest19I’ve just returned from Techfest19 – the UKOUG Flagship Oracle Tech conference – and it was simply excellent. It was held at The Grand Hotel in Brighton, and it was grand. If you missed it, you really missed out. 250 mostly amazing presentations. I did 2 main ones about Oracle…
-
Continue reading →: Oracle Tech Conferences
It’s mid-November 2019. The leaves have mostly fallen and the nights are drawing in. That can only mean… it’s time for Europes 2 biggest Independent Oracle User Groups to have their conferences. The first, starting Tuesday 18th November, is DOAG – the German Oracle User Group – in Nuremberg. I’m…
-
Continue reading →: Oracle Table Prefs
V. Quick post for me really: Some SQL to tell me all of the Table Prefs for any specific table (All Oracle 19 prefs) You could always just query DBA_TAB_STAT_PREFS select * from user_tab_stat_prefs where table_name = ‘&&TABLE’; But that only tells you what you have explicitly set for a…
-
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…
Neil Chandler's DB Blog 