-
Continue reading →: Exadata System StatisticsFollowing on from last weeks Oracle Optimizer System Statistics post, I though it worthwhile adding a note about gathering system statistics in Exadata mode. exec dbms_stats.gather_system_statistics(‘EXADATA’); So what is this, and why would you chose to do it? First of all, these are not workload system statistics (which I believe…
-
Continue reading →: Oracle Optimizer System StatisticsOh System statistics! Should we gather them? Should we not?What do they mean? What are they doing to the optimizer? tl;dr – in almost all cases, DON’T GATHER SYSTEM STATISTICS.DON’T SET MBRC. LET THEM DEFAULT! First you need to be armed with a piece of information. When Oracle optimizes your…
-
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 ConferencesIt’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…








