An OLTP database was being operated in manual undo management mode and it was noticed that the query SELECT COUNT(*) from V$TRANSACTION is always less than or equal to 160 during peak transaction hours. How many rollback segments should be configured?

Keep practicing — related questions

• If you have committed several transactions and have several more transactions that have not been committed ...
• What should you look at to compute the number of undo blocks written per second on disk ?
• What should you look at to compute the number of undo blocks written per second on disk ?
• What should you look at to compute the number of undo blocks written per second on disk ?
• What should you look at to compute the number of undo blocks written per second on disk ?
• A database has several simultaneous long-running insert transactions. The following statement was issued to...
• A database has several simultaneous long-running insert transactions. The following statement was issued to...
• A database has several simultaneous long-running insert transactions. The following statement was issued to...