易截截图软件、单文件、免安装、纯绿色、仅160KB

oracle mutex

An introduction to Mutexes in 10gR2
By Connie Green, Kumar Rajamani
from meetings with: Kumar Rajamani, Russell Green, Saureen Shah, Cecilia Gervasio and Connie Green
Introduction
This paper is intended as an introduction to mutexes.  It describes new concepts associated with mutexes, when mutexes are used, and related wait events and views.
Overview
A mutex, similarly to a latch, is a low-level serialization mechanism used to control access to a shared data structure in the SGA.  Serialization is required to avoid an object being:
? deallocated while someone is accessing it
? read while someone is modifying it
? modified while someone is modifying it
? modified while someone is reading it
Mutexes can be defined and used in many different ways.  For example:
? Each structure being protected by a mutex can have its own mutex (e.g. a parent cursor has its own mutex, and each child cursor has its own mutex)
? Each structure can be protected by more than one mutex, with each mutex protecting a different part of the structure
? A mutex can protect more than one structure
The mutex can either be stored within the structure it protects, or elsewhere.  Mutexes are usually dynamically created at the same time as the structure they protect.  If a mutex is embedded within the structure it protects, then it will be implicitly destroyed when the owning structure is freed.
Benefits of mutexes
Although mutexes and latches are both serialization mechanisms, mutexes have certain features latches do not.
Smaller and faster
Mutexes were introduced as an alternative to latches, as they are much faster to get, and smaller.  A mutex get is in the region of 30-35 instructions, compared to 150-200 instructions for a latch.  A mutex is around 16 bytes in size, compared to 112 bytes for a latch in 10.2 (in prior releases it was 200 bytes).  Some of the reduction in latch size was achieved by obsolet


相关文档:

oracle system密码忘记解决

1.用Oracle用户登陆Linux服务器;
2.在终端窗口输入 sqlplus /nolog
   [oracle@hylinux ~]$ sqlplus /nolog
    SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 7月 29  14:26:16 2008
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
& ......

在ORACLE得到某个表的主键字段名

select column_name from all_cons_columns cc
where owner='SSH'  --SSH为用户名称,要注意大小写
and table_name='SYS_DEPT' --SYS_DEPT为表名,注意大小写
and exists (select 'x' from all_constraints c
where c.owner = cc.owner
and c.constraint_name = cc.constraint_name
and c.constraint_type ='P' ......

oracle 丢失密码

1、Oracle里面用户的密码是进行加密保存的,所以只能重新修改生成新的密码.
利用系统管理员(sys)登录,将scott用户的密码修改即可
SQL>conn / as sysdba ;
已连接。
SQL>alter user scott identified by tiger ;
用户已更改。
当然也可以到WEB端进行修改地址如下:
http://localhsot:1158/em(相应的服务必 ......

Oracle 查看用户权限以及索引

1.查看所有用户
     select * from all_users; -------查看所有的用户
     select * from user_users; --------查看当前用户
2.查看用户或角色系统权限:
     select * from user_sys_privs; --------查看当前用户的权限
3.查看角色所包含的权限
&nb ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号