Its been mentioned a few times on the list and I cant speak on the product but you may want to look at Delphix YMWV J From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Kurtz Sent: Tuesday, September 30, 2014 5:20 PM To: cgrabowy@xxxxxxxxx; 'ORACLE-L' Subject: RE: Peoplesoft and reporting instance... PeopleSoft does support Active DataGuard. The reports are not stored in the database, but there are some PeopleTools tables that are updated when the report starts and finished and is posted to the report repository. Tables that need to be updated are mapped back to the primary database through database links. There are delivered scripts to handle PeopleTools tables, and you might need to add to that. However, if your report populates working storage tables, then there is no point running it on the reporting instance. Some jobs have one process that populates the reporting table and another that reports from it. You can arrange for the first to run on the process scheduler on the primary database and the second to run on the process scheduler on the reporting database. Of course, this approach does not tackle the resource consumption, it just moves it somewhere else. regards _________________________ David Kurtz tel: +44 (0)7771 760660 mailto:david.kurtz@xxxxxxxxxxxxxxx <mailto:david.kurtz@xxxxxxxxxxxxxxx> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Chris Grabowy Sent: 30 September 2014 21:59 To: 'ORACLE-L' Subject: Peoplesoft and reporting instance... Importance: High Peoplesoft DBAs, The manager of the Peoplesoft application is having an issue with end users submitting resource hogging reports. We are trying to come up with a solution to solve this issue. One option is to throttle the resources those reports use. Has anyone else done this successfully? This might be an immediate option to at least "control" the performance issues. Second option is to move the production database to RAC. Cost is the big issue here. Third option is Active Dataguard. There is a cost component to this solution. But it appears this is NOT an option since the end users want to be able to change the reports and the reports are stored in the database. Anyway, I am wondering what other Peoplesoft sites have done? Any ideas? Thoughts? Insults? Thanks, Chris Grabowy
Please visit our website at http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html for important disclosures and information about our e-mail policies. For your protection, please do not transmit orders or instructions by e-mail or include account numbers, Social Security numbers, credit card numbers, passwords, or other personal information.