Oracle Setup Oracle XE on Linux Mint – a funny exercise 07.04.2020 by Clemens Bleile On my old Laptop (Acer Travelmate with an Intel Celeron N3160 CPU) I wanted to install Oracle XE. Currently the available XE version is 18.4. My Laptop runs on Linux Mint 19.3 (Tricia). The Blog will describe the steps I(…)
Database Administration & Monitoring, Oracle A change in full table scan costs in 19c? 28.03.2020 by Clemens Bleile During tests in Oracle 19c I recently experienced this: cbleile@orcl@orcl> select * from demo4 where m=103; cbleile@orcl@orcl> select * from table(dbms_xplan.display_cursor); ... --------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | --------------------------------------------------------------------------- |(…)
Database Administration & Monitoring, Oracle ARRAYSIZE or ROWPREFETCH in sqlplus? 08.01.2020 by Clemens Bleile ARRAYSIZE or ROWPREFETCH in sqlplus? What is the difference between the well known sqlplus-setting arraysize and the new sqlplus-12.2.-feature rowprefetch? In Blog https://www.dbi-services.com/blog/oracle-fasttrue-in-sqlplus-some-thoughts-about-rowprefetch/ I showed a case, which helps to reduce the logical IOs when(…)
Database Administration & Monitoring, Oracle Oracle FAST=TRUE in sqlplus? Some thoughts about rowprefetch 05.01.2020 by Clemens Bleile During my time as a Consultant working on Tuning Tasks I had the feeling that many people think that there is an Oracle-parameter “FAST=TRUE” to speed up the performance and throughput of the database calls. Unfortunately such a parameter is(…)
Database Administration & Monitoring, Oracle Elapsed time of Oracle Parallel Executions are not shown correctly in AWR 15.11.2019 by Clemens Bleile As the elapsed time (time it takes for a task from start to end, often called wall-clock time) per execution of parallel queries are not shown correctly in AWR-reports, I thought I setup a testcase to find a way to(…)
Database management, Oracle Creating archived redolog-files in group dba instead of oinstall 09.10.2019 by Clemens Bleile Since Oracle 11g files created by the database belong by default to the Linux group oinstall. Changing the default group after creating the central inventory is difficult. In this Blog I want to show how locally created archived redo can(…)
Database Administration & Monitoring, Oracle Oracle 19c 09.10.2019 by Clemens Bleile Oracle 19c has been released quite a while ago already and some customers already run it in Production. However, as it is the long term supported release, I thought I blog about some interesting information and features around 19c to(…)
Database Administration & Monitoring, Database management, Oracle Direct NFS, ODM 4.0 in 12.2: archiver stuck situation after a shutdown abort and restart 24.04.2019 by Clemens Bleile A customer had an interesting case recently. Since Oracle 12.2. he got archiver stuck situations after a shutdown abort and restart. I reproduced the issue and it is caused by direct NFS since running ODM 4.0 (i.e. since 12.2.). The(…)
Database Administration & Monitoring, Database management, Oracle Restart a failed transportable tablespace import during a cross platform incremental backup migration 30.01.2019 by Clemens Bleile I’m currently working in a project to migrate a 11g-Datawarehouse-database from Solaris to Linux Intel (Endian-change). We do use the cross platform incremental backups method as described in My Oracle Support Note 1389592.1 for that. I.e. incremental backups are(…)
Database Administration & Monitoring, Database management, Oracle Technical and non-technical sessions at the DOAG 2018 23.11.2018 by Clemens Bleile The amazing DOAG 2018 conference is over now. As every year we saw great technical as well as great non-technical sessions. What impressed me was the non-technical presentation “Zurück an die Arbeit – Wie aus Business-Theatern wieder echte Unternehmen werden”(…)