Hey I had a thought.

Yesterday, I rebuilt all indexes, coalesced all tablespaces, analyzed everything. Also coalesced the indexes after the rebuild.

This could possibly have affected my DB. .

Do you think its possible I retrieved like 200 Meg from a 500 Meg file.