Re: DBA_SEGMENT information??

From: janet <janet_at_telesph.com>
Date: 1996/11/20
Message-ID: <3293733B.1EB4@telesph.com>#1/1

If I understand you correctly, David,
there are two reasons you didn't get what you expected.

1. The extents & bytes are not additive. The initial extent is ~15 meg. The next extent to be allocated is 100K (i see your pctincrease is 0). Extents are 11, that means you have 1 extent of 15M and 10 of .1 M, giving you (1*15)+(10*.1) = 15+1=16. Bytes is the total allocation to that segment.

 SEGMENT NAME INITIAL NEXT EXTENTS BYTES

• ---------- ---------- ---------- ---------- PSAVCHR_ACCTG_LINE 15104000 102400 11 16128000 PSBVCHR_ACCTG_LINE 5632000 102400 7 6246400 PS_VCHR_ACCTG_LINE 18636800 102400 11 19660800 2) Tablespace PSINDEX4 was allocated with 60M. Segment A is taking 16M in tablespace PSINDEX4. Segment B is taking ~6M in tablespace PSINDEX4. Segment _ is taking ~18M in tablespace PSINDEX4. That means you have approximately 20M left to allocate in PSINDEX4.

Hope this clears it up. If not give me a holler; an e-mail will get you a quicker response.
janet

David E. Daniel wrote:
>
> Hello,
>
> I am trying to calculate the size of the data within my tablespaces. I
> have come up with some conflicting information and I am baffled.
> Hopefully I am just misinterpretting the results.
>
> Scenario:
>
> I have a datafile for a tablespace named "psindex4.dbf". This
> tablespace contains three indexes and only three indexes as listed
> below.
>
> I run the following queries in SQL*PLUS:
>
> SQL> l
> 1 select substr(segment_name ,1,20) "SEGMENT NAME",
> 2 initial_extent "INITIAL",
> 3 next_extent "NEXT",
> 4 extents "EXTENTS",
> 5 bytes "BYTES"
> 6 from DBA_SEGMENTS
> 7 where tablespace_name = 'PSINDEX4'
> 8* order by segment_name
> And am returned ...
>
> SEGMENT NAME INITIAL NEXT EXTENTS BYTES
> -------------------- ---------- ---------- ---------- ----------
> PSAVCHR_ACCTG_LINE 15104000 102400 11 16128000
> PSBVCHR_ACCTG_LINE 5632000 102400 7 6246400
> PS_VCHR_ACCTG_LINE 18636800 102400 11 19660800
>
> The next query that I run is:
>
> select substr(file_name,1,40) "DATA FILE NAME",
> substr(tablespace_name,1,10) "TABLESPACE",
> bytes "BYTES"
> from dba_data_files
> order by tablespace_name;
>
> And am returned the following:
> [snip]
> DATA FILE NAME TABLESPACE BYTES
> ---------------------------------------- ---------- ----------
> c:\ordata\PSFS\FSP\psindex1.dbf PSINDEX1 104857600
> c:\ordata\psfs\fsp\psindex2.dbf PSINDEX2 104857600
> c:\ordata\psfs\fsp\psindex4.dbf PSINDEX4 62914560 ****This
> is the line***
> [snip]
>
> My question is if I add up the following:
>
> PSAVCHR_ACCTG_LINE = 15104000
> PSBVCHR_ACCTG_LINE = 5632000
> PS_VCHR_ACCTG_LINE = 18636800
> 27 Extents X 102400 = 2764800
> ________________________________________
> Total 209868800 BYTES
>
> Why does this not total to the same or less than my data file size?? I
> must be adding this incorrectly or misreading the information for which
> I have queried. Could someone, please offer me some insight?
>
> Regards,
>
> David E. Daniel
> Western Michigan University
Received on Wed Nov 20 1996 - 00:00:00 CST