If you don't give any information you are wasting our time.
How big will the database be ? What will the users be running ? Where is the data coming from ? What is the DWH for ? What disk storage ? Single instance or RAC ? What budget ? How much RAM ? What hardware ?
If you want to run a serious Oracle datawarehouse, please don't run it on Windows. Put it on an OS that works - e.g Linux or Solaris or AIX.
Actually Robert they have decided to build a seperate application for datawarehousing.
We need to decide what are the changes can be done from OLTP. In the sense like schema redesigning and partioning etc., So that I'm searching for what are the feature will improve the performance in Data warehouse mode from the database perspective.
they are going to use this to keep query our 10 years record.
People get paid huge amounts of money to design high performance datawarehouse schemas, and it takes months or years. There are many design methods, starting with the report requirements, then working back to the data source.
Datawarehouses can benefit from partitioning, table compression, transportable tablespaces, larger block sizes, materialised views, streams, bitmap indexes, fact and dimension tables etc.
A forum is really not the place to learn this. Best to get a good book on Oracle DWH design. Others on this forum may be able to recommend one.
I found couple of link for data warehouse environment in oracle :