David Atraktsi

10 Added | 2 Magazines | @Doodya | Keep up with David Atraktsi on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “David Atraktsi”

Automatic Reoptimization in Oracle Database 12c Release 1 (12.1)

8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux<p>Home » Articles » 12c » Here<p>Adaptive Query Optimization in Oracle …

Adaptive Query Optimization in Oracle Database 12c (12.1 and 12.2)

8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux<p>Home » Articles » 12c » Here<p>Adaptive Query Optimization is a term used …

Dynamic Statistics in Oracle Database 12c Release 1 (12.1)

8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux<p>Home » Articles » 12c » Here<p>Oracle Database 10g introduced Dynamic …

SQL Plan Directives in Oracle Database 12c Release 1 (12.1)

8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux<p>Home » Articles » 12c » Here<p>SQL Plan Directives are one of the …

Yep, that tablet at bedtime really is messing with your sleep

New study links screen use at night with less REM sleep<p>If you’re reading a book before bed, what do you reach for: a paperback, a tablet, or an e-reader? The choice you make will have an effect on your sleep, and if you answered either of the last two then you probably already know the news isn't …

Oracle Log File Sync Wait Event

The Oracle <b>“log file sync”</b> wait event is triggered when a user session issues a commit (or a rollback). The user session will signal or post the LGWR …

Understanding Partitioned Indexes in Oracle 11g

A partitioned index in Oracle 11g is simply an index broken into multiple pieces. By breaking an index into multiple physical pieces, you are …

Adaptive Query Optimization in Oracle Database 12c | The ORACLE

Over the holiday period I finally decided to tackle the Adaptive Query Optimization stuff in Oracle 12c, which resulted in these articles.<p>Adaptive …

Databases

External Tables: An Introduction - Simple Talk

At its most basic level, Oracle databases are built around data based within tables held within the database, and the moulding of that data into …

עד כמה דינאמי יכול להיות SQL דינאמי?

כשמדברים על SQL דינאמי, לכולנו עולה בראש execute immediate. ואכן execute immediate מאפשר לנו להריץ SQL דינאמי, כזה שאת שם הטבלה או העמודה שאנחנו …