Oracle 12c Upgrade: 13 – Real-Time Database Operation Monitoring

Card Set Information

Author:
Tralala
ID:
297942
Filename:
Oracle 12c Upgrade: 13 – Real-Time Database Operation Monitoring
Updated:
2015-03-09 03:59:13
Tags:
Real Time Database Operation Monitoring
Folders:
Oracle 12c Upgrade
Description:
Oracle 12c Upgrade: 13 – Real-Time Database Operation Monitoring
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. What is Real-Time Database Operation Monitoring?
    • A way of tracking a set of SQL statements
    • Part of the tuning pack and subject to licence.
    • Can find out where a SQL statement is current in the plan
  2. In Real-Time Database Operation Monitoring, what is a database operation?
    One or more SQL statements running in a single or concurrent sessions
  3. In Real-Time Database Operation Monitoring, what are the two types of database operation?
    • SIMPLE: A single SQL or PL/SQL database operation
    • COMPOSITE: Multiple SQL PL/SQL database operations running in a single or concurrent sessions.
  4. What is the main difference between 11g and 12c Real-Time Database Operation Monitoring
    • In 11g it was only possible to monitor simple operation
    • In 12c Real-Time Database Operations provide the ability to monitor composite operations
  5. By default, when does Real-Time SQL Monitoring automatically start?
    • When a SQL statement runs in parallel
    • When 5 secs of CPU or IO has been consumed in a single session
  6. From where can Real-Time SQL Monitoring information be accessed?
    • EMCC
    • Data Dictionary view
    • DBMS_MONITOR package
  7. What must the STATISTICS_LEVEL and CONTROL_MANAGEMENT_PACK_ACCESS level be set to to start Real-Time SQL Monitoring?
    • STATISTICS_LEVEL: TYPICAL or ALL
    • CONTROL_MANAGEMENT_PACK_ACCESS: DIAGNOSTIC+TUNING
  8. How is a database operation identified in Real-Time SQL Monitoring
    • An operation name
    • An operation ID
  9. Which view and which columns in that view identifying a Database Operation?
    • V$SQL_MONITOR
    • SQL_ID (SQL Statement ID)
    • SQL_EXEC_START (Time of the sql execution start)
    • SQL_EXEC_ID (The unique execution id)
  10. How is a single statement monitored, how is monitoring of the statement stopped?
    • Started: Using the hint /*+ MONITOR */
    • Stopped: Using the hint /*+ NOMONITOR */
  11. At what levels can Real-Time Database Operation Monitoring be done?
    • Statement Level - /*+ (NO)MONITOR */
    • Database Operation Level - DBMS_SQL_MONITOR.BEGIN|END_OPERATION
    • System Level - All parallel and 5 secs of CPU or IO statements
  12. What are the tasks to monitor a database operation in Real-Time SQL Monitoring?
    • DBMS_SQL_MONITOR.BEGIN_OPERATION
    • Run the operation
    • DBMS_SQL_MONITOR.END_OPERATION
  13. In DBMS_SQL_MONITOR.BEGIN_OPERATION, what does FORCE_TRACKING achieve?
    • By default only parallel and 5 secs of CPU or IO statements are tracked, forced_tracking tracks all operations
    • NO_FORCE_TRACKING is default
  14. What is the syntax to begin a Real-Time SQL Monitoring?
    • DBMS_SQL_MONITOR.BEGIN_OPERATION (
    • dbop_name IN VARCHAR2,
    • dbop_eid IN NUMBER := NULL,
    • forced_tracking IN VARCHAR2 := NO_FORCE_TRACKING,
    • attribute_list IN VARCHAR2 := NULL)
    • RETURN NUMBER;
  15. What is the syntax to end a Real-Time SQL Monitoring?
    • DBMS_SQL_MONITOR.END_OPERATION (
    • dbop_name IN VARCHAR2,
    • dbop_eid IN NUMBER := NULL,
    • RETURN NUMBER;
  16. How is a Real-Time SQL Monitoring report generated?
    DBMS_SQL_MONITOR.REPORT_SQL_MONITOR
  17. For which execution does DBMS_SQL_MONITOR.REPORT_SQL_MONITOR report?
    The most recent
  18. How can the state of an operation be determined?
    From the STATUS column of V$SQL_MONITOR
  19. What is the recommended method of viewing Real-Time SQL Monitoring reports?
    EMCC
  20. What tool can be used to find expensive SQL statements?
    Real-Time SQL Monitoring
  21. What tool can be used to compare current job execution with the previous executions?
    Real-Time SQL Monitoring

What would you like to do?

Home > Flashcards > Print Preview