Re: Peoplesoft and reporting instance...
Date: 03 Oct 2014 12:07:33 -0000
Message-ID: <801493899.108880.1412338049468.JavaMail.yahoo_at_jws106109.mail.bf1.yahoo.com>
As David mentioned, once configured, the reporting access to Active Data Guard instance via PSFT tools is transparent to your
Implementing Oracle Active Data Guard
If you do not want any of the read-only enabled delivered components or processes
redirected to the standby database, then you can disable the read-only
attribute for the specific component or process by going to the appropriate
component definition or process definition and deselecting...
When PeopleSoft is configured for Oracle Active Data Guard the following processes are enabled, as delivered, to run against the standby database:
PeopleSoft Query:
- PSCONQRS: Run Scheduled Connected Queries
- PSQUERY: Scheduled Query PS/nVision:
- Report
- Report drilldown
- Report book SQRs:
- XRFAPFL
- XRFFLPN
- XRFFLRC
- XRFIELDS
- XRFMENU
- XRFPANEL
- XRFPCFL
- XRFPNPC
- XRFRCFL
- XRFRCPN
- XRFWIN
- XRFFLPC Audit Utilities:
- SWPAUDIT
- SYSAUDIT
- DDDAUDIT
Other processes can also be enabled to run against the standby database by setting the Read Only option on the Process Definition properties page in Process Scheduler.
From: Chris Grabowy <cgrabowy_at_gmail.com> To: "'Chitale, Hemant K'" <Hemant-K.Chitale_at_sc.com> Cc: 'ORACLE-L' <oracle-l_at_freelists.org> Sent: Wednesday, October 1, 2014 5:13 AM Subject: RE: Peoplesoft and reporting instance...
Hemant,
That appears to be a way to throttle the resource hogging reporting. We will have to look into that.
I guess I will have to sit down with the Peoplesoft documentation…
Thanks,
Chris
From:Chitale, Hemant K [mailto:Hemant-K.Chitale_at_sc.com]
Sent: Tuesday, September 30, 2014 10:43 PM
To: cgrabowy_at_gmail.com
Cc: ORACLE-L
Subject: RE: Peoplesoft and reporting instance...
Never tried this .... but ... how about looking at “Working With Oracle Consumer Groups” at http://docs.oracle.com/cd/E24150_01/pt851h2/eng/psbooks/tadm/chapter.htm?File=tadm/htm/tadm13.htm%23g037ee99c9453fb39_ef90c_10c791ddc07__7b21
Hemant K Chitale
From:oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris Grabowy
Sent: Wednesday, October 01, 2014 4:59 AM
To: 'ORACLE-L'
Subject: Peoplesoft and reporting instance...
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
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 03 2014 - 14:07:33 CEST