Discussion :

[sapars]

bonjour à tous et à toutes
je cherche la description de de ces colonnes PARENT_NAME WHERE_IN_CODE NWFAIL_COUNT SLEEP_COUNT WTR_SLP_COUNT de la table STATS$LATCH_MISSES_SUMMARY
merci d'avance

[orafrance]

j'ai du mal à comprendre l'intérêt de récupérer ces infos directement alors qu'elle sont juste sensé être utilisée par statspack

M'enfin, si ça peut vous aider, dans statpack on trouve ceci :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
insert into stats$latch_misses_summary
          ( snap_id
          , dbid
          , instance_number
          , parent_name
          , where_in_code
          , nwfail_count
          , sleep_count
          , wtr_slp_count
          )
     select l_snap_id
          , p_dbid
          , p_instance_number
          , parent_name
          , "WHERE"
          , sum(nwfail_count)
          , sum(sleep_count)
          , sum(wtr_slp_count)
       from v$latch_misses
      where sleep_count > 0
      group by l_snap_id, p_dbid, p_instance_number
          , parent_name, "WHERE";

et la doc : http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch387.htm#1116513

[orafrance]

Le support Oracle est un peu plus précis :

Column
WHERE Comment as to WHERE in the code this row relates to
for this latch.
NWFAIL_COUNT Number of Nowait latch misses occurring while the
latch is HELD at this WHERE location.
SLEEP_COUNT The number of SLEEPS caused by someone HOLDING the
latch from this location.

(Columns below only exist in Oracle8 onwards)

WTR_SLP_COUNT The number of SLEEPS from waiters trying to get the
latch at this location in the code. (The holder could
be holding the latch from some other code point).

LONGHOLD_COUNT If a waiter sleeps then after the sleep finds the same
session to be the holder for the whole time he slept
then this figure is incremented for the HOLDERS "WHERE"
location.

(Columns below only exist in Oracle9 onwards)

LOCATION Comment as to WHERE in the code this row relates to
for this latch.

Known Issues:
This view is awkward prior to Oracle9i as the "WHERE" column has to
be quoted in SQL statements to avoid parse errors. As of Oracle9i
the column "LOCATION" has been added which can be used in place of
"WHERE".

[sapars]

Merci chef