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