how do we check i/o for a specific database partition ?

blazer789 · #1 (**permalink**) 02-08-12, 05:53

Is there a way we can check i/o for a specific database partition ?

Ours is linux environment with 17 logical partitions spanned across 3 physical nodes. I need to know which logical partition is having more i/o

sathyaram_s · #2 (**permalink**) 02-08-12, 06:37

Quote:

Originally Posted by blazer789

Is there a way we can check i/o for a specific database partition ?

Ours is linux environment with 17 logical partitions spanned across 3 physical nodes. I need to know which logical partition is having more i/o

Take database snapshots and check for bufferpool physical reads & writes and direct reads & writes.

HTH

Sathyaram

blazer789 · #3 (**permalink**) 02-08-12, 13:13

Thanks Satya

Internet Services

Web Development

Digital Marketing

Consumer Tech