Database counters need to monitor

[Jaipal Reddy]

Jay, Karunya, Raj, Venkat and Srikanth,

Please see below database related counters: copy and paste from office work :-)

Buffer cache Hit Ratio : This value should be high about 90-95 range; else data cache size is too low and might lead to too much physical IO.

Deadlocks : This value should be zero for the target load, else it refers to design problem.

Table Scan blocks per sec : This Value should be low for normal transactions (can be high for reporting functions); else it indicates poor or missing indexes.

Parse to Execute Ratio : This value should be low (<20%) else it could indicate under-sized query cache or flawed query model.

Open Cursors : This value should be low else it indicates the inefficient query model.

SQL *Net bytes recd/sent from/to client : This value indicates the data-intensiveness of

queries. A high value indicates high amount of network roundtrip calls between the client

to/from the db server. The read bytes should be <50% of sent bytes, else it indicates complex application queries should become stored procedures

Thanks,

Jaipal