Re: Oracle OFA, Tablespaces and Redo Logs?

"Hari Om" <hari_om_at_hotmail.com> wrote in message news:d1d5ebe4.0306301321.30fc150e_at_posting.google.com...
> Hello 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....?

depends on what your needs are are

minextents 1 maxextents unlimited / use LMT's

>
> Q2) What would be the difference between DATA Tablespace and USERS
> Tablepsace?

the name? data would be were ure data goes and suers being the users tablespace (default tablespace)

>
> 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 - 18:07:35 CDT