什么是"CSS操作:数据查询“等待事件在甲骨文StatsPack报告？

Question

有没有人见过CSS operation: data query甲骨文等待事件，知道它意味着什么？11.2.0.1中有一个bug 8299200，而11.2.0.3中有一个错误。

STATSPACK report for

Database    DB Id    Instance     Inst Num  Startup Time   Release     RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
          3816595344 SCRATCHEDOUT        1 04-Aug-15 14:16 11.2.0.3.0  YES

Host                             Name             Platform                CPUs
Cores Sockets   Memory (G)
~~~~ ---------------- ---------------------- ----- ----- ------- ------------
     scratchedout     Solaris[tm] OE (64-bit    48    24       6        192.0

Snapshot       Snap Id     Snap Time      Sessions Curs/Sess Comment
~~~~~~~~    ---------- ------------------ -------- --------- ------------------
Begin Snap:        237 10-Aug-15 09:00:01       42       1.1
  End Snap:        239 10-Aug-15 09:53:54       43       1.0
   Elapsed:      53.88 (mins) Av Act Sess:       0.1
   DB time:       5.45 (mins)      DB CPU:       2.46 (mins)

Cache Sizes            Begin        End
~~~~~~~~~~~       ---------- ----------
    Buffer Cache:     5,792M     5,696M   Std Block Size:         8K
     Shared Pool:     1,168M     1,264M       Log Buffer:    11,592K

Load Profile              Per Second    Per Transaction    Per Exec    Per Call
~~~~~~~~~~~~      ------------------  ----------------- ----------- -----------
      DB time(s):                0.1                0.1        0.00        0.03
       DB CPU(s):                0.1                0.0        0.00        0.01
       Redo size:          354,689.1          341,689.5
   Logical reads:            1,333.7            1,284.8
   Block changes:              158.3              152.5
  Physical reads:               33.7               32.5
 Physical writes:               46.4               44.7
      User calls:                3.6                3.5
          Parses:               13.5               13.0
     Hard parses:                2.0                1.9
W/A MB processed:                0.8                0.7
          Logons:                0.5                0.5
        Executes:               46.3               44.6
       Rollbacks:                0.0                0.0
    Transactions:                1.0

Instance Efficiency Indicators
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:   99.97       Redo NoWait %:   99.99
            Buffer  Hit   %:   98.37  Optimal W/A Exec %:   99.96
            Library Hit   %:   93.86        Soft Parse %:   85.14
         Execute to Parse %:   70.93         Latch Hit %:   99.78
Parse CPU to Parse Elapsd %:   37.01     % Non-Parse CPU:   96.21

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   84.22   41.85
    % SQL with executions>1:   50.76   68.25
  % Memory for SQL w/exec>1:   75.54   68.25

Top 5 Timed Events                                                    Avg %Total
~~~~~~~~~~~~~~~~~~                                                   wait   Call
Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
CPU time                                                       597          40.9
CSS operation: data query                        1,820         337    185   23.1
DFS lock handle                                 32,161          52      2    3.6
log file parallel write                         16,038          51      3    3.5
CSS initialization                                  21          30   1428    2.1
          -------------------------------------------------------------
...

Answer 1

您提供的说明是关于关机的问题: Bug 8299200 -关机立即挂起(Doc 8299200.8)。你想推荐的是正确的医生吗？

你最近升级到11.2.0.3了吗？

如果是这样的话，这个MOSC注释可能会有所帮助，它引用了一个导致集群件同步服务操作非常缓慢的bug，导致与css相关的等待事件：

医生ID 1444483.1