Home » RDBMS Server » Server Administration » Monitor time for statement to execute
Monitor time for statement to execute [message #53924] Thu, 17 October 2002 16:49 Go to next message
Steve
Messages: 190
Registered: September 1999
Senior Member
I have a procedure that issues an ALTER INDEX ... REBUILD statement. How can I determine the total time it takes for this statement to complete? I'm trying to compare the time it takes to rebuild an index with logging and without logging.

Thanks.

Report message to a moderator

Re: Monitor time for statement to execute [message #53925 is a reply to message #53924] Thu, 17 October 2002 20:00 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
There are two ways of doing that:

set timing on

set autotrace on

See the full set of steps to do that Here

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: forms 5 compatible with oracle client 8 !?
Next Topic: What s the mistake ? ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:43:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.