Size of typical transactions
Concurrent transactions
Size of rows in table most frequently changed
Number of anticipated disk sorts
第1题:
When analyzing disk I/O performance, which of the following metrics and/or statistics should be included in the study?()
第2题:
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
第3题:
A retail customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations. Which questions will provide the information necessary to design the best performing storage solution of the following?()
第4题:
You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()
第5题:
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
第6题:
A customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations. Which of the following questions will provide the information necessary to design the best performing storage solution?()
第7题:
Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()
第8题:
Which important factor is taken into account when determining an estimate for the maximum network bandwidth to be used by a customer?()
第9题:
You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()
第10题:
Which two statements are true regarding transactions in an Oracle database()