8 Replies Latest reply: Apr 25, 2012 6:31 PM by Eddy Yang RSS

Ora Layout question, about EFD and F_cache.

Eddy Yang

 

Greeting,

I like to know which is better for oracle performance with specific # of EFD in a OLTP environment

 

1. Manually put Oracle Redo log and Undo tablespace files on EFD.

 

2. Put whole DB on a FC pool with F_cache enabling.

 

I think F_cache would be better since it would actively select hot data, although Oracle Redo log and Undo tablespace files are most hot part in a OLTP DB.