List prerequisites to connect
to oracle with a administrator previleges
1.User's O.S account has O.S previleges.
2.The user is granted the SYSDBA or SYSOPER previleges
and database user the password files to authenticate database administration.
3.The database has a passsword for the internal login.
oracle server
/ \
Oracle database oracle instance
/
\
Physical database structure Logical database structure
(An oracle database's physical structure is datermined by the O.S files
that constitute database)
Each oracle database is made of 3 types of files:
- one or more datafile
- 2 or more redo log files
- 1 or more control files
Oracle Instance
System global area(SGA) is an area of memory used for
database admin. shared by the database servers.
The combinamtion of the background process and memory
buffers is called an instance.
Oracle Instance
/
\
User process Oracle process
/
\
server process background
process
A user process executes the code of an application program
or an oracle tool.
Oracle process are server process and background process.
If the user and server process are on differrent computers
of a network, if the user process connect to hares server process
thro' dispatcher process, the user process and server process communicate
thro' on using SQL* NET.
* Normally tablespace is online than offline.
b)Schemas and Schema objects
* Schema is collection objects
* Schema objects are the logical structures that directly
refer to the database's data. Schema objects include structures as
tables,views,sequence.
(There is no relationship between a tablespace and schema).
1. table
2.view - A view can also be thought of as a stored
query.
3.sequences
4.program unit
5.synonyms
6.Index,cluster and hash clusters
7.database link
Datablocks, Extents and segments
*one datablock corresponds to a specific number of bytes
of physical database space on disk.
*An extent is a specific number of continumous datablock
obtained in a single allocation used to store a specific
Kiran
Have a Oracle Question
Do
you have an Oracle Question?
Oracle Books
Oracle Certification,
Database Administration, SQL, Application, Programming Reference Books
Oracle Application
Oracle
Application Hints and Tips
Oracle Home
Oracle
Database, SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|