Oracle database administration
As the database administrator, you must set up and maintain your Oracle database to store all of your system data and ensure that you configure the database for optimal performance.
- Oracle database performance
Configure and tune your Oracle database to ensure optimal performance. You can optimize the database for memory usage, storage allocation, and connections. - Oracle connection parameters
Run your Oracle database in "dedicated server" mode where you need one database connection (that are Oracle process) for each application connection (user process). In Oracle databases, the maximum number of connections that are allowed by the database is set by using the PROCESSES parameter in the initsid.ora file where sid is the system ID of your database. - Oracle table spaces
Data that is entered into InfoSphere MDM Collaboration Server gets stored in the underlying database and is organized in different table spaces in the database. Because large amounts of data transactions occur, you must ensure that database is tuned optimally. - Configuration parameters for Oracle databases
To ensure optimal performance of your database, you can configure the parameters in database configuration. - Oracle database health check
Check the health of your database in regular intervals to maintain system availability. - Oracle databases
To maintain your Oracle databases, you can use a number of scripts and commands to generate statistics and reorganize your databases.
Related concepts:
Last updated: 11 Sep 2017