Database auditing refers to the monitoring and logging of user activity. It is the most accurate record of any database activity. Auditing helps us keep track of what happened in the database, when it happened and who did it. It also allows us to track the use of privileges, activities of highly privileged users, access
Introduction LATERAL is a join type that allows a subquery to use columns from tables that appear earlier in the FROM clause of the query. It lets us build a mental model of exploring data from the inside out. This feature lets us work with subqueries in a unique way, allowing them to reference columns
What is the High Water Mark (HWM)? The high water mark in oracle refers to a point in a segment beyond which data blocks are unformatted and have never been used. If we imagine a data block as a Rectangular block of data that fills up from left to right, then the high water mark
