-
Australian Oracle User Group
Link to the AUSOUG Home Page - (note this takes you out of the wiki) "To be the leading independent forum for Oracle professionals, partne...
Last updated:
May 11 2008, 9:31 PM EDT by
-
BIWA Summit 2008 Call for Presentations is open
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
Posted:
Jun 22 2008, 4:22 PM EDT by
-
Business Intelligence
This page will be used for information related to Oracle Business Intelligence, Data Warehousing and Advanced Analytics related tool stack as w...
Last updated:
Dec 28 2007, 4:09 PM EST by
-
Data Modelling Webinar
Join the BI SIG for a web presentation and discussion on the importance of data modelling. http://bidwsig.org/node/8
Tuesday, March 11. Meeting details will be published no later than 5 March.
Posted:
Feb 20 2008, 12:20 PM EST by
-
Different Business Processes
Hello,
I am looking for documents, where I can see what are the business processes in general related to different industries like pharma, HR, Manufacturing and how they are addressed in RPD when Oracle publishes lets say Pharma Analytics or Marketing Analytics etc.
Also where can I get RPD for these different flavour like Marketing Analytics etc?
Ganesh
Posted:
Mar 13 2008, 2:39 PM EDT by
-
DISCOVERER: Quick Tips
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*
Posted:
Jan 8 2008, 10:26 AM EST by
-
Oracle at TDWI 2008
November 2-7, 2008 New Orleans Marriott Hotel Oracle will be at the TDWI World Conference in New Orleans, the premier event for business intell...
Last updated:
Oct 30 2008, 4:56 PM EDT by
-
Oracle BI Applications
OBIA Product Page: http://www.oracle.com/appserver/business-intelligence/bi-applications.html OBIA Forum: http://forums.oracle.com/forums/forum...
Last updated:
Feb 25 2008, 7:17 PM EST by
-
Oracle BI, Warehousing & Analytics IOUG SIG User Meeting, Dec. 2-3
Oracle BIWA Summit 2008 is a forum for business intelligence, warehousing and analytics professionals to exchange information, experiences and best practices. Gain the knowledge and information critical for success in your work.
www.oraclebiwa.org
Posted:
Aug 13 2008, 11:42 AM EDT by
-
Oracle Development Tools User Group
Networking, communication, education, and support for all developers who work on Oracle Databases. ODTUG is an...
Last updated:
Nov 19 2007, 2:25 AM EST by
-
Some links to Oracle BI User Groups
1. Oracle Business Intelligence SIG http://obisig.oaug.org/
2. Oracle Business Intelligence SIG http://www.oraclebisig.org/
Posted:
Feb 29 2008, 5:23 AM EST by
-
The Fall DC2008 Call for Presentations is now open!
Is your organization's business intelligence initiative linked with Oracle EBS, JDE, or PeopleSoft? The Oracle BI SIG is looking for presentations that provide our users with solid information about business intelligence as it relates to the Oracle technology stack.
Share your lessons learned, tips and techniques, or insights with Oracle users from all over the globe.
Accepted presenters receive a complimentary registration to Fall DC2008 in recognition of their contribution to the Oracle BI community.
Submit your abstract today! http://desktopconference.org/node/68
Join the BI SIG for a Cognos/OBIEE Webcast
Quarterly Webcasts are free to registered BI SIG members.
Posted:
May 3 2008, 4:57 PM EDT by
-
What are the steps to implement SCD2 in "rpd" in OBIEE ?
* What are the steps to implement SCD2 in "rpd" in OBIEE ?
* Can you please share some links?
* Can you please share some documents etc.
Posted:
Jul 7 2008, 9:06 AM EDT by
|
|
