Oracle

1Z0-417 · Question #46

Which two would automatically create an entry in V$SQL_MONITOR?

The correct answer is C. any DML statement F. any DDL statement. https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL789

SQL Tuning

Question

Which two would automatically create an entry in V$SQL_MONITOR?

Options

Aa parallelized SQL statement
Bany SQL statement run
Cany DML statement
Da statement that consumes at least 1 second of CPU or I/O time.
Ea statement that consumes at least 5 second of CPU or I/O time.
Fany DDL statement

How the community answered

(25 responses)

B
4% (1)
C
80% (20)
D
12% (3)
E
4% (1)

Explanation

https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL789

Topics

#SQL monitoring#V$SQL_MONITOR#parallel execution#SQL execution

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-417 Practice