The used pages i talk about are only permanent data pages The output "info state" looks like this:
DBMOBIL> info state OK END Name | Value Data (KB) = 446048 Perm Data (KB) = 445952 Temp Data (KB) = 96 Data (Pages) = 55756 Perm Data (Pages) = 55744 Temp Data (Pages) = 12 Data (%) = 46 Perm Data (%) = 46 Temp Data (%) = 0 Log (KB) = 8 Log (Pages) = 1 Log (%) = 0 Sessions = 1 Sessions (%) = 10 Data Cache (%) = 99 Converter Cache (%) = 0 Data Max (KB) = 960000 Log Max (KB) = 199984 Data Max (Pages) = 120000 Log Max (Pages) = 24998 Sessions Max = 10 Database Full = No Connect Possible = Yes Command Monitoring = Off Database Monitoring = On Kernel Trace = Off Autosave = Off Bad Indexes = 0 Log Full = No Bad Devspaces = 0 Data Cache OMS (%) = 0 Data Cache OMS Log (%) = 0 > -----Urspr�ngliche Nachricht----- > Von: Stephen Gutknecht (SAPDB) [SMTP:[EMAIL PROTECTED] > Gesendet am: Donnerstag, 27. November 2003 18:51 > An: Gembus, John; '[EMAIL PROTECTED]' > Betreff: RE: The number of data pages is increasing extraordinarily > > I am unfamiliar with the query output you discuss... But a suggestion is > to > use dbmcli and do the "info state" command against your database instance. > I have found this has a good summary of page usage (temp, perm, also in > percentages). > > Not sure if log pages are being included in the numbers you are viewing... > If so, a backup will dump the used log pages... > > Stephen > > > -----Original Message----- > From: Gembus, John [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 27, 2003 4:44 AM > To: '[EMAIL PROTECTED]' > Subject: The number of data pages is increasing extraordinarily > > > my database becomes bigger and bigger. > Size 55.758 pages > > select * from tablestatistic and > select * from indexstatistc > > shows for user Database-User and normal-user 5216 used pages. > > I don't know where to find 50.542 pages. My Applikation needs nearly > constant 5100 pages. > There is no other program which works with sapdb. > > After installation and loading everything is ok. Then the number of used > pages becomes more and more. > > Any Ideas > > I user sapdb 7.4.3.10 an windows 2000 / Windows XP > > > > John
