Team Fly 

Page viii

Critical Skill 3.3 Perform Day-to-Day Operations

91

Architecture and Design

91

Capacity Planning

91

Backup and Recovery

91

Security

92

Performance and Tuning

92

Managing Database Objects

92

Storage Management

92

Change Management

93

Schedule Jobs

93

Network Management

93

Troubleshooting

93

Critical Skill 3.4 Understand the Oracle Database 10g Infrastructure

93

Schemas

94

Storage Structures

97

Critical Skill 3.5 Operate Modes of an Oracle Database 10g

97

Modes of Operation

98

Database and Instance Shutdown

99

Critical Skill 3.6 Get Started with Oracle Enterprise Manager

101

Instance Configuration

102

User Sessions

102

Resource Consumer Groups

102

Schema, Security, and Storage Management

103

Distributed Management

104

Warehouse Features

105

Other Tools

105

Critical Skill 3.7 Manage Database Objects

106

Controlfiles

106

Redo Logs

106

Undo Management

107

Schema Objects

108

Critical Skill 3.8 Manage Space

109

Archive Logs

110

Tablespaces and Datafiles

110

Critical Skill 3.9 Manage Users

112

Create a User

113

Edit Users

114

Critical Skill 3.10 Manage Privileges for Database Users

115

Grant Authority

115

Roles

116

Profiles

117

In Conclusion

118

Team Fly 
0009