Replies to This Discussion

Permalink Reply by Ricky Johnson on March 14, 2013 at 10:29am

You can use AWR and ADDM reports. This would advice you what was running for SYSADM schema (PeopleSoft) from the record names. you will find several other details as well.

• ▶ Reply

Permalink Reply by Paula Schmitz on March 14, 2013 at 10:30am

 Run AWR and then look for sysadm and if it has some TOP SQL.

I should gather this information (10 Top SQL , among those have been run by PeopleSoft) every week.
it should be a criteria to limit the following query to PeopleSoft :

SELECT * FROM (SELECT substr(sql_text,1,40) sql,CPU_TIME/1000  temps, sql_id FROM V$SQLAREA    ORDER BY CPU_TIME DESC) WHERE rownum <= 10 ; 

Are all of the following modules from PeopleSoft and the only ones :

 SQL> select distinct module from v$sqlarea where module like 'PS%'; PSAE PSAE.INT_VCH_AE_I.4312 PSAE.PO_BDC_I.8220 PSAE.PO_DISPATCH.7212 PSAE.PSPRG_PC_I.4312 PSAESRV.exe PSAPPSRV.exe PSBRKDSP.exe PSBRKHND.exe PSDSTSRV.exe PSMONITORSRV.exe PSMSTPRC.exe PSPRCSRV.exe PSPUBDSP.exe PSQRYSRV.exe PSSUBDSP.exe PSSUBHND.exe 

Regards.

• ▶ Reply

Permalink Reply by Auri Gray on March 14, 2013 at 10:33am

it should be a criteria to limit the following query to PeopleSoft :

However, if the queries are not reported in AWR to be important enough, then you may ignore them as they are insignificant on your system. Don't they ?
But, on a Peoplesoft database, unless there're some Oracle internal issues reported (systems queries) which you should also take care of anyway, you are most likely getting Peoplesoft queries in AWR report as only Peoplesoft is running onto there.

SQLAREA cannot fit your requirement, you have no guarantee to be able to report the last x days of activites, whereas AWR reports can be kept for a number of days you can set on database level.

Are all of the following modules from PeopleSoft and the only ones

From the top of my head, there's also pside, psdmt, psrun (cobol)... and probably some others. I doubt you can get an exhaustive list. Without saying you may have some module starting by PS which are not Peoplesoft related (sic).

What are you trying to achieve exactly ?

• ▶ Reply

Permalink Reply by kristen on July 9, 2017 at 1:54pm

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

• ▶ Reply