Tag Archive

Tag Archives for " SQL "

Find Size of PeopleSoft Tables and indexes [SQL]

What is the biggest pain for PeopleSoft Admins/DBA or any PeopleSoft consultant supporting the application? That’s when performance of PeopleSoft application is really sluggish. There are hundreds of things that could go wrong and one of those is directly related to size of your PeopleSoft database. PeopleSoft database consists of PeopleSoft Tables, indexes and few other objects […]

Continue reading

Quickest way to find hidden portal objects [SQL]

You can hide PeopleSoft portal objects (e.g. content reference) from PeopleSoft Navigation. This can be done by navigating to ‘Structure and Content’ and selecting  the checkbox ‘Hide from portal navigation’. Navigate to PeopleTools > Portal > Structure and Content  Incase you don’t have access to this page to view the configuration, you can check this […]

Continue reading

How to monitor connections to PeopleSoft Database

Ever wondered how many users are connected to PeopleSoft database? This is different than users who login into PeopleSoft application via web. You can find users who make direct SQL connection with your PeopleSoft database. This includes anyone using SQL client tool, PeopleSoft development tools and connections made by PeopleSoft server such as application server […]

Continue reading

Find PeopleSoft Navigation for a component using SQL

You can use below SQL to find PeopleSoft Navigation to a component. In below SQL replace the value of PORTAL_URI_SEG2 with your component name. SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH (REVERSE(PORTAL_LABEL),’ >- ‘),’ >- ‘)) “NAVIGATION” FROM PSPRSMDEFN P WHERE PORTAL_OBJNAME = ‘PORTAL_ROOT_OBJECT’ START WITH PORTAL_URI_SEG2 = ‘PRCSDEFN’ — Replace with your Component Name CONNECT BY PRIOR PORTAL_PRNTOBJNAME […]

Continue reading
1

How To Change PS stylesheet using SQL

Stylesheets as the name suggests is the piece of code that adds style to your PeopleSoft application. When you log into PeopleSoft application, all the menus, colors , design are controlled by stylesheets. PeopleSoft application comes with a default stylesheet which can vary between different Application releases. Here are the default stylesheets for different PS […]

Continue reading

SQL Monitoring in OEM 12c

SQL Monitoring was instrumented and available for command line use in the first release of the Oracle Database 11g. The graphical user interface to monitor active running SQL made its debut in Grid Control 10.2.0.5 and Database Control 11.1.0.7. Basically, the data from the GV$ views, is aggregated and presented in a user-friendly interactive fashion […]

Continue reading
3

How to Find PeopleSoft Processes/PSJobs in a Recurrence

Do you want to find out all processes and jobs running under a particular recurrence? Use this SQL below: SELECT process_job_name,  description, recurname FROM   ps_prcsrecur a, (SELECT p.prcsname  AS Process_Job_name, p.descr     AS Description, p.recurname AS recurname FROM   ps_prcsdefn p UNION SELECT jp.prcsjobame AS Process_Job_name, (SELECT j.descr FROM   ps_prcsdefn j WHERE  j.prcsname = jp.prcsname) AS Description, jp.recurname AS recurname FROM   ps_prcsjobdefn j,  ps_prcsjobitem jp WHERE  j.prcsjobname = jp.prcsjobname) b WHERE b.recurname = a.recurname AND a.recurname = :1 ORDER  BY 1

Continue reading