By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Oracle OFA, Tablespaces and Redo Logs?

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.