Topic: Approach 360: Oracle Business Intelligence – Design for Success
Date: Thursday, December 03, 2009
Time: 10 AM PST

Click here to register: http://www.sierraatlantic.com/drive/ITES/bi_email.php

 out of  found this valuable. Do you find this valuable?    

I try to manage many connections on a repository file (.rpd) on a BISE1 installation and think about a tool to modify this file from command line. Any ideas ...

Regards
PGutierrez

 out of  found this valuable. Do you find this valuable?    

Join us on Sunday at 1:00 pm in the Orlando Convention Center in Room W304F for a presentation, "Replacing Discoverer" and a BI panel discussion with Oracle (Louis Nagode), Noetix (Jeffrey Kirk), EiS Technologies (Andy Donovan), and a Pentaho user (Dan Shannon, ListingBook, LLC).

To tweet the event, use #bidw and #c09.

 out of  found this valuable. Do you find this valuable?    

hello all

Is thr ny way to define error code and error messages tht wil display on dashboards..i mean is there any poss way of getting the error code and error msg that are defined by user....or is thr any file that contains a list of all error codes and msg's

thanks,

pankaj

 out of  found this valuable. Do you find this valuable?    

When the ROW-LEVEL-DEPENDENCY IS SET on RAWDEPENDENCY in a table, Oracle generate an SCN for every transaction.
My questions are the following:
how is the SCN generated by Oracle ?
is the value of the generated SCN increasing within each table after each transaction ?
or is the value of the generated SCN randomly generated ?

Thank you

 out of  found this valuable. Do you find this valuable?    

Show Last Reply

We have a datawarehouse that needs to be updated daily with the datachanges from our source system.
Our source system has about 4 tera of data.
Our datawarehouse is about 1 tera and we would need to renew its data every night within 2 to 3 hours.

Could you please enumerate the solutions that Oracle system (in house we have 10G Rel.2) offers for this kind of data load ?

Thank you very much.

 out of  found this valuable. Do you find this valuable?    

Show Last Reply

Registration for the Fall 2008 Desktop Conference is now open! Join the Oracle Business Intelligence community in the only global, online business intelligence conference that addresses business intelligence and data warehousing topics related to the Oracle technology stack. Go to www.desktopconference.org to register.

2  out of 2 found this valuable. Do you find this valuable? Do you?    

Learn about BIWA Summit, visit http://BIWASummit08.org

BIWA SIG Sessions at Oracle OpenWorld - Sep 21, 2008
Oracle BIWA SIG presents to you, 7 sessions at SIG Day - Sunday Sep 21 at Oracle Openworld

Building Cubes and Analyzing Data with Oracle OLAP 11g (IOUG)
S301022 8:30 AM, Dan Vlamis, Vlamis Software Solutions, Moscone West 2001

Be the Master of Your Domain: MDM Explained (IOUG)
S301156, 10:00 AM, Ian Abranson,, Moscone West 2001

A Retail Business Intelligence Accelerator: Oracle Data Warehouse for Retail (IOUG)
S301009, 1:00 PM, Shyam Varan Nath, Deloitte Consulting, BIWA SIG President, Moscone West 2001

Case Studies: Implementing Oracle Business Intelligence Suite Enterprise Edition in Three Environments
S301190, 2:30 PM, Richard Solari, Teresa Wong, , Moscone West 2001

The State of Oracle Business Intelligence and Data Warehousing: BI Discussion Panel (IOUG)
S301191, 4:00 PM, Joe Thomas , other Panelists, Moscone West 2001

Note Different Room

Extending and Customizing the Oracle Business Intelligence Applications Data Warehouse
S301063 8:30 AM, Mark Rittman, , Moscone West 2008

2009: A BI Odyssey
S301163, 10:00 AM, Matt Vranikar, , Moscone West 2008

1  out of 1 found this valuable. Do you find this valuable? Do you?    

Please submit your proposals for BIWA Summit, visit http://OracleBIWA.org under summit 2008 tab.
Email us at conference@oracleBIWA.org if you have any questions.
Thanks
Shyam

3  out of 5 found this valuable. Do you find this valuable? Do you?    

DISCOVERER QUICK TIPS (covers 4.1.48, but may cover other levels) :

1) After cloning a DB and APPS code tree, the Discoverer part will not always work. Ensure that the pref.txt file has the correct IP address of the "new" server that runs the Discoverer code, and after the Discoverer services are started, create an "unregisterall.sh" script (like the "registerall.sh" script, but runs all 3 "unreg*" scripts one after the other). Run this, followed by a "registerall.sh", then "applypreferences.sh", and check the errors.txt file for zero length (no errors present). Run checkdiscoverer.sh, also to check all is OK.

2) switch off Query Prediction (QPPEnable – make his zero in the pref.txt), as it can help performance.

3) There are often several levels of heavy hash-joins going on in the PLAN that the CBO sets up for Discoverer report runs.
If not catered for, these overflow into the TEMP TS, and get slowed down ten-fold by excessive disk I/O in there. I would recommend if your DB server has , say 32GB memory, set your pga_aggregate_target to a quarter of this, to 8GB, but also override the AUTO settings, by adding hash_area_size = 200M or even 400M, and the sort_area_size to 100M, or 200M in the init<DB>.ora if still getting disk sorts.

4) Check for orphaned ws processes on the Discoverer server (or on your main DB server if running all under on code-tree),
and kill them regularly. These can occur after a “Memory Heap” error in the user stack. I have user session logging on, so I can detect this with a cron check of the user logs, then locate the process list, and kill them. This stops CPU hogging. I can provide the scripts I use for this if you need them.

5) When stopping Discoverer services each night (If you are not 24x7) for cleanup, ensue that all the following files are removed from /tmp, as they are sometimes missed: /tmp/orb*, /tmp/dc*, /tmp/opm*

2  out of 4 found this valuable. Do you find this valuable? Do you?    

Show Last Reply