Explain Oracle Database Administrator's weekly responsibilities

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.