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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number of Queries per day

Status
Not open for further replies.

Sambo8

Programmer
May 10, 2005
78
0
0
NZ
Hi All,

Is there a way of finding out the number of sql queries run against a 9i database in a day?

Many thanks,
Sam
 
Yes, you can use Oracle's AUDIT capability/functionality, but it can tell you only how many times someone invoked the SELECT verb. It means that a SELECT that returns 10 million rows has the same weight as a SELECT that returns a single row.

Under such circumstances, how could such statistics be useful?

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top