Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Thumbs down Unanswered: Calculate extent size

    Hi,

    Somebody can tell me how to calculate extent y next size for all tables in database (process quick).

    Thank you for you help.

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    select tabname,
    count(*)
    from sysextents
    where dbsname = 'DATABASE'
    group by 1

    Or summarised by dbspaces
    select substr(DBINFO("DBSPACE",partnum),1,10) DBSpace,
    dbsname[1,10] Database,
    tabname[1,15] Table,
    sum(pe_size) tot_space,
    count(*) no_of_exts
    from sysptnext, systabnames
    where pe_partnum = partnum
    and tabname != "TBLSpace"
    group by 1,2,3
    order by 1,4 desc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •