When using Transparent Data Encryption, you might wonder “What is the state of my transparent data encrypted database?” There are many different states that a transparent data encrypted database might go through. Those states go from not being encrypted to being completely encrypted, and a few others related to managing the encryption keys.
You probably already know that when you encrypt a database with transparent data encryption it takes a while for the entire database to be encrypted. The same is true when you turn off transparent data encryption, it takes a while to decrypt your data.