Category 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

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