Please enable JavaScript.
Coggle requires JavaScript to display documents.
Topic 2 Oracle DB Structure (2.3 Data Blocks, Extends, Segments (Data…
Topic 2 Oracle DB Structure
2.1 Network Environment
Listener Configuration
Connecting Oracle DB
Network Configuration
Client Connection
Tools for network configuration
Oracle Net Listener
2.2 Oracle Instance
Background Process
Server & Client Process
Initialization Parameter
Instance memory structure
What is Oracle instance?
Instance start up & shut down
2.3 Data Blocks, Extends, Segments
What is extents?
Extents Allocated:
Dictionary managed
Locally managed
Free space in data block
What is segments?
Data blocks format
Overhead
Row Directory
Table Directory
Header
Types of segments
Data segments
Index segments
Temporary segments
What is Oracle data block?
2.5 Data Dictionary
structure of data dictionary
User accessible view
Base tables
What is data dictionary?
2.4 Managing Memory
Automatic memory management
Modifying memory settings
Memory management