[progress Communities] [progress Openedge Abl] Forum Post: Schema Area Extent

  • Thread starter Thread starter bremmeyr
  • Start date Start date
Status
Not open for further replies.
B

bremmeyr

Guest
What causes growth of the database schema area file extent? I expect there is not any data in this area so what will make it grow? With my case in the database all the tables and indexes are type 2. There is 1 application table in the schema area due to someones mistake. That 1 table has zero records. The only indexes that show in the Schema area are default indexes for a hand full of 1 record tables that have no indexes defined. Different customer's files have different sizes. The application schema are the same. DBanalys shows total of the size column is 2.6 MB for the records and 430 K for the indexes. Example database.d1 file sizes: Customer A, 300 MB Customer B, 1.38 GB Customer C, 69 MB Progress OpenEdge 11.5.1, Windows server

Continue reading...
 
Status
Not open for further replies.
Back
Top