DBA Advanced

In today’s world, everything is about speed; what’s not instant is not good enough. If you have ever experienced slow responses from your database, this article is for you. Oracle …

How To Cache Oracle Database Read More

Oracle has a great utility for performance debugging and query tracing; AUTOTRACE. It’s probably one of the most overlooked tools considering how powerful it could be. I will explain now, …

How To Trace Queries in Oracle with AUTOTRACE Read More

Oracle Virtual Private Database (VPD) is an awesome tool you can use to secure your data. It allows you to restrict data on row and/or column level for each user …

Oracle Virtual Private Database Read More

Oracle Data Masking and Subsetting allows you to secure access to your data. It supports multiple modes of anonymization, data masking, and data securitization methods with some predefined functions and …

Data Masking and Subsetting Read More

Oracle Database Vault is a security enhancement provided by Oracle to ensure unauthorized users to access your sensitive data. What is brilliant about this is that it works on privileged …

Oracle Database Vault Read More

Multi-user databases require a mechanism to handle data concurrency, consistency, and integrity. Data has to be consistent throughout any transaction executed in the database system and therefore Oracle implemented locks. …

Data Concurrency, Consistency, And Locks Read More

Whenever you insert a record in a table, the record is stored in a data block and is assigned with ROWID. If you try to update the record, data inside …

Chained Rows – Problems And How To Fix Them Read More

Automatic Workload Repository (AWR) is a vital tool for database administrators to detect issues that are in the database or are about to develop. This built-in repository (residing in SYSAUX …

How To Read AWR Report Read More