Thinking Out Loud

September 19, 2012

SQL*Plus Timing Start

Filed under: Uncategorized — mdinh @ 1:49 pm

I just learned about this feature.

Example using SQL*Plus 11.2

12:56:58 MDINH@db01:PRIMARY> timing start test1
12:57:07 MDINH@db01:PRIMARY>
12:57:21 MDINH@db01:PRIMARY> timing start test2
12:57:23 MDINH@db01:PRIMARY>
12:57:36 MDINH@db01:PRIMARY> timing stop test2
timing for: test2
Elapsed: 00:00:16.33
12:57:40 MDINH@db01:PRIMARY> timing stop test1
timing for: test1
Elapsed: 00:00:48.96
12:57:56 MDINH@db01:PRIMARY>

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog at

%d bloggers like this: