Over the weekend one of the databases hung due to the flash recovery area was 100% full. I noticed one J001 process consuming significant CPU and I/O resources. Turns out this process was the automatic segment advisor job that runs on the weekend maintenance window.The SQL executed was something like:CREATE TABLE .dbms_tabcomp_temp_uncmpTABLESPACE NOLOGGINGASSELECT /*+ FULL(.)… Continue reading Compression Advisor killed my database!
The repvfy Kit is very useful when you are trying to diagnose a problem in OEM Cloud Control 12c. I noticed that some of the tasks from the dbms_scheduler weren’t running on time, hence creating a backlog in the repository.In order to get more information about this issue, you can make use of the repvfy Kit.… Continue reading Using repvfy to find problems in the OEM 12c repository
If you’re running pluggable databases (multitenant) in Oracle 12c, you may wonder; how do I open the pluggable database (PDB) when I start the container database (CDB)?Well, really it depends on the 12c version you are running on. I will show you the options you have depending the version you are running.If you are running… Continue reading How do I open the pluggable database (PDB) when I start the container database (CDB)?
Today’s post is about a neat Oracle EM 12c feature. I spoke in the past Collaborate 2015 about deploying multiple plug-ins at once using emcli to save time. I used emcli because the console didn’t have the option to do that. Guess what? the new release 188.8.131.52 has the option to do it from the… Continue reading Deploy multiple plug-ins at once using OEM 184.108.40.206 console
I noticed that the Oracle Enterprise Manager (OEM) repository database was throwing ORA-21780 errors every 10 seconds. This is what I found in the alertlog file:Mon May 11 17:51:56 2010Errors in file /oracle_binaries/app/diag/rdbms/oem/OEM1/trace/OEM1_smon_12465.trc:ORA-21780: Maximum number of object durations exceeded.Errors in file /oracle_binaries/app/diag/rdbms/oem/OEM1/trace/OEM1_smon_12465.trc:ORA-21780: Maximum number of object durations exceeded.Now looking at the SMON trace file:*** 2015-05-11… Continue reading ORA-21780: Maximum number of object durations exceeded.
This is the recorded presentation of the Oracle Enterprise Manager 12c @JoinSQL seminar held in Romania last month. Hope you find it interesting. Click Here!
I uploaded the slides of my IOUG's Collaborate presentation about OEM 12c.Click Here!Thanks,Alfredo
I uploaded the slides of my IOUG's Collaborate presentation.Click here!Thanks,Alfredo
Today I want to talk about a free Database Seminar that ACI is sponsoring in Timisoara, Romania. A friend of mine and former co-worker asked me to speak in the seminar about Oracle Enterprise Manager Administration. Because of the Time zone’s differences, I’m going to make a recording of the presentation and upload it to the… Continue reading Free Database Seminar in Timisoara, Romania
If you are planning to upgrade your OEM to 220.127.116.11 and you have RMAN jobs scheduled in Cloud Control, you should consider applying patch 19519190 to the OMS. I noticed that most of the RMAN jobs were having issues and even worst, some steps were empty!!! Obviously, the jobs were succeeding as the step is empty.… Continue reading RMAN jobs not working after OEM upgrade to 18.104.22.168