Sapdata Directory Sizes for ECC 6 10g

[matthew_stroh]

I am trying to determine a good size for sapdata1-sapdata3. We currently are 4.6C on 8.17 and will be going to ECC6 on 10g and Unicode. I will changing from Roll to Undo management.

The tablespaces can be found in the following mount points.

sapdata1 - system, sysaux tablespaces,

sapdata2 - psapundo tablespaces

sapdata3 - psaptemp

My current size on 8.17 is

PSAPTEMP - 8GB

psaproll 6GB

system .6GB

Whole database is around 460GB

I am trying to determine a good size for the luns that I will present to the host for mount points above. Right Now I am thinking

sapdata1 = 5GB

sapdata2 = 20 GB

sapdata3 = 20 GB.

Any advice would be great.

Thanks for the help.

Matthew

[matthew_stroh · Accepted solution]

My Biggest index is around 3GB. So I am guessing 20 GB will probably be plenty of space for the psaptemp. The undo is probably one of those things you really don't know until you start using it in a production environment.

Is there anything I could look at in my current 8.17 environment to determine how big I should make it?

Thanks.

Matthew

[former_member204746 · Accepted solution]

size PSAPUNDO the same as your actual PSAPROLL to start with.

play around with undo_retention value in initSID.ora of SPFILE. A value of 14400 if too big for most systems.

on my systems, I run this command every hour:

connect / as sysdba

set head off

spool c:\admin\log\undo_monitor_tmp.log

select max(maxquerylen) from v$undostat;

exit;

this shows me the oldest undo segment in the system

[Former Member]

We are making it even for SAPDATA1,2,3 and 4. We are also planning to evenly spread the data across all the Sapdata, one thru 4.

[matthew_stroh]

That is how I was doing it.

Here is my new thoughts

sapdata1 = 10 GB

sapdata2 = 20 GB probably

sapdata3 = 20 GB probably.

sapdata4-15 = 100 GB

spread the data between sapdata4-15.

The main reason I am thinking of change it to this way is get a structure to how it normally installs the system.

Matthew

[former_member204746]

sapdata1 is not big enough, I would go with 10GB

sapdata2: depends on system size.

sapdata3: depends on the size of biggest index * 1.5