One of our Production database has a rather peculiar block size of 16KB. This database was created about 2 years ago and at that time the size of the db was approx 1TB only.
However over the past 2 years the db size has grown to approx 5TB.
The workload is a mix of OLTP (transaction) as well as OLAP (reporting).
This db block size is causing our DB Buffer Pool to be constantly filled up (95%~100% full).
The db uses ASM on Raw Devices.
Is the 16KB db block size sub-optimal?
Can this large block size be adversely impacting our storage sub-system performance?
If so what can be done to remedy the situation?
Noteworthy here is that we do in fact perform huge full table scan for reporting as well as for our application (business logic).
The OLTP nature stems from the fact that our application also has transactional (financial transaction) module.