NingOO
NingOO
搜视小站
搜视小站
翻译 Oracle 8i interal Service (3.2 Parent and Child Latches)
3.2 Parent and Child LatchesMost internal Oracle data structures that are protected by latches are protectedby only one latch. However, in some cases more than one latch may be used. Forexample, there...
Itpub
Itpub
有志于管理的人才看
有志于管理的人才看
存在Histogram数据,使用绑定变量的情况.
SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionPL/SQL Release 9.2.0.1.0 - ProductionCORE 9...
Toms_zhang
Toms_zhang
zhouwf0726
zhouwf0726
名人名言
名人名言
丁丁地图
丁丁地图
翻译 Oracle 8i interal Service (3.1 Latches and Locks)
Chapter 3. LatchesThere are numerous data structures in Oracle's System Global Area (SGA) that need to beaccessed concurrently by many different database processes. It is essential that only oneproces...
如何禁止或允许某些客户端访问ORACLE SERVER
ORACLE9I: 在slqnet.ora添加如下内容 TCP.INVITED_NODES =(<Client IP-ADDRESS 1>, <Client IP-ADDRESS 2>)--这里是允许访问的IP TCP.EXCLUDED_NODES=(<Client IP-...
对通过index range scans访问的表的优化
表authors有1706123行,39677个blocks,259个empty blocks,在au_fname有索引INDEX_AUTHORS.对表进行分析.Analyze Table AUTHORSCompute StatisticsFor All Indexes;SQL> select CLUSTERING_FACTOR from dba_indexes wh...
Eygle的网站
Eygle的网站
cnoug
cnoug
sap在线学习
sap在线学习
孟子e章
孟子e章
一次ORA-27037: unable to obtain file status故障的解决
数据库前端用两台solaris服务器(DB1,DB2)做HA,数据文件存放在存储上和NAS上。试过之前没做过切换。目前运行在DB1上。bash-2.03$ df -kFilesystem kbytes used avail capacity Mounted on/dev/dsk/c1t0d0s0 2...
ixdba
ixdba
yangtingkun
yangtingkun