Different database design for OLTP and DSS

DSS = Data warehousing
online things processing	Data Warehouse
For example: aircraft booking, online trading, BBS, etc.	example: Various resource information query system
large number of online users and DML operations	very few DML operations
a large number of indexed queries	a large number of full table scanned queries
with B-tree,reverse key index, periodic index rebuild	Bitmap index
> need more small fallback sections/td>
don't use distributed queries
data object Storage Parameters pc Tfree 20 or higher	data Object Storage parameter Pctfree 0
Share program code and various variable constants	character variables and clues
boot multi-thread service	use large blocks of data, Db_file_mutiblock_read_count
Use a larger log file	Use a smaller log file
listener Open multiple response ports	add sort_area_size