Tags: action, content, contents, database, enterprise, equivalent, manager, mysql, oracle, particular, pointing, report, sql, tablespace, titled
SQL Equivalent of Show Tablespace Contents.
Through Enterprise Manager, pointing to a particular tablespace, there is an action titled: Show Tablespace Content, that gives a KB report for each table/index/LOBSEGMENT, etc on a particular Tablespace.
I currently have a Database that I am for various reasons, unable to use with Enterprise Manager or GRID, is there a script that can give me the equivalant of the above action? It doesn't have to be pretty, but I need it prior to a performance test tomorrow.
Leave a comment...
- 1 Comments
- Never mind, I found this post:
And modified it for my purposes as such:
SELECT sum(bytes)/1048576 Megs, segment_name
WHERE owner = 'ORABPEL'
GROUP BY segment_name
order by MEGS
Thanks!#1; Sat, 23 Feb 2008 17:17:00 GMT