469,927 Members | 1,674 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

Oracle OFA, Tablespaces and Redo Logs?

Hi Gurus,

I was reading Oracle DBA Handbook and read article about OFA - Optimal
Flexible Architecutre and it showed what are the different tablespaces
used in any db. These are: SYSTEM, UNDOTBLSP, TEMP, INDX, TOOLS,
USERS, DATA.

Q1) What should be the approximate size for each tablespace....? How
many MIN/MAX Extents should I need to allocate....?

Q2) What would be the difference between DATA Tablespace and USERS
Tablepsace?
I was reading Oracle DBA Handbook- Kevin Loney and have some
questions on it:
In one of the section (Chapter 4 - Section - Online Redo Log Files) it
says: "DBA's need to make sure that the online redo log files are
mirrored by some means" and I totally agree with that. It means (if I
am right) if my Redo Log Group has 3 files then these files should be
on different disks.

However, later on in the same chapter (Chapter 4, Section Third
Iteration) the book says:"The online redo logs should be placed
together on the same disks" do'nt you think it is contrary to the
above statement - isin't it misleading....? Kindly clarify orcorrect
me!

Thanks!
Jul 19 '05 #1
0 3754

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by susmita_ganguly | last post: by
7 posts views Thread by Murtix Van Basten | last post: by
56 posts views Thread by Ashish Patankar | last post: by
reply views Thread by Hari Om | last post: by
5 posts views Thread by Martin Solveig | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.