OLTP environment Tuning
Hi,
DB Environment:
DB Version : 11.1.0.7
OS : AIX 6.1
RAC : 2 node cluster
We are running 2 node RAC production database. Our DB supporting for OLTP.
Right now the database block size is 8k.
Please find some of my question on the OLTP environment:
Scenario:
Some of my tables are holding more than 2000 million records. Our application serves for leading telecom vendor. So the callers are get validated from the large customer base tables and billing tables.
Questions:
1. Can i create separate tablespace for larger tables? If so keeping 2 GB datafiles in that tablespace, will gain any performance improvement?
2. Creating 6 GB datafiles will affect the performance?
DB Environment:
DB Version : 11.1.0.7
OS : AIX 6.1
RAC : 2 node cluster
We are running 2 node RAC production database. Our DB supporting for OLTP.
Right now the database block size is 8k.
Please find some of my question on the OLTP environment:
Scenario:
Some of my tables are holding more than 2000 million records. Our application serves for leading telecom vendor. So the callers are get validated from the large customer base tables and billing tables.
Questions:
1. Can i create separate tablespace for larger tables? If so keeping 2 GB datafiles in that tablespace, will gain any performance improvement?
2. Creating 6 GB datafiles will affect the performance?
0