<<Previous Next>>
Oracle - What
are elements of database logical layers? - June 27, 2009
at 11:00 AM
What are elements of database logical
layers?
The logical layer of the database consists
of the following elements:
One or more tablespaces.
The database
schema that comprises of items such as tables, clusters, indexes,
views, stored procedures, database triggers, and sequences.
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.............
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...............
The Oracle database has a logical layer and a physical layer. The
physical layer consists of the files that reside
on the disk and logical layer map the data
to these files of physical...........
|
