User login
Sponsored links
Get Table Sizes in your Schema
Thu, 07/03/2008 - 12:06pm — Zooz
If you want to see how much space your tables are taking in the database, log in to the shcema and execute this SQL.
SELECT segment_name table_name, MAX (tablespace_name) tablespace_name,
SUM (BYTES) / (1024 * 1024) table_size_mb
FROM user_extents
WHERE segment_name IN (SELECT tname
FROM tab
WHERE tabtype = 'TABLE')
GROUP BY segment_name
ORDER BY tablespace_name
SUM (BYTES) / (1024 * 1024) table_size_mb
FROM user_extents
WHERE segment_name IN (SELECT tname
FROM tab
WHERE tabtype = 'TABLE')
GROUP BY segment_name
ORDER BY tablespace_name
The Above query tells you the table name, the table space it is residing in and the size in MB.
Thanks,
Zooz
Bookmark/Search this post with:
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| Regarding Error "SQR 6002) CANNOT OPEN THE PRINTER FILE: " in SQR | PeopleSoft Technical | 11/21/2008 - 1:17am |
| Pay calendar Setup | PeopleSoft Functional | 11/18/2008 - 5:30pm |
| Issue linking to Excel 2007 from PS HRMS 8.8 | PeopleSoft Technical | 11/17/2008 - 9:48am |
| Spreadsheet-Based Control System Analysis and Design | Programming | 11/11/2008 - 5:10am |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
About Zooz
Job title
IT Consultant
IT skills
SQL,PL/SQL,Oracle warehouse Builder, Kalido DIW, Kalido MDM, Control-M
Comments
Re: Get Table Sizes in your Schema
Join date: 06/23/08
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
Post new comment