Oracle Database server structures:
1.memory structures
2.process structures
3.stroage structures
Oracle Database system:
1.Oracle Database
2.database instance
•System Global Area(SGA)
•Shared Pool : Caches various constructs that can be shared among users
- Library cache
- Shared SQL area
- Data dictionary cache
- Control structures
•Database buffer cache :Caches blocks of data retrieved from the database
Is part of the SGA
Holds copies of data blocks that are read from data files
Is shared by all concurrent users
•KEEP buffer pool : A specialized type of database buffer cache that is tuned to retain blocks of data in memory for long periods of time
•RECYCLE buffer pool : A specizlied tyoe of database buffer cache that is tuned to recycle or remove block from memory quickly
•nK buffer cache : One of several specialized database buffer caches designed to hold block size different than the default database block size
•Redo log buffer : Caches redo information(used for instance recovery) until it can be written to the physical redo log files stored on the disk
Is a circular buffer in the SGA
Holds information about chages made to the database
Contains redo entries that have the information to redo chages made by operations such as DML and DLL
•Large pool : Optional raea that provides large memory allocations for certain large process,such as Oracle backup and recovery operations,and I/O server process
Session memeory for the shared server and the Oracle XA interface
I/O server processes
Oracle Database backup and restore operations
•Java pool : Used for all session-specific java code and data in the Java Virtual Machine(JVM)
Java pool memory is used to store all session-specific Java code and data in the JVM
•Stream pool : Used by Oracle Streams to stroe information required by capture and apply
Streams pool memory is used exclusively by Oracle Streams to:
- Store buffered queue messages
- Provide memory for Oracle Streams processes
•Program Global Area(PGA)
•stack space
•user global area(UGA)
Cursor area for storing runtime information about a session
User session data storage area for control information about session
SQL working areas for processing SQL statements consiting of :
- A sort area for functions that order data such as ORDER BY and GROUP BY
- A hash area for performing hash joins of tables
- A create bitmap area used in bitmap index creatiion common to data warehouses
- A bitmap merge area used for resolving bitmap index plan execution
相关推荐
Oracle Memory Structures 1-10 Process Structures 1-12 Oracle Instance Management 1-13 Server Process and Database Buffer Cache 1-14 Physical Database Structure 1-15 Tablespaces and Data Files 1-17 ...
Oracle官方文档的中英对照版本,强烈推荐!!! 1.1 Oracle数据库体系结构 An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related ...
The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements for implementation How to recognize and ...
He has worked for Tata Consultancy Services Ltd., Oracle India Pvt. Ltd., and Talentica Software Pvt. Ltd. Table of Contents Why Bother? – Basic Cogs and Pulleys – Building Blocks Protocols – ...
structures, and processes that comprise an Oracle database and instance. I then move on to discuss important database topics such as locking, concurrency controls, how transactions work, and redo and ...
Manage files and memory structures for performance and reliability Scale up through partitioning and parallel processing Load and unload data to interface with external systems Who this book is for ...
Oracle 实例(Oracle Instance)是一组后台进程(Backguound Processes)和内存结构(Memory Structures)组成的实体。一个数据库可以有多个实例,每个实例都可以有不同的配置和参数设置。 用户 用户是在实例下...
7 Managing Database Storage Structures 8 Administering User Security 9 Managing Data Concurrency 10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 ...
(data structures, algorithms, hidden parameters, and undocumented system statistics). Main topics include waits, latches, locks (including instance locks used in parallel server environments), and ...
Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black ...
7 Managing Database Storage Structures 8 Administering User Security 9 Managing Data Concurrency 10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 ...
* Manage files and memory structures for performance and reliability * Scale up through partitioning and parallel processing * Load and unload data to interface with external systems * Think for ...
Oracle's E-Business Suite Human Capital Management enables organizations to architect a global foundation for HR data and improved business processes. The book starts by introducing Oracle ...
ORACLE OSB开发指南,英文版。 目录: Part I IDE Help for Oracle Service Bus 1 Introduction to Oracle Service Bus 2 Tasks Working with Projects, Folders, Resources, and Configurations .....................
7 Managing Database Storage Structures 8 Administering User Security 9 Managing Data Concurrency 10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 ...
with Stackowiak, of Oracle 9 Essentials <br>Shows how to use Oracle data and data structures to build robust, scalable database applications using Java, SQL, and PL/SQL <br> ...
Chapter 6, "Managing Database Storage Structures" This chapter discusses management of the database’s storage structure. Chapter 7, "Administering Users and Security" This chapter discusses how to ...
* fnd_id_flex_structures where id_flex_code=""GL#"" * fnd_id_flex_segments where id_flex_code=""GL#"" and id_flex_num=50671 * fnd_profile_options_vl * fnd_concurrent_programs 法度表 * fnd_concurrent...
This lesson introduces the Oracle server architecture by examining the physical, memory, process, and logical structures involved in establishing a database connection, creating a session, and ...