| How to estimate query response time and number of rows without executing query [message #339224] |
Thu, 07 August 2008 02:08  |
gkodakalla
Messages: 49
Registered: March 2005
|
Member |
|
|
Hi,
I would like to know if it is possible to get the execution time of a query without actually executing it.
We are on Oracle 10.2.0.3 enterprised edition running on sun solaris.
Assume i have a query "SELECT * FROM CUSTOMER_MASTER"
Before i even execute this query, i need some mechanism (other than explain plan) which i can programatically plugin in the source code so that any query taking more than 300 seconds would not be executed at all. I would also like to know the number of expected rows from this query.
I am okay to have 20% deviation from expected to the actual execution time and rows.
Can you please help me to get this information.
Thanks in advance.
Giridhar
|
|
|
|
|
|
| Re: How to estimate query response time and number of rows without executing query [message #339236 is a reply to message #339231] |
Thu, 07 August 2008 02:19  |
gkodakalla
Messages: 49
Registered: March 2005
|
Member |
|
|
Thanks Michael for your quick response.
I want to restrict users to give queries which takes more than 5 minutes and also > X number of rows. I want to alert them to re define their queries to be more selective than returning all rows from those tables. I was reading another article where they mentioned that some quest product has this feature where it estimates the rows or response time. May be they also would use "explain plan"?. I am looking at something which is reliable and also which i can plug into our program.
Thanks again
Giridhar
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
