通过案例学调优之--动态视图（v$bh和x$bh)v$bh与x$bhv$bh:非常详细地记录了数据块在数据缓冲区内的使用情况，一条记录对应一个block的详细记录。v$bh来自于基表x
13:07:20 sys@ test1 >desc v$bh name                                                              null?    type ----------------------------------------------------------------- -------- -------------------------------------------- file#                                                                      number block#                                                                     number class#                                                                     number status                                                                     varchar2(10) xnc                                                                        number forced_reads                                                               number forced_writes                                                              number lock_element_addr                                                          raw(4) lock_element_name                                                          number lock_element_class                                                         number dirty                                                                      varchar2(1) temp                                                                       varchar2(1) ping                                                                       varchar2(1) stale                                                                      varchar2(1) direct                                                                     varchar2(1) new                                                                        char(1) objd                                                                       number ts#                                                                        number lobid                                                                      number cachehint                                                                  number