Multiple choice technology databases

Logging for any SQL on a RAC env what information must pass to log module for proper identification of the source of the log ?

  1. instance

  2. sid

  3. serial# the session connects to

  4. ALL
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In a RAC environment, proper SQL logging requires instance number, SID, and serial# to uniquely identify the session and instance generating the log. RAC has multiple instances, so all three identifiers are necessary to trace logs to the exact source. Missing any identifier makes it impossible to determine which instance or session generated a particular log entry.

Keep practicing — related questions