2.3. Configure an alert on the SYSTEM tablespace of the PROD database.The alert should register as a warning at 87% full and critical at 95% full.
Metric and Policy Settings->Tablespace Space Used (%) ->edit-> SYSTEM
2.4. Setup notifications to be sent to the email address'dba@ocm.com'Notification messages should be sent to this address at anytime. 右上角Preferences
2.5. Using Grid Control,create a new tablespace in the PROD database called REGISTRATION 2.5.1 Create with on 90MB datafile
2.5.2 Make sure this datafile can grow to 120MB if need be
2.5.3 Configure the tablespace for optimal block space utilization
targets-> database-> administration->Tablespaces-> create-> REGISTRATION ->add ->continue->ok
3.Implementing Schedules and Jobs
3.1. Using Grid Control,create a schedule for the PROD database. 1.1 Call this schedule DAILYREBUILD 1.2 Configure it to run at 2PM every day
targets-> database-> administration-> Schedules-> create link -> DAILYREBUILD -> ok
3.2. Create a program for the PROD database called EMP_IND_REBUILD that rebuilds all indexes on the HR.EMPLOYEES table.
targets-> database-> administration-> Programs -> create -> EMP_IND_REBUILD -> ok