Which of the following Dynamic Performance views contain information relevant to SQL Tuning? Each correct answer represents a part of the solution. Choose all that apply..

Answer: A,B,C,D

Explanation: Answer options D, B, A and C are correct. Dynamic views containing information relevant to the SQL tuning are V$SQL, V$SQLAREA, V$SQLSTATS, and V$SQL_BIND_DATA. V$SQL lists statistics on shared SQL area without the GROUP BY clause and contains one row for each child of the original SQL text entered. Statistics displayed in V$SQL are normally updated at the end of query execution. However, for long running queries, they are updated every 5 seconds. This makes it easy to see the impact of long running SQL statements while they are still in progress . V$SQLAREA lists statistics on shared SQL area and contains one row per SQL string. It provides statistics on SQL statements that are in memory, parsed, and ready for execution. V$SQLSTATS returns basic performance statistics for SQL cursors, with each row representingthe data for a unique combination of SQL text and optimizer plan (that is, unique combination of SQL_ID, and PLAN_HASH_VALUE). The column definitions for columns in V$SQLSTATS are identical to those in the V$SQL and V$SQLAREA views. However, the V$SQLSTATS view differs from V$SQL and V$SQLAREA in that it is faster, more scalable, and has a greater data retention (the statistics may still appear in this view, even after the cursor has been aged out of the shared pool). Note that V$SQLSTATS contains a subset of columns that appear in V$SQL and V$SQLAREA. For each distinct bind variable in each cursor owned by the session querying the V$SQL_BIND_DATA view, this view describes: Actual bind data, if the bind variable is user defined The underlying literal, if the CURSOR_SHARING parameter is set to FORCE and the bind variable is system.