Oracle Database 11g SQL Tuning Workshop - Student Guide.pdf

(2622 KB) Pobierz
Oracle Database 11g: SQL Tuning
Workshop
Electronic Presentation
D52163GC10
Edition 1.0
June 2008
Author
Jean-François Verrier
Copyright © 2008, Oracle. All rights reserved.
Disclaimer
This document contains proprietary information and is protected by copyright and other intellectual
property laws. You may copy and print this document solely for your own use in an Oracle training
course. The document may not be modified or altered in any way. Except where your use constitutes
"fair use" under copyright law, you may not use, share, download, upload, copy, print, display,
perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part
without the express authorization of Oracle.
The information contained in this document is subject to change without notice. If you find any
problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway,
Redwood Shores, California 94065 USA. This document is not warranted to be error-free.
Restricted Rights Notice
If this documentation is delivered to the United States Government or anyone using the
documentation on behalf of the United States Government, the following notice is applicable:
Technical Contributors and
Reviewers
Muriel Fry (Special thanks)
Joel Goodman
Harald van Breederode
Jörn Bartels
Pekka Siltala
Bernard Soleillant
James Spiller
Clay Fuller
Ira Singer
Christopher Andrews
Magnus Isaksson
Sean Kim
Trevor Bauwen
Yash Jain
U.S. GOVERNMENT RIGHTS
The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these
training materials are restricted by the terms of the applicable Oracle license agreement and/or the
applicable U.S. Government contract.
Trademark Notice
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be
trademarks of their respective owners.
Editors
Amitha Narayan
Raj Kumar
Graphic Designer
Priya Saxena
Publishers
Jothi Lakshmi
Veena Narasimhan
Exploring the Oracle Database Architecture
Copyright © 2008, Oracle. All rights reserved.
Objectives
After completing this lesson, you should be able to:
•
List the major architectural components of the Oracle
Database server
•
Explain memory structures
•
Describe background processes
•
Correlate logical and physical storage structures
1-2
Copyright © 2008, Oracle. All rights reserved.
Oracle Database Server Architecture: Overview
Instance
SGA
BGP1
BGP2
BGP3
BGPn
Database
1-3
Copyright © 2008, Oracle. All rights reserved.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin