Displaying Database Properties

You are logged on to the database as database system administrator or as a DBM operator.
The database is in the ONLINE operational state.
Note that in ADMIN operational state, not all database properties are displayed.

Open the Overview tab page.

Database: Properties
Area	Property	Description
General	Name	Database name `<database_computer>:<database_name>`
	State	Operational state of the database
	Version	Version of the database software
	Operating System	Operating system of the database computer
	Installation Path	Installation path of the database software
	Independent Program Path	Directory containing the programs and libraries used jointly by all the databases and applications More information: Glossary, Directory
	Independent Data Path	Directory containing the data, configuration, and run directories of databases and applications
	Run Directory Path	Run directory
Settings To change any of these settings, choose the corresponding link.	Automatic Log Backup	Activating or Deactivating Automatic Log Backup
	Command Monitor	You can use the command monitor to analyze long-running SQL statements and identify bottlenecks.
	Resource Monitor	You can use the resource monitor to monitor resource usage in the database instance and identify expensive SQL statements.
	Database trace	Creating a Database Trace
	Database Analyzer	Starting or Stopping Database Analyzer
	Data Area Extension	Activating or Deactivating Automatic Extension of the Data Area
	Automatic Statistics Update	Updating SQL Optimizer Statistics
	Snapshot	Making Snapshots of the Data Area
Data Cache	Size	Size
Data Cache	Hit Rate	The lower the hit rate, the poorer your system's performance. We recommend a hit rate of > 99% for the data cache.

Database Administration, Creating Databases