[progress Communities] [progress Openedge Abl] Forum Post: Re: Oe10.2a Database Performance...

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
> How can you dbanalys a DBI file? Create an empty database with the -tmpbsize blocksize and with the following .st file: b . # d "Schema Area":6,32;1 . # d "DBI":7,256;8 . Rename your DBI file as dbi_7.d1 prostrct unlock dbi proutil dbi -C dbanalys dbi Also you can run: proutil dbi -C dbrpr 13. Display Block Contents 8. Change Current Working Area 3. Select Block Type ON 12. Object Block 4. Start Block: 1 5. End Block: 100000000 G. Go The number of object blocks = the number of temp-table instances and their indexes used by session.

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