- 浏览: 340367 次
- 性别:
- 来自: 长沙
文章分类
最新评论
-
苍ing:
的确很郁闷啊。同时用代码生成的页眉页脚,wps打开时看不到页眉 ...
iText生成word代码及jar包(含页眉页脚) -
jinhuazhe:
写的挺好的,有用
Unix 环境变量设置 -
zoboy:
iText生成word代码及jar包(含页眉页脚) -
zhangxy2188:
下载不了哦,请楼主重新提供一下,谢谢!
cognos10下载 -
housen1987:
shuai_94250 写道licence无效啊,麻烦您指点一 ...
Sybase数据库客户端——Auqa Data Studio 7.5(破解版)
certification objectives:
- Describe the Single-Instance Architecture
- Explain the Memeory Structures
- Describe the Process Structures
- Summarize(总结) the Storage Structures
An oralce server consists of two entities:the instance and the database.The instance is memeory structures and processes;the database is file on disk.They are separate(分离的),but connected(有联系的).During the creation process,the instance is created first,and then database during the startup process first(优先于) the instance is started,and then the database is opened.In a typical single-instance environmnet,the relationship of instance to database is one-to-one,a single instance connected to a single database,but always bear in mind(考虑到) that there are more complex possibilities for distributed(分布式) environments.
Within the Oracle server,there is complete abstraction of logical storage from physical storage(从物理存储到逻辑存储的完全抽象).The logical structures programmers see (such as tables) are not directly related to the physical structures (datafiles) that system adminsistrators see(程序员看到的逻辑结构(比如表)和系统管理员看到的物理结构(比如数据文件)并没有直接的关系).The relationship between the two is maintained by structures within the controlfile and the data dictionary(两者的关系通过控制文件和数据字典之间的结构维持).
Describe the Single-Instance Architecture
For the most(大多数) part in this book,you will be dealing with the most common database environment:one instance on one computer,opening a database stored on local disks.The more complex distributed architectures,involving(涉及) multiple instances and multiple databases,are beyond(超出...范围) the scope of the OCP examination(though not the OCM qualification(资格,条件,限制)) ,but you may relistically expect to see high-level summary questions on distributed architecture(但实际上你可能期望看到更高级的分布式架构问题).
Single Instance Database Architecture
The instance consists of memory structures and processes.Its existence is transient(短暂的),in your RAM and on your CPU(s).When you shutdown the running instance,all trace(痕迹) of its existence goes away at the same time.The database consists of physical files on disk,Whether running or stopped,these remian(保持,残存).Thus the lifetime of the instance is only as long as it exists in memory:it can be started and stopped.By contrast(对比,相比之下),the database,once created,persists indefinitely(不确定的)--until you deliberately(故意的,慎重的) delete the files that are associated with the database.
The process that make up the instance are known as background processes(实例产生的进程被认为是后台进程),because they are present and running at all time while the instance is active(因为当实例是活动状态时,这些进程一直存在并运行).These processes are for the most part completely self-administering,though in some cases it is possible for the DBA to influence(影响,改变) the number of them and their operation(尽管在一些情况下,DBA可能会改变这些进程的序号或操作,但很大程度上这些进程是自我管理的).
The memory structures,which are implemented in shared memory segments provided by the operating system,are known as the system global area,or SGA(内存结构式通过操作系统提供的共享内存段实现的,常被称作系统全局区,或SGA).This is allocated at instance startup and released on shutdown.Within certain limits,the SGA in the 11g instance and the components within it can be resized while the instance is running,either automatically or in response the DBA's instructions.(SGA在实例启动分配,在实例关闭时释放。在一定范围内,当实例运行时,11g实例中的SGA和它内部的组件是可以自动调整或根据DBA的指令调整。)
User sessions consist of a user process running locally to the user machine connecting to a server process running locally to the instance on the server machine.(一个运行在用户机器上的用户进程连接到一个运行在服务器实例上的服务进程构成了用户会话)。The technique for launching the server processes,which are started on demand for each session,is covered in Chapter 6.(每个会话都需要启动服务器进程,启动服务器进程的知识,会在第6章介绍)。
发表评论
-
存储过程返回多个结果集
2012-07-20 13:54 7326对于查询试的存储过程,一般会返回一个结果集,这个时候,使用正常 ... -
Oracle学习第三课(启动oracle)
2012-01-19 10:39 38【学习是螺旋上升的过程,由易到难,由少到多,由点到面,每一个步 ... -
oracle锁表与解除锁定
2012-01-17 13:50 3161SELECT s.sid,s.serial# as seria ... -
Oracle学习第二课(登出oracle和删除用户)
2012-01-14 19:43 4024【学习是螺旋上升的过程,由易到难,由少到多,由点到面,每一个步 ... -
Oracle学习第一课(登录oracle和创建用户)
2012-01-14 18:16 53327【学习是螺旋上升的过程,由易到难,由少到多,由点到面,每一个步 ... -
oracle sqlplus出现中文乱码
2012-01-13 22:24 1721使用下面语句设置当前session的语言环境: ... -
oracle中如何创建dblink
2012-01-12 16:56 1534当用户要跨本地数据库 ... -
安装完Oracle之后没有isqlplus服务
2012-01-12 01:15 1543在命令行中运行isqlplusctl start命令即可。 -
Osgi SpringDM struts2 学习笔记
2012-01-09 10:40 3182本笔记针对Spring-dynami ... -
JAR 文件规范(年底了,最近两天比较忙,可能要慢一点)
2012-01-07 13:03 3933英文版本: http://docs.oracle. ... -
第18章 Moving Data
2011-12-29 00:14 878certification objectives: D ... -
第11章 Managing Undo Data(管理撤销数据)
2011-12-24 17:55 1084certification objectives Ex ... -
Introduction to the Oracle Server Technologies(Oracle服务器技术介绍)
2011-12-22 21:33 1205certification objectives: Pos ... -
第七章 显示多个表中的数据
2011-12-18 17:08 1486认证目标: 使用同等连接和非同等连接编写select子 ... -
最简单的Oracle数据恢复 select ... as of
2011-12-09 10:20 5747概念: You perform a Flashback Qu ... -
cognos10下载
2011-12-08 22:10 2873cognos10 for windows下载地址: ... -
第八章 使用子查询解决问题
2011-12-06 15:42 1443认证目标: 定义子查询 描述子查询能够解决的问题的类 ... -
Oracle建立HR模式
2011-11-18 10:32 9651官方帮助 写道 Installing the HR Sch ... -
Oracle 权限、角色和安全规则
2011-11-16 15:54 1372权限 权限是执行某种类型的SQL语句和访问其他用户对象的 ... -
Oracle性能监视
2011-11-16 11:43 1193反应性监视(reactive) 10g以前的监视方法,事 ...
相关推荐
Beginning iPhone Development with Swift Exploring the iOS SDK随书源代码
This book is ideal for a one-semester course in statistics, offering a streamlined presentation of Introductory Statistics: Exploring the World through Data, by Gould/Ryan. Exploring the World through...
Beginning iOS 6 Development Exploring the iOS SDK ios开发基础教程
Exploring the Junos CLI, Second Edition The Junos OS command-line interface (CLI) includes dozens of shortcuts to get things done in your network. You’ll spend much less time pounding away on your ...
Beginning iOS 7 Development Exploring the iOS SDK随书源代码
Beginning iOS 7 Development Exploring the iOS SDK 英文无水印pdf pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,...
You'll also learn how to save and retrieve your data using SQLite, iPhone's built-in database management system. You'll learn how to draw using Quartz 2D and OpenGL ES. You'll add MultiTouch ...
2 Exploring the Database Architecture 3 Preparing the Database Environment 4 Creating an Oracle Database 5 Managing the Oracle Instance 6 Configuring the Oracle Network Environment 7 Managing ...
PIC32目前唯一的一本教材,书中内容都是作者的真实经验的总结,和PIC32的数据手册结合起来能够很快地入门。
Title: Beginning iPhone Development with Swift 5: Exploring the iOS SDK, 5th Edition Author: Wallace Wang Length: 628 pages Edition: 5th ed. Language: English Publisher: Apress Publication Date: 2019-...
本书重新审查了理论计算机科学,提供了一种新的方法,该方法将资源折衷和复杂性分类的优先级放在机器的结构及其与语言的关系上。
EXPLORING THE PATH TO ARTIFICIAL GENERAL ... 探索通往人工通用的道路
Exploring the Representation Capabilities of the HOG Descriptor
Ceaser Exploring the Monitoring Rules in the Time Dimension
科学树:探索巴西学术谱系的平台_Science Tree A Platform for Exploring the Brazilian Academic Genealogy.pdf
18 Exploring the Domain 359 18.1 Application Factory Attributes 360 18.2 Application Attributes 362 18.3 DeviceManager Attributes 366 18.4 Device Attributes 368 18.5 AggregateDevice Attributes 370 ...
PDF格式,添加了书签,英文版。中文译名为《iPhone开发基础教程》。
Exploring the Ethereum Blockchain with etherchain
Building Great Sentences - Exploring the Writer's Craft Building Great Sentences - Exploring the Writer's Craft
1 Exploring the Oracle Database Architecture 2 Installing your Oracle Software 3 Creating an Oracle Database Using DBCA 4 Managing the Database instance 5 Managing the ASM Instance 6 Configuring ...