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 tablespace that has Automatic Segment Space Management (ASSM) enabled. The tablespace is created with a standard block size of8192 bytes.Which three can be reasons for the slow response time of the queries? (Choose three.)
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 of the SALES_RECORDS table are moved to the SALES_HISTORY table. The delete operations cause the table to be sparsely populated.The SALES_RECORDS table is created in a tablespace using Automatic Segment Space Management (ASSM) and row movement is enabled. The table must be accessible 24x7.Which two tasks would you recommend to improve the performance? (Choose two.)
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 queries on some large tables.Which three aspects should you consider before you choose this compression method? (Choose three.)
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 should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)
You want to capture the performance of your database during the last ten days of the first quarter of the current financial year, so that you can compare this performance against the remaining quarter ends of the current financial year.Which method should you use? (Choose the best answer.)
Your database supports multiple applications. The applications run on the middle tier and use connection pooling for connecting to the database.You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.What action must you perform to achieve this? (Choose the best answer.)
