Database Administration & Monitoring, Database management, Development & Performance, Oracle Connect-times to the DB suddenly become very slow using sqlcl 12.03.2018 by Clemens Bleile I recently wrote a couple of sql-scripts which had to run on all of my customer’s DBs. The sql-scripts had to be started from a Linux-client, which does not have any Oracle client software installed. So I thought of using(…)
Database Administration & Monitoring, Database management, Development & Performance, Oracle Running the Oracle Client on a Raspberry Pi 09.01.2018 by Clemens Bleile What are the possibilities to use a Raspberry Pi computer as an Oracle client? Besides other things I’ll show a possibility in this Blog to run the fat/thick Oracle Client on a Raspberry Pi! REMARK: All examples below(…)
Database Administration & Monitoring, Development & Performance, Technology Survey SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM 04.01.2018 by Stéphane Haby Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands:(…)
Development & Performance APEX Connect 2017 – Day 3 12.05.2017 by Alain Lacour For the last conference day, after the Keynote about “JavaScript: The next Language YOU should learn” by Dan McGhan , I decided to attend presentations on following topics: – Upgrade your APEX app with zero downtime by using EBR(…)
Development & Performance APEX Connect 2017 – Day 2 10.05.2017 by Alain Lacour After the Keynote about “Oracle Application Express – Ahead of it’s time. Leading the way forward” by Joel Kallmann (Director of Software Development for APEX) and some overall presentation about Development with APEX 5.1, I decided to attend presentations on(…)
Development & Performance, Technology Survey SQL Server 2017: first steps with Python Service 10.05.2017 by Stéphane Haby Last year, I written blogs about SQL Server 2016 and his integration from the R language. Just for information, you can find these blogs about SQL Server 2016 R Services here: SQL(…)
Development & Performance APEX Connect 2017 – Day 1 09.05.2017 by Alain Lacour This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, CSS, SQL and much more. After the welcome speech and the Keynote about “Reconciling APEX and the Thick Database Paradigm” by(…)
Database Administration & Monitoring, Database management, Development & Performance Oracle 12cR2 : Optimizer Statistics Advisor 08.05.2017 by Joël Cattin The Optimizer Statistics Advisor is a new Advisor in Oracle 12.2. The goal of this Advisor is to check the way you gather the statistics on your database, and depending on what is found, it will makes some recommendations(…)
Database Administration & Monitoring, Development & Performance Oracle 12cR2 : Partitioning improvements – multi-column list partitioning & read-only partitions 16.12.2016 by Joël Cattin In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image :(…)
Database Administration & Monitoring, Development & Performance Oracle 12cR2 : Partitioning improvements – auto-list partitioning 08.11.2016 by Joël Cattin The second release of Oracle Database 12c (12cR2) comes with new improvements regarding partitioning. In this blog post I’ll show one of them : auto-list partitioning. Auto-list partitioning is an extension of list partitioning. It enable the automatic(…)