Category Archives: Beginners

Getting started with Oracle Autonomous Transaction Processing

Getting started with Oracle Autonomous Transaction Processing is actually much easier than you might think. In fact, with Oracle’s $300 in free cloud credits you can probably get your first 30 days on the service for free. Please note, you … Continue reading

Posted in Autonomous Database, Beginners, Oracle Database 18c, Top_Tip | Tagged , , , | Leave a comment

JEFF Talks From Kscope18

The first day of the ODTUG Kscope conference is always symposium Sunday. This year’s Database symposium, organized by @ThatJeffSmith, consisted of multiple, short, rapid  sessions, covering a wide variety of database and database tool topics, similar to Ted Talks but … Continue reading

Posted in Beginners, Events, JSON, Syntax, Top_Tip | Tagged , , , , | Leave a comment

How to determine which view to use

Often times DBAs or application architects create views to conceal complex joins or aggregations in order to help simplify the SQL queries developers need to write.  However, as an application evolves, and the number of views grow, it can often … Continue reading

Posted in Beginners, New Features, Oracle Database 12c New Features, SQLDev | Tagged , , , | 5 Comments

Does the Explain Plan command really show the execution plan that will be used?

When it comes to SQL tuning we often need to look at the execution plan for a SQL statement to determine where the majority of the time is spent. But how we generate that execution plan can have a big … Continue reading

Posted in Beginners, Optimizer | Tagged , , , | 1 Comment