| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: TEMP and BIG_RBS on the same disk?
Thanx for the input, but the number of users will never change. It's an OLTP environment, and nobody usually writes to disk to sort, the only think that does this (sorting to disk) is our nightly batch job.
On Sat, 11 Mar 2000 11:32:42 +0800, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
>NetComrade wrote:
>>
>> 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
>
>For a small user community it shouldn't be too bad, but don't forget
>that as the numbers go up, then you may have lots of people writing to
>both at the same time (indvidually they aren't doing both, but
>collectively they are).
>
>Just keep an eye on the disk and decide if/when the two need to be
>split.
>
>HTH
>--
>===========================================
>Connor McDonald
>http://www.oracledba.co.uk
>
>We are born naked, wet and hungry...then things get worse
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Sun Mar 12 2000 - 00:00:00 CST
 |
 |