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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Before insert and after insert trigger
Next Topic: sql*plus spooling error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:16:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.