Re: TEMP and BIG_RBS on the same disk?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/10
Message-ID: <952722331.749.0.pluto.d4ee154e@news.demon.nl>#1/1

NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message news:38c94828.301247197_at_news.earthlink.net...
> I was wondering, if only one transaction is accessing both
> tablespaces, can I place them on one disk?
>
> My understanding is that it won't write to RBS until it's done sorting
> in temp.
>
> Correct me if I am wrong ( I won't be offended or suprised :)
>
> Thanx.
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email

That wouldn't be a too bad choice, as temp tablespaces also don't use (provided sort_direct_write = AUTO) the normal DBWR mechanism and rollback segments do.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Mar 10 2000 - 00:00:00 CST