Performance - EBS (MOSC)

MOSC Banner

object_name for p1,p2 from ash report.

edited Nov 18, 2009 3:58AM in Performance - EBS (MOSC) 2 commentsAnswered
How to find the object_name,object_type for this values in ASH report.

eg:-


select
  segment_name,
  segment_type
from
   dba_extents
where
   file_id = 5228121616
and
   122 between 
   block_id and block_id + blocks – 1;

This gives me no rows selected. How can i come to know what object is causing 21% latch:cache buffer chains in my database.

Pls advice.
 

Top Event P1/P2/P3 Values

    Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3 latch free24.95"1610761560","264","0"24.32addressnumbertries latch: cache buffers chains20.82"5228121616","122","0"12.02addressnumbertries   "5231665816","122","0"2.15      "5232622016","122","0"1.34    latch: shared pool5.92"1611558928","213","0"2.91addressnumbertries   "1611559088","213","0"2.86    latch: row cache objects3.65"5101607408","199","0"3.47addressnumbertries latch: library cache1.63"5090743936","214","0"0.80addressnumbertries

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center