Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to find Physical Read Time/Page with API?

Status
Not open for further replies.
P31

P31

Programmer
Feb 27, 2006
2
CA
Hi all,

I'm trying to find the Physical Read Time per Page by using the API. What I tried to do was (pool_data_p_reads + pool_index_p_reads)/pool_read_time. I'm getting zeros for pool_data_p_reads & pool_index_p_reads. However, pool_read_time is non-zero. Does that make sense? Does my formula make sense?

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
215
tekpr00
tekpr00
MichaelDe
  • Locked
  • Question
SQL Update with File Join
Replies
10
Views
729
MichaelDe
MichaelDe
gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
249
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
272
ANGELDANY
ANGELDANY
Pauljohn44
  • Locked
  • Question
Pivot data with two key fields
Replies
0
Views
111
Pauljohn44
Pauljohn44

Part and Inventory Search

Sponsor

Back
Top