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!

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

Calculating Buffer Busy Waits

Status
Not open for further replies.

attick111

Programmer
Nov 28, 2001
21
0
0
US
Could anyone out there please tell me the most accurate way to calculate Buffer Busy Waits in Oracle 9i or 10g?

Thanks
Attick111
 
attick,

I only know of one method, i.e. using statspack at level 7 or greater.

Inspecting v$waitstat should also prove useful.

If there are any other methods, they're way beyond me, and I therefore couldn't say which is the most accurate.

Sorry for a somewhat less than stunning response.

Regards

Tharg

Grinding away at things Oracular
 
At least you offered an answer (unlike the rest of us).[2thumbsup]

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top