|
-
In sql*plus you can execute a "set timing on" to display the time taken for a DML/DDL. To record the result I would add a spool command at the beging of your sql script.
So to record down the time for each table creation I would add at the begingin of your scripts the following 2 lines:
spool $ORACLE_HOME/.../crttab1.log
set timing on
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|