<<Previous Next>>
Oracle -
Components of logical
database structure of Oracle database - Feb 18, 2010 at 11:00 AM
by Rajmeet Ghai
Components of logical database structure of
Oracle database
Tablespaces
Database's schema objects.
Tablespace: A tablespeace is a logical unit of
storage of a database on which the datafile resides. It is not
visible in the system, hence logical. Each table, index etc is
associated with a tablespace. There are three different types of
tablespaces:-
Database Schema objects: Schema objects consist
of database triggers, operators, sequences, indexes, and stored
procedures etc that together comprise a schema. A schema is a
logical structure of data and such schema objects. Schema objects
are stored logically in a tablespace of the database. Data for these
objects is present in a data file.
Also read
Describe Oracle architecture in brief, What is the function of
SMON?, Explain different types of segment, Explain SGA memory
structures..............
Session auditing, Statement auditing, Privilege auditing, Object
auditing.............
Describe the Oracle backup, i.e. archive log mode, cold and hot
backups, incremental backups.............
User process – User process is used in invocation of application
software, Data writing process - A database writer process is used
to write buffer content into a datafile. They are specifically used
to write “dirty block” to data files from the buffer................
|
