Oracle Database AdministratorThe workload is very large, from the daily responsibilities, there is a week of work, as well as the monthly work, we have already introduced you to explain the daily responsibilities of the Oracle database administrator, next we will share with you the weekly responsibilities of the Oracle database administrator ".
Weekly Work
(1) control the space expansion of database objects
Find the database objects that quickly expand the space according to the daily check results of this week, and take corresponding measures
-- Delete historical data
--- Expand table space
Alter tablespace add datafile ''size
--- Adjust the storage parameters of Data Objects
Next extent
Pct_increase
(2) monitoring data volume growth
Find the database objects with fast-growing records based on the daily check results of this week and take appropriate measures
-- Delete historical data
--- Expand table space
Alter tablespace add datafile ''size
(3). System Health Check
Check the following:
Init. ora
Controlfile
Redo log file
Archiving
Sort area size
Tablespace (system, temporary, tablespace fragment)
Datafiles (autoextend, location)
Object (number of extent, next extent, index)
Rollback segment
Logging & tracing (alert. log, max_dump_file_size, sqlnet)
(4) Check invalid database objects
SELECT owner, object_name, object_type FROM dba_objects
WHERE status = 'invalid '.
(5) constraints that do not work
SELECT owner, constraint_name, table_name,
Constraint_type, status
FROM dba_constraints
WHERE status = 'Disabled 'AND constraint_type = 'P'
(6) Check for invalid triggers
SELECT owner, trigger_name, table_name, status
FROM dba_triggers
WHERE status = 'Disabled'
Now we know that the Oracle Database Administrator does not do anything in the office. The workload of the Oracle database administrator is still large, and the responsibilities are heavy.