Create the TDE Wallet
Published by : Obay Salah , November 20, 2024
After locating the Software Keystore, you can now create the TDE Wallet. There are three types of TDE Wallets:· Password-protected... Continue Reading
Transparent Data Encryption
Published by : Obay Salah , November 20, 2024
Oracle Advanced Security includes features such as Transparent Data Encryption (TDE), which encrypts data at rest transparently. TDE is used to protec... Continue Reading
The Segment Advisor
Published by : Obay Salah , November 20, 2024
We previously discussed the logical and physical components of the database and identified that objects such as tables and indexes are stored logicall... Continue Reading
The SQL Access Advisor
Published by : Obay Salah , November 20, 2024
The SQL Access Advisor works similarly to the SQL Tuning Advisor, and the analysis will focus on testing the impact of adding a new index and also, up... Continue Reading
The Automatic Database Diagnostic Monitor (ADDM)
Published by : Obay Salah , November 20, 2024
As mentioned earlier, the MMON writes statistics from memory to disk in the AWR in what is known as a Snapshot. The MMON Background Process also gener... Continue Reading
The Automatic Workload Repository (AWR)
Published by : Obay Salah , November 20, 2024
Oracle collects a large amount of statistical data regarding performance and activity. This data accumulates in memory and is then written periodicall... Continue Reading
Optimizer Statistics
Published by : Obay Salah , November 20, 2024
There are many ways to execute SQL statements, and the process of choosing an execution plan for SQL statements is highly influential on perform... Continue Reading
Rebuild Invalid Inexes
Published by : Obay Salah , November 20, 2024
The Database Administrator can repair unusable indexes by rebuilding them using the command: ALTER INDEX … REBUILD This command creates a new index th... Continue Reading
Unusable Indexes
Published by : Obay Salah , November 20, 2024
Indexes can also be unsuitable for use at times. The index is essentially a pointer to the Physical Location. Let’s assume I created a table cont... Continue Reading
Invalid Objects
Published by : Obay Salah , November 20, 2024
One of the most important things that affect performance is invalid objects, such as (Procedures, Indexes, Materialized Views, Views, Triggers, Packag... Continue Reading