这两天有同事抱怨公司的开发环境Oracle Server总是报告达到最大用户数限制登录,解决问题过程中,知道了一些早就应该掌握的oracle基本概念:
1.
What's the difference between connections, sessions and processes?
-- A connection is a physical circuit between you and the database. A connection
might be one of many types -- most popular begin DEDICATED server and SHARED
server. Zero, one or more sessions may be established over a given connection
to the database as show above with sqlplus. A process will be used by a session
to execute statements. Sometimes there is a one to one relationship between
CONNECTION->SESSION->PROCESS (eg: a normal dedicated server connection).
Sometimes there is a one to many from connection to sessions (eg: like
autotrace, one connection, two sessions, one process). A process does not have
to be dedicated to a specific connection or session however, for example when
using shared server (MTS), your SESSION will grab a process from a pool of
processes in order to execute a statement. When the call is over, that process
is released back to the pool of processes.
2. 以后补充..
分享到:
相关推荐
这是我学习过程中整理的oracle数据库基础知识,里面包含了DML、DDL等相关语句。还解释了什么情况下该用什么样的SQL。包含了很多基础知识。欢迎大家收藏。
Oracle数据库基础知识讲义
Oracle语法,有关于oracle的基础知识。
Oracle DBA基础知识, DBA必备宝典!
1、Oracle数据库函数大全 2、Oracle数据库傻瓜一千问 3、Oracle初级学习 。。。。。等等诸多文件
oracle 基础知识整理
oracle基础知识.PDF oracle基础知识.PDF oracle基础知识.PDF oracle基础知识.PDF
oracle ORACLE 基础资料 基础知识 培训资料oracle ORACLE 基础资料 基础知识 培训资料oracle ORACLE 基础资料 基础知识 培训资料oracle ORACLE 基础资料 基础知识 培训资料
Oracle数据库基础知识(华为内部培训资料
oracle基础入门,有助于数据库初学者了解oracle!有助于学习~其实挺垃圾的,专骗分~
适用于新手大体了解oracle的知识体系跟基础语法学习
"oracle数据库基础知识" Oracle数据库基础知识是指学习和掌握Oracle数据库的基本概念、原理和技术。学习Oracle数据库基础知识需要具备一定的数据库基础知识和SQL语言基础,在学习过程中需要逐步掌握Oracle的体系...
安装 oracle 数据库 10g 的基础知识