• Ratheesh.K.Nair (9/23/2014)


    we killed oldest active transaction and suddenly all data files got 99% free space and we were able to release more than 120GB.

    Did you look at the code the transaction was executing before you killed it? It could have created huge temptable(s), or sorting an extreme dataset, or.... And did you look at the user hat was executing the killed action or from what host the action was coming from? These info could give you a starting point for your investigation.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **