Re: Data Access
Date: 1998/04/02
Message-ID: <6g1i35$j64$1_at_winter.news.erols.com>#1/1
Chen Wei Kian,
There is a new Oracle database browser program called SQL*Pro that just
came
on the market. One of the features is a that every SQL Window has a small
portion of the
status bar dedicated to query statistics, such as start time, end time.
Also, as the query is
running, you will see an update of how long the query has been running,
every 5 seconds.
Alternatively, since SQL*Pro is multi-threaded, you could open up 2 SQL
Windows, and put
one query in one window, the other query in the other window, and start them
at virtually the
same time.
SQL*Pro can be downloaded from
http://www.erols.com/erikbengtson/
It is shareware.
Chen Wei Kian wrote in message <3523B7E0.41C67EA6_at_usl.edu>...
>Does anyone know if it is possible to check whcih block of data does
>a given query accessed to get the result ? What I am trying to do is
>to count how many block of data has to be accessed for a given query
>to obtain the result. The purpose of doing so is to compare the time
>required for 2 queries to obtain the result. Do you know if there is
>any other alternative way that allow me to so ?
>Wei Kian Chen
Received on Thu Apr 02 1998 - 00:00:00 CEST