we ran the report one more time and monitored the sga usage through TOAD the report is requiring more than 1GB of SGA_AGGRe... , we decided to break the report down.