An Oracle Server :
Is a Database management system that provites an open,comprohensive,integrated approach to information
management;
Consists of an Oracle Instance and an Database;
An Oracle Instance :
Is a means to access an Oracle Database,//防问Oracle的一种手段;
Always opens one and onlyone Datebase ;//只能访问一个Database;一个Database 会有多个Instance 访问。
Consists of memory and background process structures.//由内存块和后台进程组成
Connecting to an oracle instance ;
Extablished a user connection;//客户端与后台进程的一个TCP连接,身份,安全认证等
create a session;//Conection连接后产生SESSION 与Connection是相辅相成的;
An Oracle Database ;
Datafile : 真正的数据
Controlfile:
redo Log file:重作日志,记录数据库的改变 作用:回滚数据库------------->>Archived Log files:归档日志
Oracle memory:
SGA:System Global Area :Alllocated as an Instance set up ,and is a fundanmental component of an Instance :Instance 启动时分配,Instance的一个基本组成部分。
PGA:Program Global Area :Allocated when the server process started :server process :处理连接和其它的任务 ,一个INSTANCE 只有一个SGA 可有多个PGA