ORACLE parent latch和children latch
About parent vs child latches. There is no fundamental low level difference between parent and child latches, they are all small regions of memory modified with atomic test-and-set style opcodes.
You see parent (and solitary) latches from x$ksllt where kslltcnm = 0 and child latches have Kslltcnm > 0 (their child number is stored there).
V$LATCH_PARENT shows all latches with kslltcnm 0, V$LATCH_CHILDREN shows all latches with cnm > 0. V$LATCH just summarizes & groups all statistics up using the latch number, it doesn't care about parent vs child latches.
It's up to Oracle, how it uses the child and parent latches, normally when child latches are used, parent latches don't get used much (or at all), since all resources to be protected have been spread between child latches already.
今天看到书中讲LATCH的时候提到了两个视图V$LATCH_CHILDREN和V$LATCH_PARENT ，不太清楚两者的区别，去百度了一下，还没百度到，GOOGLE了才找到一篇相关的文章。
看了上面的讲解，我个人理解就是二者其实没什么区别，完全取决于ORACLE如何使用。
相关文档：
============================Question================================
SQL> select * from emp;
EMPID EMPNAME SALARY DEPTID
---------- ----------- ......
聚集(cluster)是存储表数据的可选择的方法。一个聚集是一组表，将具有同一公共列值的行存储在一起，并且它们经常一起使用。这些公共列构成聚集码。
经常被同时访问的表在物理位置上可以存储在一起。为了将它们存储在一起，就要创建一个簇( c l u s t e r )来管理这些表。表中的数据一起存储在簇中，从而最小化必须执行的I ......
SQL> SQLPLUS / AS SYSDBA
SQL> exec dbms_workload_repository.create_snapshot
SQL> exec:snap_id:=dbms_workload_repository.create_snapshot
SQL> var snap_id number
SQL> print snap_id
SQL> @?/rdbms/admin/awrrpt.sql
OracleAWR速查
1.查看当前的AWR保存策略
select * fro ......
今天安装软件一直在测试链接不能通过，出现ORA-12154: TNS: could not resolve service name，后来才发现是tnsnames.ora中有误。查找网上的资料，记录下来。
要排除客户端与服务器端的连接问题，首先检查客户端配置是否正确(客户端配置必须与数据库服务器端监听配置一致)，再根据错误提示解决。下面列出几种常见的连接问题 ......
alter system set nls_length_semantics='BYTE' scope=both
sql>show parameter length
NAME TYPE
------------------------------------ --------------------- ......
