Contacts     ->      ICQ:    699 512 265,         E-Mail: CerebroSQL@gmail.com

  • YouTube Social  Icon

Viewing information about tablespaces database Oracle

When viewing the information on the table space should be noted that the program "CerebroSQL" to optimize the 2 modes available performance monitoring subsystem view the details of table spaces:

  • With the supervision of the submission dba_free_space (thus calculated actual occupied space in the data tablespace, datafile). Using it appears in the main window "Details->"

  • Without watching the performance dba_free_space. Using it appears in the main window "* Details->"

Working with windows
When you select a table space in the list of "Size object" program displays additional information

Name table space:

  • Block size

  • Status. Clicking available translation table space status from Online to Offline and back

  • Content [PERMANENT, UNDO, TEMPORARY]

  • Logging. Clicking available translation table space Logging status in Nologging and back

  • Force. Clicking available translation table space from the state No to Yes and back

  • Control mode extents

  • Control mode segments

  • Status parameter "Compression"

  • Retention

as well as detailed information about the size of the space

When you select a table space in the tree "Tree tablespace" in the list "Size object" displays information about the data files belonging to the tablespace

When you select the data file in the list "Size object" in the list of "Details tablespace" shows information about the table space to which it belongs, as well as have the opportunity to transfer to the state Online | Offline

The tree "Tree tablespace" context menu is available, consisting of one paragraph "List object" with the help of which can view a list of objects which are located in the selected table space size and types