> I'm trying to figure out what might have slowed down considerably
a specific query these past days.

If Siebel uses RBO then it is most-likely a partially analysed schema.

Look for "accidental" stats on any table, and remove them:

select table_name from dba_tables where num_rows > 1;