| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DW setup
Thats what we are planning on doing here with our data warehouse.
Unfortunately, your CPU's have to be at 100% for resource manager
to become effective. I'd like to be able to have a bit more control
over sessions than that.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you.
-----Original Message-----
Sent: Monday, October 14, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Rich - Good point! I haven't used Oracle Resource Manager, but in theory it
should be able to do a better job of implementing priorities than the
operating system can.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, October 14, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Why seperate instances? Why not seperate schemas in the same instance?
-----Original Message-----
[mailto:becker.bill_at_marshfieldclinic.org]
Sent: Monday, October 14, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Hello,
BACKGROUND:
We've been planning a 300GB datawarehouse architecture for Oracle 9.2 on
Solaris, and have proposed the following:
1) 2 separate instances of Oracle 9.2,
Point 3 needs further explanation: both of these instances will be connected
to
Network Attached Storage (NAS) from a vendor named Procom. They have a
feature
called Checkpoints, which quickly creates a read-only copy of a data volume
(I believe this is similar to network appliance's snapshot feature, and EMC
also
has something like this, but the name escapes me). Checkpoints are very fast
to
create, and can result in a read-only copy of 200GB of data in 1 - 2
minutes.
At present, we use them for backup purposes only, and they work well.
Instance A, the staging instance, will use the read-write Oracle datafiles
located on the procom read-write volumes. Instance B, the query instance,
will use datafiles located on a read-only procom volume, which also happens
to
be the checkpoint volume of the read-write volume used by Instance A. The
checkpoint volume will be refreshed daily, from the staging volume, when the
daily ETL stream has completed. The query instance datafiles will be dropped
and re-created daily via the procom checkpoint, and the tablespace metadata
will be plugged in using transportable tablespaces.
We have verified that Oracle works OK using plugged-in read only tablespaces located on a procom read-only checkpoint volume.
QUESTIONS:
(too much to hope for)
1) Is anyone else out there using this type of configuration with procom?
If so, how well does this work? Any comments, problems?
(more realistic)
2) Is anyone else out there using a similar configuration with a comparable
vendor feature like checkpoints? Any performance problems? Any comments, problems?
(more desperate)
3) Is anyone running a large Oracle data warehouse using primarily read-only
tablespaces? Any comments, problems? How do you refresh them?
(last resort)
4) Does anyone care to comment on the above configuration? good idea...bad
idea?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: becker.bill_at_marshfieldclinic.org
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Oct 14 2002 - 17:03:47 CDT
 |
 |