Database Tuning (MOSC)

MOSC Banner

Question about i/o

edited Sep 22, 2010 4:17AM in Database Tuning (MOSC) 2 commentsAnswered
 Hi All

we are on Oracle 10g on Red Hat Linux x86_64.. a 2-node RAC

I want to create a report which is something like what one gets from v$event_histogram for wait event db file sequential read but instead of the buckets that are preset I want the buckets to be aceh one ms. In other words I want to know hw many reads were < 1ms, how many were between 1ms and 2ms , etc.

I think this can also be achieved if there were a way to time each block read during a session (something like what you see in a 10046 level 8  trace file)

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