Tag Archives: IoT

Avoiding reparsing SQL queries due to partition level DDLs – Part 2

In my pervious post, I promised to provide an alternative solution to avoiding repasing SQL queries due to partition level DDLs. So, what is it? In Oracle Database 12 Release 2 we implementing a fine-grained cursor invalidation mechanism, so that … Continue reading

Posted in IoT, Partititoning, Top_Tip | Tagged , , | 2 Comments

Avoiding reparsing SQL queries due to partition level DDLs – Part 1

A couple of weeks ago, I published a blog post that said specifying a partition name in the FROM clause of a query would prevent an existing cursor from being hard parsed when a partition is dropped from the same … Continue reading

Posted in IoT, Partititoning, Top_Tip | Tagged , , | Leave a comment

Day 3 of Oracle OpenWorld 2017

Hopefully you enjoyed yesterday, the second full day of technical sessions at Oracle OpenWorld and are ready for more today! At 11:30 am today I give my first technical session, with the wonder Dominic Giles of Swingbench fame! Dom and I will … Continue reading

Posted in Events, OOW | Tagged , | Leave a comment

Oracle Database Audio White Papers

Back in April, I shared with you a new white paper that described a set of best practices or management techniques to facilitate IoT workloads with the Oracle Database. Since then there have been a number of updates in this space that I … Continue reading

Posted in IoT, technical_papers, Whitepapers | Tagged , | Leave a comment

Best Practices For Large Volume or IoT Workloads

Over the last few years there has been a rapid surge in the adoption of smart devices. Everything from phones and tablets, to smart meters and fitness devices, can connect to the Internet and share data. You only have to … Continue reading

Posted in technical_papers | Tagged , , | 2 Comments