Home » RDBMS Server » Server Administration » optimizer in oracle
optimizer in oracle [message #373697] Wed, 02 May 2001 05:52 Go to next message
Astha
Messages: 3
Registered: May 2001
Junior Member
How to know how much time my query is taking to parese and execute . I have made set autotrace on and getting all the statistics
Re: optimizer in oracle [message #373707 is a reply to message #373697] Wed, 02 May 2001 08:22 Go to previous message
Hari
Messages: 59
Registered: August 2000
Member
if you are just running query in sql*plus
use set timer on and set timer off
Previous Topic: Before insert and after insert trigger
Next Topic: sql*plus spooling error
Goto Forum:
  


Current Time: Mon Dec 23 09:29:47 CST 2024