BE SHARING

Oracle Team

Oracle DB on Azure with Multitenant Option

22.02.2021 by Oracle Team

By Franck Pachot . If you want to run an Oracle Database in the Microsoft Azure cloud, you will install it yourself on a VM. And then, you can expect the same as when you install it in your(…)

Oracle

Learn ODA on Oracle Cloud

03.02.2021 by Oracle Team

By Franck Pachot . You want to learn and practice your ODA command line and GUI without having an ODA at home? It should be possible to run the ODA image on VirtualBox but that’s probably a hard work(…)

Oracle

19c serverless logon trigger

31.01.2021 by Oracle Team

By Franck Pachot . I thought I already blogged about this but can’t find it. So here it is, with a funny title. I like to rename oracle features by their user point of view (they are usually named(…)

Database Administration & Monitoring

Pressure Stall Information on Autonomous Linux

09.01.2021 by Oracle Team

By Franck Pachot . The Linux metrics that are usually considered for performance monitoring and troubleshooting have many drawbacks and frequent misinterpretations. The recent kernels provide PSI (Pressure Stall Information) which is not enabled by default in Oracle Linux(…)

Oracle

Optimizer Statistics Gathering – pending and history

29.12.2020 by Oracle Team

By Franck Pachot . This was initially posted to CERN Database blog on Wednesday, 12 September 2018 where it seems to be lost. Here is a copy thanks to web.archive.org Demo table I create a(…)

Oracle

Password rolling change before Oracle 21c

27.12.2020 by Oracle Team

By Franck Pachot . You may have read about Gradual Password Rollover usage from Mouhamadou Diaw and about some internals from Rodrigo Jorge. But it works only on 21c which is(…)

Oracle

Oracle SPD status on two learning paths

19.12.2020 by Oracle Team

By Franck Pachot . I have written a lot about SQL Plan Directives that appeared in 12c. They were used by default and, because of some side effects at the time of 12cR1 with legacy(…)

Oracle

Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID

15.12.2020 by Oracle Team

By Franck Pachot . This was initially posted to CERN Database blog on Thursday, 27 September 2018 where it seems to be lost. Here is a copy thanks to web.archive.org Did you ever try to(…)

Oracle

Oracle write consistency bug and multi-thread de-queuing

14.12.2020 by Oracle Team

By Franck Pachot . This was initially posted on CERN Database blog where it seems to be lost. Here is a copy thanks to web.archive.org Additional notes: – I’ve tested and got the(…)

Cloud

Recovery in the ☁ with Oracle Autonomous Database

18.11.2020 by Oracle Team

By Franck Pachot . I’ll start this series with the Oracle Autonomous database but my goal is to cover the Point In Time recovery for many managed databases in the major cloud providers. Because I’ve seen lot of confusion(…)