introduction to oracle 10g n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Introduction to Oracle 10g PowerPoint Presentation
Download Presentation
Introduction to Oracle 10g

Loading in 2 Seconds...

play fullscreen
1 / 32

Introduction to Oracle 10g - PowerPoint PPT Presentation


  • 82 Views
  • Uploaded on

Introduction to Oracle 10g. Chapter 13 Database Administration. James Perry and Gerald Post. Chapter Outline. Overview of a DBA’s Duties Using the Enterprise Manager Understanding Oracle Storage Files Configuring Space for Schema Objects Exporting and Importing Data Maintaining the DBMS

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Introduction to Oracle 10g' - lonato


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
introduction to oracle 10g

Introduction to Oracle 10g

Chapter 13

Database Administration

James Perry and Gerald Post

© 2007 by Prentice Hall

chapter outline
Chapter Outline
  • Overview of a DBA’s Duties
  • Using the Enterprise Manager
  • Understanding Oracle Storage Files
  • Configuring Space for Schema Objects
  • Exporting and Importing Data
  • Maintaining the DBMS
  • Backing up the Database
  • Monitoring and Improving Database Performance
  • Obtaining Useful Information from System Views

© 2007 by Prentice Hall

13 1 the enterprise manager main page
13.1 The Enterprise Manager main page

Using the Enterprise Manager

© 2007 by Prentice Hall

13 3 enterprise manager administration security users page
13.3 Enterprise Manager Administration/Security/Users page

Modify existing

User account

Create new user

MarcouxK user

Created in Chapter 13

© 2007 by Prentice Hall

13 4 location of current control files
13.4 Location of current control files

Understanding Oracle storage files

© 2007 by Prentice Hall

13 5 oracle tablespaces and datafiles
13.5 Oracle tablespaces and datafiles

Redwood tables

Redwood indexes

RW01.DBF

RWTablespace1

RWTablespace2

RW02.DBF

RWI01.DBF

RW03.DBF

Segment

Extent

Data blocks

© 2007 by Prentice Hall

13 6 sample tablespaces
13.6 Sample tablespaces

© 2007 by Prentice Hall

13 7 creating a new datafile
13.7 Creating a new datafile

© 2007 by Prentice Hall

13 8 creating a new tablespace
13.8 Creating a new tablespace

© 2007 by Prentice Hall

13 9 effect of the pctfree parameter
13.9 Effect of the PCTFREE parameter

PCTFREE 20%

Reserved for Updates

Data block

Row data from inserts

Free space

Administrative data

overhead

© 2007 by Prentice Hall

13 10 metalink patch search
13.10 MetaLink patch search

Maintaining the DBMS

© 2007 by Prentice Hall

table 13 3 shutdown options
Table 13.3 Shutdown options

© 2007 by Prentice Hall

13 11 shutting down oracle with the windows service manager
13.11 Shutting down Oracle with the Windows service manager

Stop a service

Listener for

Enterprise Manager

Listener for

iSQL*Plus

Main Oracle services

© 2007 by Prentice Hall

table 13 4 startup options
Table 13.4 Startup options

© 2007 by Prentice Hall

13 12 recovering an active database
13.12 Recovering an active database

Recovered database

Primary database

Disk crash

Time

Redo Archive log

Full backup copy

© 2007 by Prentice Hall

13 14 metrics used for standard alerts
13.14 Metrics used for standard alerts

Monitoring the DBMS

© 2007 by Prentice Hall

13 15 setting an alert to send you an e mail message
13.15 Setting an alert to send you an e-mail message

Setup to enter e-mail

server information

General to enter

your e-mail address

Preferences

Rules to pick events

© 2007 by Prentice Hall

table 13 6 tuning advisors
Table 13.6 Tuning advisors

© 2007 by Prentice Hall

13 18 automated performance analysis problems found
13.18 Automated performance analysis problems found

Select a time period

Choose a finding

© 2007 by Prentice Hall

13 20 query execution plan
13.20 Query execution plan

Optimizing queries

© 2007 by Prentice Hall

13 21 tuning advisor recommendations
13.21 Tuning advisor recommendations

© 2007 by Prentice Hall

table 13 7 common dba views
Table 13.7 Common DBA views

© 2007 by Prentice Hall