RE: Experiences / Notes on Data Warehousing on 9iRAC on Linux
- From: April Wells <AWells@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 May 2004 10:58:26 -0500
We have had issues with BO queries that some of our users have constructed
and the way that either the query or the tool chooses to retrieve the
information. We have some user generated queries that will run for several
hours. I don't know enough about what BO does when it constructs the
queries or decides how it will join tables or how it will parse the query
this time.
I'm not sure that there ARE good work arounds, but don't complain that they
don't want to use the ad-hoc query capabilities. Life can get more
complicated when they do.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall
-----Original Message-----
From: Leslie Tierstein [mailto:Leslie.Tierstein@xxxxxxxxxxxxxxx]
Sent: Wednesday, May 19, 2004 10:52 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Experiences / Notes on Data Warehousing on 9iRAC on Linux
We have had major performance problems with Business Objects running on top
of a multi-gigatype data warehouse. Granted, we've been using full-client
BO, rather than WEBI, but I think the architectural drawbacks are the
same -- that is, BO wants to build a cube on the Business Objects server, so
it ends up bringing masses of data to that server from the database. We are
still trying to do some diagnosis, but our current suspicions are that the
BO server is, in fact, memory-bound. (And here the IT department was trying
to blame the Oracle database.)
Another issue is that the end users don't like the user interface provided
for building adhoc queries and have basically declared they don't think
they'll ever use it. As of now, I'm not quite aure what the objections are,
just that it is "too complicated". The BO repository has been pre-populated
with filters, metrics, etc, for their use, but it's still "too complicated".
Leslie
Leslie Tierstein
Senior Consultant
Vision Chain, Inc.
The Standard for Demand Data Networks
phone: 202-261-3549
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hemant K Chitale
Sent: Wednesday, May 19, 2004 10:18 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Experiences / Notes on Data Warehousing on 9iRAC on Linux
My organisation is planning to migrate the current DWH [8i on Solaris]
to 9iRAC on Linux. The initial load will be 50GB, growing to 500GB
in 6 months.
I am looking for notes / "how-tos" / tips / traps on implementing a
DWH on 9iRAC on Linux.
Current extraction from the ODS is by combinations of FTP and PLSQL jobs.
We would be looking at products like Ascential DataStage or BusinessObjects
DataIntegrator
or the like for ETL and BusinessObjects WebIntelligence for
Reporting/Querying.
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://web.singnet.com.sg/~hkchital
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
The information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.
Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
