Hi All,
I am using Release 11.2.0.3.0 version of oracle. i want to find out wait trends in last one month or so. so what will be the query or datadictionary which will give those details.
-- In first step i need to plot wait times group by wait_class(('User I/O','System I/O', 'Concurrency', 'Commit', 'Other', 'Configuration', 'Network', 'Application'.. etc) for last one month or so.
-- In second step i want plot the waits group by each event(enq: TX - row lock contention, read by other session, db file scattered read , SQL*Net break/reset to client .... etc) within that class, for last one month or so.
-- Then want to plot the specific enques(enq: TM - contention, enq: UL - contention, enq: TX - row lock contention, wait for table lock, ... etc) for above period.