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>

About these ads

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

The Rubric Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 314 other followers

%d bloggers like this: