Prev: ufsdump, etc: lev 0 onto tape; where to put the lev-1? AFTERthe lev0s?
Next: Cache size
From: max.fontain on 23 Jun 2008 12:03
Hello,
I have been tasked with installing 10 on a 440 with 3 X 18 GB disks.
Have installed Solaris 10 on disk 1 (.c1t0d0 )
This leaves me with c1t2d0 and c1t3d0 for 10g.
This is a development server where 18 GB might be OK for the one
database instance required ( the reporting application (is on disk1
with the OS).
So I might stripe the 2 18GB disks to make a big logical 36 GB disk.
Or maybe I should mirror them and get a 18 GB high(er) availablity
solution and when I run out of space should just ask for another 2
disks.
Or maybe I should install Oracle on disk2 have the instance on disk 3
(and the redo logs on disk2) for performance.

Could somebody like to supply some advice that would help me make a
good choice?

TIA

Max .




From: Richard B. Gilbert on 23 Jun 2008 12:14
max.fontain(a)yahoo.com wrote:
> Hello,
> I have been tasked with installing 10 on a 440 with 3 X 18 GB disks.
> Have installed Solaris 10 on disk 1 (.c1t0d0 )
> This leaves me with c1t2d0 and c1t3d0 for 10g.
> This is a development server where 18 GB might be OK for the one
> database instance required ( the reporting application (is on disk1
> with the OS).
> So I might stripe the 2 18GB disks to make a big logical 36 GB disk.
> Or maybe I should mirror them and get a 18 GB high(er) availablity
> solution and when I run out of space should just ask for another 2
> disks.
> Or maybe I should install Oracle on disk2 have the instance on disk 3
> (and the redo logs on disk2) for performance.
>
> Could somebody like to supply some advice that would help me make a
> good choice?
>

Oracle recommends ( or did ten years ago) that you have no fewer than
five physical disk drives in order to get decent performance. If you
can't do it, you can't but YOU HAVE BEEN WARNED! If it runs like a dog,
add disk drives or move it to a system with at least five disk drives.
From: Cydrome Leader on 23 Jun 2008 14:25
Richard B. Gilbert <rgilbert88(a)comcast.net> wrote:
> max.fontain(a)yahoo.com wrote:
>> Hello,
>> I have been tasked with installing 10 on a 440 with 3 X 18 GB disks.
>> Have installed Solaris 10 on disk 1 (.c1t0d0 )
>> This leaves me with c1t2d0 and c1t3d0 for 10g.
>> This is a development server where 18 GB might be OK for the one
>> database instance required ( the reporting application (is on disk1
>> with the OS).
>> So I might stripe the 2 18GB disks to make a big logical 36 GB disk.
>> Or maybe I should mirror them and get a 18 GB high(er) availablity
>> solution and when I run out of space should just ask for another 2
>> disks.
>> Or maybe I should install Oracle on disk2 have the instance on disk 3
>> (and the redo logs on disk2) for performance.
>>
>> Could somebody like to supply some advice that would help me make a
>> good choice?
>>
>
> Oracle recommends ( or did ten years ago) that you have no fewer than
> five physical disk drives in order to get decent performance. If you
> can't do it, you can't but YOU HAVE BEEN WARNED! If it runs like a dog,
> add disk drives or move it to a system with at least five disk drives.

What other 10 year old oracle tuning tips do you have for us?
From: Richard B. Gilbert on 23 Jun 2008 15:44
Cydrome Leader wrote:
> Richard B. Gilbert <rgilbert88(a)comcast.net> wrote:
>> max.fontain(a)yahoo.com wrote:
>>> Hello,
>>> I have been tasked with installing 10 on a 440 with 3 X 18 GB disks.
>>> Have installed Solaris 10 on disk 1 (.c1t0d0 )
>>> This leaves me with c1t2d0 and c1t3d0 for 10g.
>>> This is a development server where 18 GB might be OK for the one
>>> database instance required ( the reporting application (is on disk1
>>> with the OS).
>>> So I might stripe the 2 18GB disks to make a big logical 36 GB disk.
>>> Or maybe I should mirror them and get a 18 GB high(er) availablity
>>> solution and when I run out of space should just ask for another 2
>>> disks.
>>> Or maybe I should install Oracle on disk2 have the instance on disk 3
>>> (and the redo logs on disk2) for performance.
>>>
>>> Could somebody like to supply some advice that would help me make a
>>> good choice?
>>>
>> Oracle recommends ( or did ten years ago) that you have no fewer than
>> five physical disk drives in order to get decent performance. If you
>> can't do it, you can't but YOU HAVE BEEN WARNED! If it runs like a dog,
>> add disk drives or move it to a system with at least five disk drives.
>
> What other 10 year old oracle tuning tips do you have for us?

None! It's been about ten years since I last installed and configured a
system running Oracle. If a minimum of five disks is no longer
recommended, please consider my comments withdrawn.
From: AGT on 23 Jun 2008 16:41
On Mon, 23 Jun 2008 18:25:25 +0000, Cydrome Leader wrote:

> Richard B. Gilbert <rgilbert88(a)comcast.net> wrote:
>> max.fontain(a)yahoo.com wrote:
>>> Hello,
>>> I have been tasked with installing 10 on a 440 with 3 X 18 GB disks.
>>> Have installed Solaris 10 on disk 1 (.c1t0d0 )
>>> This leaves me with c1t2d0 and c1t3d0 for 10g.
>>> This is a development server where 18 GB might be OK for the one
>>> database instance required ( the reporting application (is on disk1
>>> with the OS).
>>> So I might stripe the 2 18GB disks to make a big logical 36 GB disk.
>>> Or maybe I should mirror them and get a 18 GB high(er) availablity
>>> solution and when I run out of space should just ask for another 2
>>> disks.

A 440 only takes 4 internal disks..
2 of which can be hardware mirrored.

>>> Or maybe I should install Oracle on disk2 have the instance on disk 3
>>> (and the redo logs on disk2) for performance.

with such a small installation I doubt all the fiddling in the World will
make much difference but separating redos across multiple platters
might help a BIT. Rather,
consider ASM across the two disks for DATA - put oracle home dir stuff
under a ZFS slice maybe.

Then do some swingbench runs and see if anything helps

>>> Could somebody like to supply some advice that would help me make
a
>>> good choice?
>>>
>>>
>> Oracle recommends ( or did ten years ago) that you have no fewer than
>> five physical disk drives in order to get decent performance. If you
>> can't do it, you can't but YOU HAVE BEEN WARNED! If it runs like a
>> dog, add disk drives or move it to a system with at least five disk
>> drives.

Clearly 3 18 GB disks is not a serious Oracle install so performance
cannot be an issue - if it IS well get a consultant in and hire some DBAs
spend some money lots of money

> What other 10 year old oracle tuning tips do you have for us?

How about - oracle account must use csh? : >
How about set noexec_user_stack=1 in /etc/system
I got a million of em

 |  Next  |  Last
Pages: 1 2
Prev: ufsdump, etc: lev 0 onto tape; where to put the lev-1? AFTERthe lev0s?
Next: Cache size