Zadnje novosti na področju Oracle baze podatkov

Naslednja verzija Oracle baze podatkov namenjena produkcijski rabi z dolgo podporo bo Oracle 23c. Oracle 23c prinaša veliko novosti na področju JSON, graf, SQL, varnosti, administracije, zmogljivosti, skratka, Oracle 23c bo naslednja najpomembnejša Oracle baza podatkov. Oracle 23c je na voljo v predizdaji in testiranju od začetka leta 2023, na predavanju si bomo ogledali pomembne značilnosti in podrobnosti iz testiranja.

Zadnje novosti na področju Oracle baze podatkov

Naslednja verzija Oracle baze podatkov namenjena produkcijski rabi z dolgo podporo bo Oracle 23c. Oracle 23c prinaša veliko novosti na področju JSON, graf, SQL, varnosti, administracije, zmogljivosti, skratka, Oracle 23c bo naslednja najpomembnejša Oracle baza podatkov. Oracle 23c je na voljo v predizdaji in testiranju od začetka leta 2023, na predavanju si bomo ogledali pomembne značilnosti in podrobnosti iz testiranja.

Back to the Future with Analytic Function

Analytic functions in SQL, also known as windowing functions, have been around for quite a while now. Even if you are familiar with the concept of analytic functions and are working with them occasionally, you may not realize the full potential of this feature, and in how many different scenarios it can be used.

In this session, we will go over a few real-life client requirements for which a solution needs to be found. We will go back to the time before analytic functions existed and will try to solve the client requirements without them. Then, we will return to the present where analytic functions exist, taking advantage of them to provide the same results.

So, if you’d like to see how using analytical functions can provide a simpler, more maintainable, and better-performing solution, then prepare to step into your future and come to this session.

Merjenje performanc pred in po Oracle migraciji

Kako ugotoviti ali se baza na novem strežniku, drugi platformi ali celo na drugi ediciji (enterprise/standard), odziva hitreje ali počasneje? Kako identificirati SQL stavke, ki so bili po migraciji počasnejši? Zakaj in za koliko so bili hitrejši v novem okolju?

Marsikatera organizacija se za odgovore na tovrstna vprašanja zanaša na dolgoletne izkušnje DBA-ja. Mi pa bomo tokrat prikazali, kako lahko pridemo do teh odgovorov tudi brez pisanja SQL stavkov, tako na Standard kot tudi na Enterprise Edition.

Kako ukrotiti pobegle SQL stavke po nadgradnji baze, aplikacije ali hardvera?

Po nadgradnjah baze, aplikacije, hardvera in tudi po instalaciji patchsetov se rado zgodi, da nekateri SQL stavki pobegnejo - se ne izvajajo več tako kot pred spremembami. Če se izvajajo hitreje, to nikogar ne boli. Problem pa nastane, ko se začnejo izvajati počasneje.

Kakšne možnosti imamo, da izvajanje teh stavke "fiksiramo"? Kako to dosežemo tudi v Standard ediciji baze?

Ogledali si bomo tudi način, kako take stavke najti.

==============

After upgrading databases, applications, HW or even after installing patch-sets it often happens that some SQL statements go wild, meaning they start performing significantly different compared to their behavior before the change. If performance is better then no one will complain, but if it is worse then you might have a problem.

What options exist to confine the execution of such statements? How this can be done in DB Standard Edition environments?

You will also find out how such SQL statements can be located.

Back to the Future with Analytic Function

Analytic functions in SQL, also known as windowing functions, have been around for quite a while now. Even if you are familiar with the concept of analytic functions and are working with them occasionally, you may not realize the full potential of this feature, and in how many different scenarios it can be used.

In this session, we will go over a few real-life client requirements for which a solution needs to be found. We will go back to the time before analytic functions existed and will try to solve the client requirements without them. Then, we will return to the present where analytic functions exist, taking advantage of them to provide the same results.

So, if you’d like to see how using analytical functions can provide a simpler, more maintainable, and better-performing solution, then prepare to step into your future and come to this session.

JSON Relational Duality

Oracle JSON Relational Duality technology allows developers to store and query JSON data in an Oracle database using SQL, while also preserving the hierarchical structure of the JSON data. This technology allows for seamless integration of JSON data with traditional relational data in the same database, providing a way to work with both structured and semi-structured data in one system.

What the Heck is the Oracle Optimizer Doing? Part 2 - Plan Costing

When Oracle optimizes your SQL, it works out what it thinks is the best way to execute your statement to retrieve your data as quickly as possible, minimising unnecessary resource usage. This presentation will look at what Oracle is doing. We will use the 10053 trace functionality to show how Oracle uses statistics to cost your SQL access paths, showing what cost really means and how it works, and the impact of messing with system statistics on your database.