timers in sqlplus

April 25, 2014 — Leave a comment

this is one of: after all these years I really didn’t know this

nested timers in sqlplus:

SYS@orcl> timing start a1
SYS@orcl> timing start   a2
SYS@orcl> timing start     a3
SYS@orcl> timing show
timing for: a3
Elapsed: 00:00:03.39
SYS@orcl> timing stop
timing for: a3
Elapsed: 00:00:07.37
SYS@orcl> timing show
timing for: a2
Elapsed: 00:00:16.55
SYS@orcl> timing stop
timing for: a2
Elapsed: 00:00:20.53
SYS@orcl> timing show
timing for: a1
Elapsed: 00:00:33.45
SYS@orcl> timing stop
timing for: a1
Elapsed: 00:00:36.44

good to know for complex scripts …

Advertisements

No Comments

Be the first to start the conversation!

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