1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

What does the Extent Size indicate in following Tablespace ?

Discussion in 'General' started by sidharthmellam, Jul 28, 2010.

  1. sidharthmellam

    sidharthmellam Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    Hi All,

    For Each of the tablespace, ExtSize is mentioned differently

    What does this Extent size indicate ? What shoudl be the ideal value for this

    is there any calculation to fix this value. Please advise.

    Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] ExtSize[KB]

    1 - PSAPR3P 108/24 1269481088 99.74 3357120 35586064
    2 - PSAPR3P620 11/11 22528000 62.24 8505472 23609344
    3 - PSAPR3PUSR 1/1 20480 73.44 5440 4173824
    4 - PSAPTEMP 10/0 30719984 0.00 30719984 0
    5 - PSAPUNDO 3/0 30720000 16.08 25779648 0
    6 - SYSTEM 1/0 2048000 33.28 1366344 0


    Thanks in Advance.
     
  2. sidharthmellam

    sidharthmellam Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    Hi All,

    Not able edit properly

    Tablespace ExtSize[KB]

    PSAPR3P 35586064

    PSAPR3P620 23609344

    PSAPR3PUSR 4173824

    PSAPTEMP 0

    PSAPUNDO 0

    SYSTEM 0
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Post the query you ran to get these results.