Development > Utilities > Verifications > Database > Table report 

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 gives the sizing of the tables, the second in the case of Oracle databases, is the tablespaces .

Screen management

Header

Presentation

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.

Warning: The visualisation of the Oracle tablespace sizes does not function if the server is remote.

Close

 

Fields

The following fields are present on this tab :

  • Folder (field DOSSIER)

Define the code of the folder in which the work will be carried out (such as it is defined in the table of the folders).

Close

 

Tab Tables

Presentation

Once the name of the folder is given, the grid in the first tab is loaded with the following columns:

Table / Title

The name of the table is given, as well as the dictionary title

Number of lines / Planned number

These columns stock the number of lines actually stored in the table (request select count(*) From TABLE), as well as the number of lines planned at the start (defined during the last validation of the folder by the sizing calculation, or imposed directly in the table dictionary).

If the number of lines stocked is more than 3 times the number planned, the line appears in red. In fact, this type of sub-sizing can have consequences on the database performance, and it is important to make this clear in the grid.

Size (Kbytes), Extents table, Extents index, Nb index, Size table, Size index, Maximum extents

This information is only displayed when the database is Oracle. They are used to define in a more detailed fashion the sizing information. When the number of extents exceeds 30 (except when the line must not be displayed in red), the line is displayed in green (because it is still possible that it could pose performance problems).

In addition, the total size of the data in a folder is displayed for information purposes at the bottom of the screen.

Close

 

Fields

The following fields are present on this tab :

Table

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.
  • Title (field NOMFIC)

Title associated to 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.

  • 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).

  • Problem (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

 

Close

 

Tab Basis

Presentation

In the second tab, the list of tablespaces used by Oracle and the remaining free space in each of them is displayed.

Close

 

Fields

The following fields are present on this tab :

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

 

Table 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.

Close

 

Other conditions

The characteristics in all the tables can be viewed via this function.

Reports

By default, the following reports are associated to the function :

 PRTSCR : Screen print

This can be changed by a different setup.

Menu Bar

!Button explication

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