Hello Mario,
Wednesday, November 5, 2008, 7:25:06 PM, you wrote:
>
My co-workers and I are trying to find out if anyone out there is running production Oracle on. We currently have a project in which we have a SAN divided into 51 86.9GB luns (performance). Oracle has been setup on 18 o
My co-workers and I are trying to find out if anyone out there is
running production Oracle on. We currently have a project in which we
have a SAN divided into 51 86.9GB luns (performance). Oracle has been
setup on 18 or so partitions and using SVM would be a logistical
nightmare as far as manage
david lacerte wrote:
> Oracle on ZFS best practice? docs? blogs? Any recent/new info related
> to Running Oracle 10g and/or 11g on ZFS Solaris 10?
>
We try to keep the wikis up to date.
ZFS Best Practices Guide
http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_Guide
ZFS for
Oracle on ZFS best practice? docs? blogs? Any recent/new info related
to Running Oracle 10g and/or 11g on ZFS Solaris 10?
dave
___
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
[EMAIL PROTECTED] schrieb:
Robert and Daniel,
How did you put oracle on ZFS:
- one zpool+ one filesystem
- one zpool+ many filesystems
- a few zpools + one filesystem on each
- a few zpools + many filesystem on each
My goal was not to maximize tuning for ZFS but just compare ZFS vs.
Hello przemolicc,
Wednesday, August 30, 2006, 9:49:33 AM, you wrote:
ppf> On Fri, Aug 25, 2006 at 06:52:17PM +0200, Daniel Rock wrote:
>> [EMAIL PROTECTED] schrieb:
>> >Hi all,
>> >
>> >Does anybody use Oracle on ZFS in production (but not as a
>> >background/testing database but as a front line)
I have seen the best oracle performance on ZFS by
1. match the zfs record size to oracle db_block_size
2. use the default 128k record size for oracle logs.
3. If possible use a separate zpool for the oracle logs.
This is especially true if your workload has a high
write component to it.
Two
On Fri, Aug 25, 2006 at 06:52:17PM +0200, Daniel Rock wrote:
> [EMAIL PROTECTED] schrieb:
> >Hi all,
> >
> >Does anybody use Oracle on ZFS in production (but not as a
> >background/testing database but as a front line) ?
[ ... ]
Robert and Daniel,
How did you put oracle on ZFS:
- one zpool+
Daniel,
This is cool. I've convinced my DBA to attempt the same stunt. We
are just starting with the testing so I'll post results as I get them.
Will appreciate if you can share your zpool layout.
--
Just me,
Wire ...
On 8/26/06, Daniel Rock <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] sc
[EMAIL PROTECTED] schrieb:
Hi all,
Does anybody use Oracle on ZFS in production (but not as a
background/testing database but as a front line) ?
I haven't used in production yet - but I'm planning by the end of the year. I
did some performance stress tests on ZFS vs. UFS+SVM. For testing I us
Hello przemolicc,
Friday, August 25, 2006, 3:51:53 PM, you wrote:
ppf> Hi all,
ppf> Does anybody use Oracle on ZFS in production (but not as a
ppf> background/testing database but as a front line) ?
Not exactly front-line but devel Oracle instances and warehouse.
It works. However no performan
Hi all,
Does anybody use Oracle on ZFS in production (but not as a
background/testing database but as a front line) ?
I am interesting especially in:
- how does it behave after a long time of using it. Becasue COW nature
of ZFS I don't know how it influences performance of queries.
- general opi
Richard Elling schrieb:
On Fri, 2006-05-19 at 23:09 +0200, Daniel Rock wrote:
(*) maxphys = 8388608
Pedantically, because ZFS does 128kByte I/Os. Setting maxphys >
128kBytes won't make any difference.
I know, but with the default maxphys value of 56kByte on x86 a 128kByte
request will be s
Bart Smaalders schrieb:
How big is the database?
After all the data has been loaded, all datafiles together 2.8GB, SGA 320MB.
But I don't think size matters on this problem, since you can already see
during the catalog creation phase that UFS is 2x faster.
Since oracle writes in small blo
Daniel Rock wrote:
Hi,
I'm preparing a personal TPC-H benchmark. The goal is not to measure or
optimize the database performance, but to compare ZFS to UFS in similar
configurations.
At the moment I'm preparing the tests at home. The test setup is as
follows:
. Solaris snv_37
. 2 x AMD Opteron
Hi,
I'm preparing a personal TPC-H benchmark. The goal is not to measure or
optimize the database performance, but to compare ZFS to UFS in similar
configurations.
At the moment I'm preparing the tests at home. The test setup is as
follows:
. Solaris snv_37
. 2 x AMD Opteron 252
. 4 GB RAM
. 2 x
16 matches
Mail list logo
