Red Hat NETWORK SATELLITE 5.3.0 Installation Manual

Also see for NETWORK SATELLITE 5.3.0 - CHANNEL MANAGEMENT: Installation guide Management guide Configuration guide Release note Reference guide

Contents

Red Hat NETWORK SATELLITE 5.3.0 Installation Manual Manual pdf 64 page image

Chapter 8. Maintenance60Option Descriptionstart Starts the database instance. This can also beaccomplished by issuing the service rhn-database start command as root.shrink-segments Shrinks RHN Oracle database segments with signifcantamounts of free space.status Shows the current status of the database, either"running" or "offline".stop Stops the database instance. This can also beaccomplished by issuing the service rhn-database stop command as root.tablesizes Show space report for each tableverify DIRNAME Verifies the contents of the backup kept in DIRNAME.This command checks the md5sums of each of thefiles kept in the backup.Table 8.1. RHN DB Control OptionsNoteDatabase statistics are collections of data that describe more details about the databaseand the objects in the database. These statistics are used by the query optimizer tochoose the best execution plan for each SQL statement. Because the objects in adatabase can be constantly changing, statistics must be regularly updated so that theyaccurately describe these database objects. Statistics are maintained automatically byOracle. However, if your database has performance issues after a significant amount ofdata changes, consider performing manual gathering of statistics.NoteAfter deleting large amount of data, use the segment-shrink feature to reclaimfragmented free space in an Oracle Database segment. The benefits of segment-shrink are compaction of data that leads to better cache utilization and the compacteddata requires fewer blocks to be scanned in full table scans, which both lead to betterperformance.The segment shrink feature works only on newly created Oracle Database 10g Release2 that comes with RHN Satellite Server 5.2.0. Due to different default database settingsin Oracle Database 9i this feature does not work on databases that were upgraded fromprevious RHN Satellite Server releases.8.4.2. Backing up the DatabaseRed Hat recommends performing nightly backups of the Embedded Database and moving theresulting directory to another system via NFS, SCP, FTP, etc. Preferably, this backup system residesoff-site. To conduct a backup, shut down the database and related services first by issuing thefollowing command as root: