Multiple choice technology databases

The primary goal of logging is to ensure that if your PL/SQL block has performance problems once deployed to production you should be able to identify the exact SQL or other PL/SQL component (eg a loop) that is causing the issue.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The PRIMARY goal of logging is debugging and troubleshooting during development and testing, not production performance monitoring. In production, you use tools like AWR, ASH, and SQL Trace for performance issues. The statement incorrectly claims production performance identification is the PRIMARY goal of logging.

Keep practicing — related questions