Practice Test Geeks1Z0-082 - Oracle Database Administration I Practice Test
← All 1Z0-082 Flashcard Decks

Oracle Database Monitoring and Auditing Flashcards

6 cards from real 1Z0-082 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Oracle Database Monitoring and Auditing flashcards as text

  1. Which dynamic performance view provides detailed wait event information for each current session in Oracle?

    Answer: V$SESSION_WAIT

    V$SESSION_WAIT shows the current or most recent wait event for each active session, including the event name, wait time, and state.

  2. What information does the V$SESSION_WAIT view provide to a DBA?

    Answer: The current or last wait event, wait class, and time waited for each session

    V$SESSION_WAIT displays the event each session is waiting on, the wait class (e.g., I/O, concurrency), and how long it has been waiting, helping identify bottlenecks.

  3. How is an AWR report typically generated from the Oracle command line using SQL*Plus?

    Answer: By running the awrrpt.sql script from $ORACLE_HOME/rdbms/admin/

    The awrrpt.sql script located in $ORACLE_HOME/rdbms/admin/ is run from SQL*Plus to interactively generate a text or HTML AWR report for a specified snapshot range.

  4. What is the default AWR snapshot collection interval in Oracle Database?

    Answer: 60 minutes

    By default, Oracle's AWR collects database statistics snapshots every 60 minutes and retains them for 8 days, configurable via DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS.

  5. Which dynamic performance view is best for identifying the top SQL statements consuming the most elapsed time in Oracle?

    Answer: V$SQLAREA

    V$SQLAREA provides aggregated statistics for each unique SQL statement including elapsed time, CPU time, buffer gets, and executions, making it ideal for top SQL analysis.

  6. What is the purpose of the Oracle Statspack tool?

    Answer: To collect and store point-in-time database performance snapshots for trend analysis before AWR was introduced

    Statspack is a predecessor to AWR that collects performance snapshots into the PERFSTAT schema; it is still available in Oracle Database as a free alternative to the licensed AWR feature.