Find Size of PeopleSoft Tables & indexes [SQL] | PeopleSoft Tutorial

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 but primarily the size is determined by tables and indexes. 

For Oracle database, DBA could utilize OEM (Oracle Enterprise Manager) to keep a check on your database size and you could setup triggers or scripts to alert when it reaches a threshold. 

PeopleSoft Tables are the PeopleSoft record definitions that are built and have database definition. PeopleSoft Indexes are created for these PeopleSoft tables. 

Below are couple of SQLs that can be used together to estimate the size of PeopleSoft database (size of PeopleSoft tables & size of PeopleSoft indexes)

Also Read: How to write an efficient SQL

The Output of below SQLs will show the size in MB and GB (approx).

If you like this SQL, please let us know in the comment section. Don't forget to share it with others too. 

Related Posts you might like

PeopleSoft Security Tables
PeopleSoft Security is a very important part of PeopleSoft application. At first, it may look really complex but when you[...]
Read More 
What are Authorized Actions in PSAUTHITEM table?
When you setup a permission list, you can select the Actions that are allowed on a component/page. These actions are [...]
Read More 
Find Roles and Permission Lists that Grant Access to a Page
If you've ever worked with PeopleSoft security, one of the most common request is to identify who has access to[...]
Read More 
Find PeopleSoft queries a user has access to [SQL]
Wondering how to get a list of all the PeopleSoft queries that a user has access to? You probably know[...]
Read More 
Find Distribution List for a PeopleSoft process [SQL]
Who can access a report from PeopleSoft report manager ? or Who is getting the reports emailed out to them[...]
Read More 
SQL Tip: Find PS Query set on recurrence
When you schedule a PeopleSoft query, you can see the scheduled process is of type PSQUERY but the process scheduler[...]
Read More 

Related posts:

  1. How to Find PeopleSoft Processes/PSJobs in a Recurrence
  2. Common Database Errors
  3. SQL Query to find Records and Fields used in a PeopleSoft Page
  4. How to monitor connections to PeopleSoft Database
Related Posts

PeopleSoft Security Tables

What are Authorized Actions in PSAUTHITEM table?

Find Roles and Permission Lists that Grant Access to a Page

Find PeopleSoft queries a user has access to [SQL]

Find Distribution List for a PeopleSoft process [SQL]

SQL Tip: Find PS Query set on recurrence

SQL Tip : Find users logged into PeopleSoft PIA with this SQL

SQL to find when PeopleSoft table was built and analyzed in Oracle
Prashant
 

←Previous post Next post→
>