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_uncmp
SELECT /*+ FULL(.