Print Thread
Report on disc usage, nbr of extents on tables, etc ...
#36343 11/02/09 08:01 AM
Joined: Aug 2009
Posts: 8
E
ElsVO Offline OP
Member
OP Offline
Member
E
Joined: Aug 2009
Posts: 8
I thought to remember there was a standard report in PL/SQL Developer showing for each of the tables in the database how fragmented they are (Nbr of extents they are using) and how much disc space they're using.

I don't seem to be able to find back this report - how can I easily view this ?

Thanks for all info
Els

Re: Report on disc usage, nbr of extents on tables, etc ...
ElsVO #36346 11/02/09 11:13 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
Do you mean Reports > Objects > Tables?


Marco Kalter
Allround Automations
Re: Report on disc usage, nbr of extents on tables, etc ...
Marco Kalter #36349 11/02/09 11:32 AM
Joined: Aug 2009
Posts: 8
E
ElsVO Offline OP
Member
OP Offline
Member
E
Joined: Aug 2009
Posts: 8
that report doesn't show me how fragmented the tables are, how many table-extends they have and what actual disc space they are consuming .... which is the kind of info I'm after


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.065s Queries: 14 (0.009s) Memory: 2.4996 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-27 13:22:32 UTC
Valid HTML 5 and Valid CSS