Jodie,
Thanks for your response. I'm yet to familiarize myself with the TSM commands. Our TSM admin is relatively new to this as well.

The below statement has been running for the last 1 hour in TSM!
select * from contents where node_name='DWDEV01_ORA' <- my node name.

I'm gonna have to kill it. The io seems pretty high..We run a whole lot of file system backups (1.5 Tb worth) from TSM everyday. That could be why the table is so huge.

Btw, what does a typical RMAN file_name (in the contents table) look like? Is this identical to the RMAN backupset piece name by any chance??

- Anand