|
-
Thanks for the info. I had looked at the views but had not run the package. I will try that tomorrow.
Let me throw an example at you and someone can tell me where I am falling of the logic-train.
I have a tablespace that I have assigned to a datafile, of which the datafile is 1gig in size. Its the only ts in the datafile.
There are 5 tables in this tablespace and 1 index. Looking at the dba_tables view, I totaled the BLOCKS count for the tables. that was 5,686 blocks. Block size is 8192bytes. So, that tells me that thre is 46megs of data in that ts. Then, the empty blocks shows a total of 771 blocks for about 6.3megs. My looks at dba_indexes tell me that I have about 8megs of index space used. So, if I have done the looks right, I have used approxiately 61megs of a 1gig datafile? I am interpreting the 771 free blocks as what is left in the current extents for the objects. I would probably see that number move up and down as extents are allocated and used.
So, am I interpreting the numbers correctly?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|