Database Administration (MOSC)

MOSC Banner

what is the meaing for "mostly latch-free SCN"

edited Mar 10, 2017 4:00AM in Database Administration (MOSC) 9 commentsAnswered

I see "latch free" in my database, the P2 is 166.

What is the meaing for "mostly latch-free SCN" ?

How to reduce this event ?

SQL> select * from v$latchname where latch#=166;

    LATCH# NAME                                                                   HASH

---------- ---------------------------------------------------------------- ----------

       166 mostly latch-free SCN                                            1282175915

SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center