Oracle OFA, Tablespaces and Redo Logs?
Date: 30 Jun 2003 14:20:17 -0700
Message-ID: <d1d5ebe4.0306301320.67749e81_at_posting.google.com>
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! Received on Mon Jun 30 2003 - 23:20:17 CEST