| Estimated Time for Query In Discoverer [message #90067] |
Thu, 21 October 2004 06:09  |
Mohan K.
Messages: 12
Registered: October 2004
|
Junior Member |
|
|
Hi Discoverer Guru's,
we are using 9i Discoverer Admin/User, one of our user want to display Estimated Time for Query before it start. How do I set that in Options or any where else. Please some body help me.
Thanks in advance
Mohan
|
|
|
|
| Re: Estimated Time for Query In Discoverer [message #90076 is a reply to message #90067] |
Fri, 22 October 2004 12:31  |
PP- Mahaguru
Messages: 3
Registered: October 2004
|
Junior Member |
|
|
Dear you need to check following things:
1. timed_statistics parameter in v$parameter table
It should be set to TRUE
2. your database is running in which mode- RULE or CHOOSE(COST).
3. Analyze the tables
4. In Disc Admin set the collect query statistics to TRUE for that user
And at last Have lots of fun...:0)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
