Re: SQL tuning questions

Two possibilities. One is to get the start time saved into a variable such as:

vStartTime := SYSDATE;

then do the same thing when the procedure ends. If you are running ad hoc queries just wrap them into an anonymous block.

You can also use dbms_utility.get_time for 1/100 of a second accuracy.

Daniel Morgan

tshen wrote:

> hi, guys:
>
> Q 1: why some time oracle won't use the hint which I give?
> Q 2: since I found the "set timing on" cann't tell the exact the time
> the oracle
> execute the query, so how can I tell the exact time of execution
> of the query?
> Q3: I have no problem with each single simple tuning sample SQL, but
> in real life,
> the SQL became very complicate and huge, so is there any steps
> or spots that I
> must look or deal first, and then second....... ? please give
> some suggestion of
> the real life SQL tuning. thanks
>
> tshen
Received on Thu Feb 07 2002 - 14:05:04 CST