Author Archives: Oren Nakdimon

EBR – Part 11: Database-Level Default Edition

Oren Nakdimon Leave a Reply

This is part 11 of a post series about Oracle Edition-Based Redefinition. Visit the index page for all the parts of the series Introduction As we’ve seen in the previous posts, the process of an online application upgrade, in high level, includes the following steps: Creating a new edition Applying all the necessary changes in […]

Continue reading

ENABLE NOVALIDATE – Too Polite?

Oren Nakdimon Leave a Reply

Onine DDL operations are much more polite than offline DDL operations. They usually wait patiently for transactions that hold resources they need until these transactions end, and they do not block new DML statements. As I wrote in the past, adding a constraint as Enabled and Validated (which is the default for new constrtaints) is […]

Continue reading

ODC Appreciation Day : Pattern Matching in SQL

Oren Nakdimon Leave a Reply

Here’s my contribution to the ODC Appreciation Day. Pattern Matching in SQL, using the MATCH_RECOGNIZE clause, is one of my favorite features, but only recently I’ve used it “for real”. MATCH_RECOGNIZE allows us to perform enhanced analysis of row sequences, and to detect sequences that match complex patterns. This feature gave a significant boost to […]

Continue reading

Index Hints and Distributed Queries

Oren Nakdimon 4 Replies

There are two ways to specify indexes in optimizer hints: by the index name, or by the index’s (leading) columns: The latter is usually preferred, as the writer’s intention is clearer, and it’s immune to changes of the index name. Note: one can present the opposite argument, that specifying the index name is immune to […]

Continue reading

EBR – Part 9: Adding a New Column

This is part 9 of a post series about Oracle Edition-Based Redefinition. Visit the index page for all the parts of the series Introduction In part 7 (“Editioning Views”) I introduced our third development use case – adding a new column that represents a new business logic. I emphasize the fact it’s a new business […]

Continue reading

EBR – Part 8: The Last Planned Downtime

Oren Nakdimon 1 Reply

This is part 8 of a post series about Oracle Edition-Based Redefinition. Visit the index page for all the parts of the series Introduction I concluded the previous post by stating that the application code should never reference tables directly; instead, every table should be covered by an editioning view and the application code should […]

Continue reading

EBR – Part 7: Editioning Views

This is part 7 of a post series about EBR. Visit the index page for all the parts of the series Introduction Our next use case is adding a column that represents a new logic to the PEOPLE table, and making the corresponding changes in the PEOPLE_DL and APP_MGR packages. Of course, as we speak […]

Continue reading