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)

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[...]
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 [...]
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[...]
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[...]
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[...]
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[...]
Prashant
 

>