Dave, It makes more sense to me now. Let me list out the possible solutions to resove this problem. I just want to have better understanding.

Please let me know if i am wrong.

1. Normalize the table and reduce the number of columns in the
GROUP BY clause.

2. Create a tablespace with highest possible DB_BLOCK_SIZE for this table.

3. Using by "USING NO INDEX" clause.