1.联机事务处理 - OLTP - small size transaction/large number transaction - small db_block_size, small roll back segment size - lot of insert/update/delete, minor report etc....
2. 数据仓库 - OLAP/DSS - big size transaction/very small number transaction (such as data loading) - big db_block_size, big roll back segment size - a lot of queries for report, etc.....
3.多用途:combin OLTP and OLAP, such as daytime, OLTP, night time, OLAP
|