Oracle Database Administration and Development

For which two requirements can you always use the V$ACTIVE_SESSION_HISTORY view? (Choose two.)

To investigate the slow response time of queries on the TRANS table, you gathered the table statistics and executed the query: The table is stored in a tablespa...

You observe that queries are performing poorly on the SALES_RECORDS table in your database. On investigation, you find that at the end of each day the contents...

You have been asked to assess if using column store compression (previously known as hybrid columnar compression or HCC) would help improve the performance of q...

You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%. Which two sources shou...