Use these reports select the resources and then the users on which you want to report storage consumption.
For example, when setting up a report to view storage consumption on a tablespace(s) for users, you must:
select the tablespace(s) upon which you want to report
select the users whose storage consumption on the selected tablespaces you want to view
Common fields in these reports:
User Name
Total Size
Empty Used Space
Table Count
Index Count
Other Count
Largest Segment
2nd Largest Segment
Segment Size < 50 Kb
Segment Size 50Kb - 500Kb
Segment Size 500Kb - 1Mb
Segment Size 1 Mb - 10Mb
Segment Size 10Mb - 100Mb
Segment Size 100Mb - 500Mb
Segment Size 500Mb - 1Gb
Segment Size > 1Gb
Type |
Use these reports to... |
What's in these reports? |
By Tablespace |
view the consumption of storage on tablespaces by selected users |
Fields unique to this By clause:
|
By Tablespace Group |
view the consumption of storage for tablespace groups by selected users |
Fields unique to this By clause:
|
By Database |
view the consumption of storage on databases by selected users |
Fields unique to this By clause:
|
By Computer |
view the consumption of storage on computers by selected users |
Fields unique to this By clause:
|
By Computer Group |
view the consumption of storage for computer groups by selected users |
Fields unique to this By clause:
|
Network Wide |
view the storage consumption of users network wide |
|