You are working as a DBA for a DSS system, on which applications primarily perform large sequential I/Os. The company wants to upgrade the storage used by the database to faster hard disks.
What other factors would you consider before giving the go-ahead for the new hard disks? (Choose all that apply.)
A.
the sizing of PGA to meet the faster data access
B.
the sizing of buffer cache to meet the faster data access
C.
the time it takes for a submitted I/O request to be serviced by the storage
D.
the capacity of the I/O channel that connects the server to the storage array
why not A?
In DSS a system PGA should be about 70% of total memory
Yes, but we consider disk approach. Before someone buy new disk we have to make sure that they met DB requirements.