BLOG – Karol Wieliczko – databases and machine learning issues
The 23ai database, as the name suggests and the numerous announcements on the official website, has been integrated with artificial intelligence (AI) technology. One of the solutions in this area is the Vector Search functionality, which, as you will soon see, simply takes modern data processing to a whole new level. This is particularly important …
Oracle AWR (Automatic Workload Repository) reports are a diagnostic tool available in Oracle databases that helps analyze system performance and identify areas requiring optimization. At first glance they look, let’s be honest, quite complicated. Lots of sections, lots of numbers and parameters. Due to their detailed and technical nature, they require some experience in use. …
In this article, we will look at how to quickly configure the Oracle 21C database for programming purposes using Docker. What are Docker containers? It is a packaging format that accumulates code and apprenticeships in a form that allows quick and reliable operation in all computing environments. Using containerization, we can quickly start the platform …
Recently, I was reported a problem, consisting in the slow operation of the inquiry in the production database. As it turned out, the reason was the use of the wrong plan by the optimizer, which in effect led to a heavy load on the base and slowed work of the application. The same question is …
Tom Kyte, author of many books related to Oracle databases, on his blog he once described the history of the impact of atmospheric precipitation on the speed of SQL queries in the Oracle database. This article is unfortunately no longer available, but I will try to describe this strange story myself. But what’s the matter? …