Penn's DBAs said Oracle recommends these indexes. Applying them helped a SQL extract work (it worked, then for some reason it stopped, and this helped it)

create index GROUPER_FIELDS_TYPE_IDX on GROUPER_FIELDS (TYPE)

create index GROUPMEM_OWNID_FIELDID_IDX on GROUPER_MEMBERSHIPS (OWNER_ID,FIELD_ID)