Testing With utPLSQL – Made Easy With SQL Developer
This post was originally published on this siteNowadays, everything is about automation. Software testing is no exception. After an introduction, we will create and run utPLSQL tests with Oracle SQL Developer for a fictitious user story. Our tests will cover a PL/SQL package, a virtual…
plscope-utils for SQL Developer 1.0 – What’s New?
This post was originally published on this siteIntroduction PL/Scope is an SDK for source code analysis. It is available since Oracle Database 11g Release 1 and has been significantly improved in 12c Release 2. plscope-utils for SQL Developer is a SQL Developer extension that simplifies…
Last Week in Stream Data Integration & Stream Analytics – 13.7.2022
This post was originally published on this siteThis is the 247th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
Housekeeping in Oracle: How to Get Rid of Old Data
This post was originally published on this siteHave you ever tried to delete a few million rows from a table with several hundred milllions of rows with a DELETE statement? If yes, then you know that this is a very bad idea. With Oracle Partitioning…
Last Week in Stream Data Integration & Stream Analytics – 27.6.2022
This post was originally published on this siteThis is the 246th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
NVMes write back vs. write through performance
This post was originally published on this siteRecently I was running some benchmarks to double-check that the performance of AMD EPYCs servers delivered by Company A, match the performance of those delivered by Company B. I was using our benchmark automation tool (about which I…
Data Vault versus Database Vault
This post was originally published on this siteIn the Oracle community, the terms “Data Vault” and “Database Vault” are often confused, although they have nothing to do with each other. A short clarification. Some time ago I had a meeting with the development team and…
Last Week in Stream Data Integration & Stream Analytics – 18.5.2022
This post was originally published on this siteThis is the 245th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
Performance Tips: PL/SQL Functions in SQL Queries
This post was originally published on this sitePL/SQL functions in SQL statements may cause major performance problems. If it is not possible to avoid these calls, there are several solutions to improve the performance. But not for all situations. In my last blog post, I wrote…