
Andrej Pashchenko πΊπ¦ ππ
@andrej_sql
Database developer, data engineer, Oracle Ace Associate β
Born in Ukraine
Views are my own
ID: 927198037654540288
https://blog.sqlora.com 05-11-2017 15:36:53
210 Tweet
168 Followers
159 Following

Ready for crime investigation session at #apexconn24 with Monika Lewandowska π΅π±πͺπΊ Oracle ACE Program




I will talk about optimizer statistics at #AOUG Conference on June 17th, in particular what my responsibilities as a data engineer are. I think it's very important that it's not seen as just a DBA's job. Here is just one simple example of why: blog.sqlora.com/en/object-stat⦠Oracle ACE Program

As a data engineer, do I have to worry about optimizer statistics? In the second part is a typical example of why the performance immediately after loading the data can be suboptimal if you don't take care of the stats. #oracledatabase Oracle ACE Program blog.sqlora.com/en/object-statβ¦

Join AOUG Anwenderkonferenz 2024 next week for many great sessions presented by Oracle ACEs π Alex Nuijten Ambili Andrej Pashchenko πΊπ¦ ππ JΓΆrg Doppelreiter @martinberger_ch Mirela Ardelean Roel π Ruben Rodriguez @oraclesean Stefan Oehrli social.ora.cl/60105VSQq #OracleACE


There have been some changes and improvements to the Online Statistics Gathering for Bulk Loads over the last few years. Here is the new blog post: #oracledatabase Oracle ACE Program blog.sqlora.com/en/online-statβ¦

I am absolutely thrilled to be presenting at the #HROUG2024 for the first time. Thanks HrOUG Hrvatska udruga Oracle korisnika for accepting my talks. In just two weeks! See you there! Oracle ACE Program


And if you want to use your existing views and let SQL macros "inject" parameter, you can check the second part (blog.sqlora.com/en/parameterizβ¦) of this post and also Stew Ashton 's post: stewashton.wordpress.com/2024/04/24/sqlβ¦



My Accenture DACH colleague Andrej Pashchenko πΊπ¦ ππ is going to talk about partition exhange at the HrOUG Hrvatska udruga Oracle korisnika #HROUG2024 conference Oracle ACE Program


Everything you should know about block corruptions in #Oracledatabase with Christian Gohmann at #hroug2024


Get rows in one table with no match in another with either c1 NOT IN ( SELECT c2 ... ) NOT EXISTS ( SELECT ... where c1 = c2 ) These perform the same in Oracle #SQL ...unless C2 includes NULL values => NOT IN returns no rows! Andrej Pashchenko πΊπ¦ ππ explores blog.sqlora.com/en/not-in-vs-nβ¦


Did you know that refreshing HCC-compressed materialized views with atomic_refresh=true can multiply storage usage over time? Small details can have massive impacts. Read the new blog post. #Exadata #Oracle #HCC Oracle ACE Program blog.sqlora.com/en/when-compreβ¦

Ten years after my first post on the quirks of MERGE and ORA-30926, I took a fresh look at how Oracle 23ai handles it. Clearer error messages, improved diagnostics, and fewer unnecessary restarts. Read the new blog post #Oracle23ai #SQL #MERGE Oracle ACE Program blog.sqlora.com/en/ora-30926-iβ¦

MERGE ... RETURNING is now supported in #Oracle23ai. In my view, it deserves more visibility in the documentation β it wasnβt easy to find. Even LLMs still claim it doesnβt exist (some even invent error codes). #SQL #MERGE Oracle ACE Program blog.sqlora.com/en/merge-and-dβ¦