|
The Oracle database has: - Logical layer: The components of the logical layer map the data to these physical components - Physical layer: The physical layer consists of the files that reside on the disk.....
|
|
The SMON background process performs all system monitoring functions on the oracle database....
|
|
There are four types of segments used in Oracle databases: - data segments - index segments - rollback segments - temporary segments.....
|
|
SGA (System Global Area) is a dynamic memory area of an Oracle Server. In SGA,the allocation is done in granuels. The size of the SGA is dependent on SGA_MAX_SIZE parameter...
|
|
The SQL*Loader control file contains information that describes how the data will be loaded. It contains the table name, column datatypes, field delimiters, etc...
|
|
Methods provided by SQL Loader - Conventional Path Load, Direct Path Load....
|
|
Logical Database structures - Logical structures include tablespaces, schema objects, data blocks, extents and segments.....
|
