Viewing database information

Explains how to view information on the Tivoli Netcool Performance Manager DataMart database, instance, and status.

1. Click Database Information in the Monitor tab. A splash screen appears followed by the ProvisoInfo Browser.
2. Click Refresh objects from the database to globally update the window with the most recent database information.
3. Click the Identification tab. The Identification tab provides the following information:

   Item	Description
   Database Server Name	Name of the server where the database is installed.
   Database Name	Name of the database. The database is the data on disk (set of files), stored in operating system files. Tivoli Netcool Performance Manager DataMart uses only one database.
   Current Database User	Current user connected to the database. For example, PV_ADMIN.
   Database Release	For example, Oracle 11g Enterprise Edition, Release 11.2.0.3.0 - 64-bit Production DB2 10.1.0.1
   PL/SQL Release	For example, PL/SQL Release 11.2.0.3.0 - Production.
   CORE	For example, 11.2.0.3.0 - Production.
   TNS for Operating System	For example, 11.2.0.3.0 - Production.
   NLSRTL Version	National Language Support Run-Time Library. This library is responsible for providing algorithms for internationalization. The information (NLSDATA) is read by the NLSRTL library during run-time. For example, 11.2.0.3.0 - Production.
   Total SGA	System Global Area is the shared memory area used by the instance to store information shared between the database and the user processes. The following values are displayed (in MB): Fixed Size - exact size. For example, 72K. Variable Size - shared spool. For example, 291M. Database Buffers - part of the SGA that holds copies of blocks of data read from the Oracle datafiles on disk. For example, 125M. Redo Buffers - an area of memory within the SGA that holds information about recent changes to the database. For example, 528K.
   Total Database shared memory	Total Database shared memory parameter specifies the amount of memory that is reserved for the database shared memory region. The following values are displayed (in MB): Buffer pools A buffer pool is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from disk. For example, 1603.69 M. Database heap There is one database heap per database, and the database manager uses it on behalf of all applications connected to the database. It contains control block information for tables, indexes, table spaces, and buffer pools. For example, 19.24 M Lock list memory This parameter indicates the amount of storage that is allocated to the lock list. There is one lock list per database and it contains the locks held by all applications concurrently connected to the database. For example, 52 M. Utility heap size This parameter indicates the maximum amount of memory that can be used simultaneously by the backup, restore, and load (including load recovery) utilities. For example, 534.57 M. Package cache size This parameter is allocated out of the database shared memory, and is used for caching of sections for static and dynamic SQL and XQuery statements on a database. For example, 1086.71 M. Sort heap threshol This parameter represents a soft limit on the total amount of database .