This week, I lent a hand to a friend who had a session stuck in the database. By the time he got in touch, he’d already terminated the session in both the database and the Operating System. He mentioned that neither the database session nor the OS process had actually died. The database session was[…]
Hi folks, It’s been a while I’m only working and not publishing much content. Late 2024 and beginning for 2025 I started posting some videos in my YouTube channel, but even that came to a hiatus due to family and work demands. Today I’m releasing a new script that is based on Fred Denis’ exa-racklayout.sh[…]
Hi people, It’s been 3 weeks since I updated the OS of the VMs of one of our client’s Exadata Cloud at Customer (ExaCC) in their DR site. The update was performed from Exadata image 19.2.x to 22.1.10.230422 using the OCI console without any issues. There was a huge leap in the image version because[…]
Introduction In today’s data-driven world, businesses need robust and scalable data warehousing solutions to stay ahead of the competition. Two key players in this domain are Oracle Autonomous Data Warehouse (ADW) and Snowflake Data Cloud. Both platforms offer unique features and capabilities for businesses looking to leverage the power of their data. In this blog[…]
Setup for this case: Two Gen2 Exadata Cloud At Customer X8 quarter rack (2 dbnodes + 3 cells): One ExaCC in NYC being the primary PRODDB is the primary RAC database running in 2 nodes in the NYC cluster. One ExaCC in SLC being the standby PRODDBB is the standby RAC database running in 2[…]
Organizations rely on their databases to store critical business data, making it essential to have a reliable backup solution in place. However, as databases grow larger and more complex, ensuring the recoverability of data becomes increasingly challenging. In this blog post, we’ll explore how large corporations overcame these challenges by implementing Oracle Zero Data Loss[…]
Hello folks, Let’s see how Smart Scan works. It has been a while I don’t write anything in the blog, but is always good to come back here and also participate on the OGB Appreciation Day, organized every year by Tim Hall from the Oracle Base. This year I decided to quickly write about Exadata[…]
Hello folks, it has been a while I don’t post anything and this will be a quick one, but useful. Recently, Oracle announced some changes in their certification program for DBAs. There is no more OCA for DBA, only OCP. There is no SQL exam as a pre-requisite, SQL questions are included in the ADM[…]
Olá pessoal, aqui vai uma pequena nota mental de como executar o utilitário OEWizard do Swingbench em modo texto. Neste exemplo estou executando a partir do servidor de banco de dados mesmo e para isso é necessário ter o Java instalado. A versão 2.6 do Swingbench requer o Java 1.8 e este já vem junto[…]
Olá pessoal, Só passando aqui para lembrar alguns e informar os que não sabem que amanhã às 21:00 (BRST) vou apresentar sobre ajuste de memória do servidor e do banco de dados Oracle no Terças de Dados do DBA Brasil. A apresentação é ao vivo no canal do YouTube: https://www.youtube.com/watch?v=9ffxHJLm8ao Deixe de ser um Padawan e[…]