- 浏览: 26122 次
- 性别:
- 来自: 北京
最新评论
1.concepts about DS and SS
DS:Oracle will create a new process for me when I log in. This is commonly
referred to as the dedicated server configuration, since a server process will be dedicated to me
for the life of my session.
One client process mapping to One DS process
datafiles
client----- DS server process--get data from-----
sga
SS(MTS):In shared server mode, the shared processes are generally started up with the database.
the client connection will send a request to the dispatcher. The dispatcher will first place this request onto the request queue in the SGA (1). The first available shared server will dequeue this request (2) and process it. When the shared server completes,
the response (return codes, data, and so on) is placed into the response queue (3), subse-
quently picked up by the dispatcher (4), and transmitted back to the client.
client------dispatchers------request quence------
|
|
available shared server process
|
|
get data
|
|
shared server place the response into the the response queue
Note:Both dedicated and shared server processes have the same job: they process all of the SQL you give to them. When you submit a SELECT * FROM EMP query to the database, an Oracle dedi-cated/shared server process parses the query and places it into the Shared pool (or finds it in the Shared pool already, hopefully). This process comes up with the query plan, if necessary,
and executes the query plan, perhaps finding the necessary data in the buffer cache or reading the data from disk into the buffer cache.
Connection and Session
Note:
A connectionmay have zero, one, or more sessions established on it. Each session is separate and inde-pendent, even though they all share the same physical connection to the database.
A connection is simply a physical circuit between your client process and the database instance—a network connection, most commonly. The connection may be to a dedi-
cated server process or to a dispatcher. As previously stated, a connection may have zero or more sessions, meaning that a connection may exist with no corresponding sessions.
A session is a logical entity that exists in the instance,It is your session in the server, where you execute SQL, commit transactions, and run stored procedures.
Dedicated Server
1.one connection have one or zero session
client:sqlplus hr/hr@oraclelsh
server:ps -ef| grep oracle
oracle 5438 1 0 12:09 ? 00:00:00 oraclelsh (LOCAL=NO)
client:disconnect
server:ps -ef| grep oracle
oracle 5438 1 0 12:09 ? 00:00:00 oraclelsh (LOCAL=NO)
2.one connection two sessions
client: sqlplus system/oracle@oraclelsh
server:ps -ef | grep oracle
oracle 1234 1 0 12:09 ? 00:00:00 oraclelsh (LOCAL=NO)
select sid,username,addr from v$session;
1234 system
client: set autotrace on
select sid,username,addr from v$session;
1234 system
1235 system
server: ps -ef | grep oracle
1234 system
Shared Server
dispatchers(if ora-00105,we modify it in the pfile.then create spfile,last statup)
max_dispatchers
shared_servers
max_shared_servers
circuits
shared_server_sessions
ora_d000_lsh(dispatchers processes)
ora_s000_lsh(shared server processes)
server=shared/dedicated
1 when in shared server connection. we can not startup,shutdown immediate,backup.(
ORA-00106: cannot startup/shutdown database when connected to a dispatcher)
we statup,shudown database in dedicated server.
2.ORA-12520: TNS:listener could not find available handler for requested type of servercheck server is in DD or MTS.
in tnsnames.ora,we choice error way(server=dedicated or shared)
alter system set dispatchers='(protocol=tcp)(dispatchers=1)'
3. view the current session use which connection type.
select sid from v$mystat;
select server from v$session;
4.ERROR:ORA-12523: TNS:listener could not find instance appropriate for the client connection
(SERVICE_NAME = db_name.db_domain)
v$circuit
v$dispatcher
v$shared_server
v$queue
v$sesson
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 857declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6861.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7591.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 854thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7141.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 770Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6631.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7181.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11251.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5391.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6201.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 711When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 560A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6571.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4171.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7651.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5431. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6641.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8731.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 632ORACLE_HOME ORACLE_SID : or ...
相关推荐
valheim(英灵神殿)服务器指南
ue4 dedicated server-附件资源
左4死2专用服务器备份 Left 4 Dead 2 Dedicated Server附加组件和cfg文件夹备份
带有Google V8 JS引擎(metamod插件)的Half Life Dedicated Server ! 已废弃,请参阅 (node / io.js + hlds作为metamod插件) 如何建造 获取文件 从下载metamod(版本:1.20) 从下载修补的HLSDK(版本:2.3p4...
图形用户界面,用于维护Armagetron高级专用服务器
MCscripts:Minecraft Java Edition和Bedrock Dedicated Server系统单元,bash脚本和聊天机器人,用于备份,自动更新,安装和关闭警告
❑ The last six chapters (Chapters 14–19) are dedicated to introducing you to the SQL Server 2008 services, and features including the Common Language Runtime (CLR), SQL Server’s Business ...
the CAS role and the Hub Transport role, two updated roles to Exchange Server 2010 that are critical to the Exchange Server 2010 organizational environment. .Part VI: Exchange Server 2010 ...
building-ue4-dedicated-server-blog-1:用于使用AWS和Docker构建和托管Unreal Engine 4专用服务器的源代码
dst-dedicated-server:不要让带有Docker的所有平台(Linux,Mac,Windows)挨饿的专用服务器指南。 广泛的文档,包括mods的安装,服务器配置和性能,世界范围的生成以及设置管理员
Do you need to transfer files between... Now you can do it, and you don't have to install any dedicated server.您是否需要在本地不同的设备之间传输文件? 现在你可以这样做了,而且你不需要安装任何专用服务器。
Apache Server 1.3.11 in source code and Windows binary format Apache Server 1.3.9 in source code and Windows binary format CGIWrap 3.6.4 in source code format Comanche 2.0 for UNIX and Windows ...
学习Oracle是一个复杂、繁琐的过程。在浩如烟海的Oracle官方资料、新特性、MOS资料和...1、 从Dedicated Server到Shared Server Client Process连接到Server Process的方式,传统上有两种方式:Dedicated Server和Sh
:globe_showing_Europe-Africa: Empyrion-DK-服务器 :ringed_planet: Empyrion服务器v1.4.x 嗨,我为我的朋友和我创建了一个Empyrion Galactic Survival Server,我想分享我所做的所有更改 :face_savoring_food: ###...
主要介绍了DPAA中的专用通道以及通道池的概念
Dedicated_Valheim_Server_Script 用于Linux安装的安装脚本 Twitch频道:零带宽 使用一个脚本构建Valheim服务器 除非您知道正在做什么,否则请勿在生产服务器上使用 在Ubuntu 18 64 LTS DigitalOcean,AWS和Azure上...
Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter’s domain. Emphasis is always put upon ...
game machine Rear projection dedicated,Linear and I2C bus adjustment.
Repository with leetcode solutions and dedicated index to