This function is used to view the volumetric elements for the tables of the database associated with a folder (current folder by default).

These elements are presented on two tabs: the first tab gives the sizing of the tables, the second tab, the sizing of the databases:
- tablespaces in the event of an Orcale database,
- the database, data and indices in the event of an Sql Server database.

Warning

This function is used, via queries on tables and views of the system, to provide technical information on the sizing of the database and the tables within. The results provided in this function should be interpreted by a database administrator, and this interpretation can depend on the version of the database used.

Screen management

Header

It suffices to enter the name of the folder (the current folder name is proposed) and to validate the screen. By default, the current folder is proposed, but it is possible to give the name of another accessible folder, using the syntax detailed in the annex documentation.

Folder (field DOSSIER)

Define the folder code, as it is defined in the folders table, in which the work will be carried out.

Tab Tables

Once the folder has been given a name, the grid in the first tab is populated with the list of tables in the database and their main characteristics. Moreover the total size of the data of the folder is displayed for information purposes at the bottom of the screen.

Grid

Table (field FICHIER)

Name of the table where the characteristics are given.

The rule is as follows :

  • the tables describes in the dictionary and present in the database are displayed first, sorted in the alphabetic order.
  • then, the table SYS_LOB table, which stores all the fields of the type BLOB or CLOB (in the case of an Oracle database).
  • finally, all the tables present in the database, but not described in the dictionary, they are also sorted alphabetically.
Description (field NOMFIC)

Title associated with the previous code.
Number of lines (field NBREC)

Define the real number of lines in the table (to be compared with the planned number of lines).
Expected number (field NBPRE)

Define the number of lines expected during the dimensioning of the table.
Ratio (field RATIO)
Size (K-bytes) (field TAILLE)

Define the total size taken by the table (in Kb). This is the sum of the data and index size.

For an Oracle database, it does not include the size of the clobs, stored separately in the SYS_LOB table.
Table extensions (field EXTDAT)

This information is only displayed when the database is Oracle. It gives the number of extents in the table.
Index extensions (field EXTIDX)

This information is only displayed when the database is Oracle. It gives the number of extents in the index.
Index number (field NBIDX)

Define the number of indexes create in the table.
Table size (field TAILDAT)

Define the size taken by the data in the table in Kb.

For an Oracle database, the size of the BLOB/CLOB fields is excluded, because these fields are stored in the SYS_LOB table.
Index size (field TAILIDX)

Define the size (in Kb) taken by all the indexes created in the table.
Maximum extensions (field MAXIDX)

This information is only displayed when the database is Oracle. It gives the maximum number of extents found by index.
Not used (field UNUSED)

This information is only displayed when the database is SQLServer. It gives the size (in Kb) reserved and not used for the table and its indexes.
No. of fields (field NBFLD)

Define the number of fields (in the Adonix sense, a dimensioned field counts as one) in the table.

No. of columns (field CLFLD)

Defining the number of columns in the table in the database. This number is in general greater that the number of fields, because an Adonix dimensioned field is counted as a field, but is defined as N columns in the database.
Length (field LGFLD)

Define the length of the record.

Image file (field BLOB)

Maximum size (in Kb) of the blobs managed in the table (when a field of this type exists in the table).
Anomaly (field TEXTEANO)

When an anomaly is found in a table, the corresponding line is displayed in color (the color depends on the gravity of the anomaly).

The anomalies that exist are :

  • anomaly of type 1 : the number of lines in the table is greater that 3 times that planned at the start. The relation between the two is given in the text for anomaly.
  • anomaly of type 2 : the number of extents on the data or the index exceeds 30.
  • anomaly of type 3 : number of colors too great or the size (on integrating the blobs) is too large.

These anomalies are likely to pose performance problems.

Block number 2

Total folder size (field TAILTOT)

Define the total used by the tables in the folder.
field COMMENT2
field COMMENT3

Tab Base

The following elements appear in the second tab:

  • for an Oracle database, the list of tablespaces used and the remaining free space in each one,
  • for an Sql Server base, the allocation of the space taken up by the base.

SQL server

Size of the base (field TAILBASE)

Total size of the current database, all folders included. This size includes all the data files and journal files.
field MB1
Space not allocated (field ESPACE)

Database space that has not been reserved for the database objects.
field MB2
Total size (field TOTAL)

Total quantity of space allocated by the objects in the database.
field MB3
Data (field DONNEES)

Total quantity of space occupied by the data.
field MB4
Index (field INDEX)

Total quantity of space occupied by the indexes.
field MB5
Not used (field UNUSED)

Total quantity of space reserved for the objects in the database, but not yet used.
field MB6

Grid Oracle

No. (field NUMLIG)
Tablespace (field TABLESP)

Located in this column are the Oracle tablespaces name present to manage the data in the folder.
Free space (MB) (field FRESPA)

Define the space remaining free (in Mb) in each tablespace.
Space taken (Mb) (field USED)

Define the space occupied (in Mb) in each tablespace.

Reports

By default, the following reports are associated with this function :

  PRTSCR : Screen print

This can be changed using a different setup.

Errors

Used to only display the lines having generated an anomaly.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

XXX : Non-existent folder

The name of a folder not referenced in the folder table.

xxx : machine not accessible

An attempt has been made to access a machine that does not exist on the network.

Tables used

SEEREFERTTO Refer to documentation Implementation