If you want to see how much space your tables are taking in the database, log in to the shcema and execute this SQL.
The Above query tells you the table name, the table space it is residing in and the size in MB.
Thanks,
Zooz
Title | Under | Posted on |
---|---|---|
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
How to add custom process in Paycycle PeopleSoft Accounts payable. | PeopleSoft Technical | 06/07/2017 - 4:39am |
Comments
To add to this, you can alter your current schema by using:
Also, if you want to avoid the schema thing all together, just replace the user_extents table with dba_extents table. You do however need to limit your where clause to go after specific OWNER or your SQL will take tremendous amount of time to execute.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog