DB Encryption issues

Has anyone researched or deployed database encryption using MS SQL or Oracle? What were the biggest challenges during deployment and subsequent usage? What key management approach did you decide to employ?

Thanks,
Greg