X

Carlos Orozco's Blog

Recent Posts

Carlos Orozco's

The Docker is in for the DBA. Oracle database with docker and Kubernetes too

  Someone recently asked me if Oracle database can run in a docker container and also leverage Kubernetes.  As the cloud wars continue... seems there are quite a few folks out there looking for cloud neutral solutions to run their orchestration and container management solutions on top of Kubernetes Well early in 2017, Oracle developers have made 12c database available in the docker store. So you can get Oracle database from the docker store or you can go to Github and get docker build files for oracle. This combination will allow you to create a Docker container that has the latest 12.2 database and is persisted. Here's what you can do.     1. Go to https://github.com/oracle/docker-images and download the Oracle Docker build files. 2. Go to http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html and download Oracle Database 12c Release 2 for Linux x86-64. 3. You should now have two files:      i. docker-images-master.zip    ii.  linuxx64_12201_database.zip you can follow Maria Colgen's blog at https://sqlmaria.com/2017/04/27/oracle-database-12c-now-available-on-docker/ for more details. and also visit https://geraldonit.com/2017/08/21/creating-an-oracle-database-docker-image/ to get more details on how this is done.    I'd like to know how many folks out there are looking to deploy Oracle with Docker and Kubernetes.   Some other useful links: https://www.oracle.com/technetwork/articles/cloudcomp/deploy-database-in-container-cloud-3876722.html https://github.com/oracle/docker-images/tree/master/OracleDatabase/RAC https://github.com/oracle/docker-images/tree/master/OracleDatabase/RAC/OracleRealApplicationClusters https://github.com/arkalira/Dockerized-Oracle-Database-12c/blob/master/Oracle%20DB%2012/Create%20Oracle%2012c%20service%20in%20Kubernetes%20Cluster.md

  Someone recently asked me if Oracle database can run in a docker container and also leverage Kubernetes.  As the cloud wars continue... seems there are quite a few folks out there looking for cloud...

11g database

Database Slowness?

Slowness could be perceived as taking long and not always what you think. Taking a look at your resource usage, CPU, Memory and I/O can be done with Enterprise Manager. I can view historical data to see where there may have been a high demand for any of these resources. Enterprise Manager will also allow you to drill down into the AWR snapshots and report back on SQL executing at that time. You can locate resource consuming SQL identified by the Automatic Database Diagnostic Monitor (ADDM) which analyzes the AWR data on a regular basis, then locates the root causes of performance problems, provides recommendations for correcting any problems. Sometimes, workloads take longer due to sub optimal execution plans. Something that may have completed in a minutes or seconds may now be taking hours or days due to changes in the plan. Plan is determined by the optimizer and if the data load process did not collect stats or potentially the data was loaded after a stats job runs, you may be a seeing poor cardinality estimates from the optimizer on the stats collected. If you note a big discrepancy between estimated rows and actual rows processed, you have to deal with it by collecting stats. It may required extended stats as well. I would explore using SQL Monitor to look at any SQL have identified as taking longer. Another tool you can use is SQLT available from Oracle support at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=215187.1 The reports may include some content provided by the Oracle Diagnostic and/or the Oracle Tuning Packs (in particular SQL Tuning Advisor "STA", SQL Tuning Sets "STS", SQL Monitoring and/or Automatic Workload Repository "AWR"). Be aware that using this extended functionality requires a license for the corresponding pack. If you need to disable SQLT access to one of these packages, please execute one of the following commands connected as SQLTXPLAIN: SQL> EXEC sqlt$a.disable_tuning_pack_access; or SQL> EXEC sqlt$a.disable_diagnostic_pack_access;SQLT was written by Carlos Sierra who worked in Oracle's support division and later moved on to Enketec https://www.enkitec.com/about/bios/carlos.sierra - you can also look for a great book titled "Oracle SQL Tuning with Oracle SQLTXPLAIN, author Stelios Charalambides"

Slowness could be perceived as taking long and not always what you think. Taking a look at your resource usage, CPU, Memory and I/O can be done with Enterprise Manager. I can view historical data to...

Engineered Systems

Exadata Workshop / Orlando March 20th

We are having an “Introduction to Exadata & EM12c Hands On Workshop”! The Hands On Workshop” being held March 20th in Orlando, Florida in the Oracle Orlando office. This workshop is a companion to the popular Oracle “Exadata/EM12c Operations Workshop” and features lab exercises that offer Database Administrators and others who have RAC and ASM experience an insight into:Monitoring Exadata and storage with Enterprise Manager 12c, including analyzing performance, SQL performance and storage cells.Managing query performance, including parallel queries, Smart Scan, query offloading and partition elimination.Using compression on Exadata, including the Compression AdvisorI hope that you haven't had a chance to attend one of these workshops that you contact your local sales rep and find a workshop near you. I alway hear rave reviews from folks just getting familiar with Oracle's Engineered Systems, they really get to see what is it about Exadata that sets it apart from other general purpose built systems. It's not just a bundling of hardware, it's the software optimizations that deliver the incredible performance we've seen. If you find a workshop, sign up, you won't regret it.

We are having an “Introduction to Exadata & EM12c Hands On Workshop”!The Hands On Workshop” being held March 20th in Orlando, Florida in the Oracle Orlando office. This workshop is a companion to...