| SQLPlus Enviornment Setting [message #170161] |
Tue, 02 May 2006 07:32  |
sauami
Messages: 54
Registered: October 2005
Location: india
|
Member |
|
|
Dear Sir,
What setting i have to use to enable showing total time for a query or subprogramm after completing the task
for enable feedback i have use (set feedback on)
for example:
total time 00:00:20 -- what to do enable this format for every query--
10 rows updated
Thanks,
Saurabh
|
|
|
|
|
|
| Re: SQLPlus Enviornment Setting [message #170176 is a reply to message #170161] |
Tue, 02 May 2006 08:09  |
bsmith18
Messages: 8
Registered: April 2006
|
Junior Member |
|
|
set timing on at the beginning of your sql script. I typically set an environment variable that is passed into the sql script to turn on or off the timing. Example, in unix or linux:
time_env=on; export time_env
sqlplus user/password@db sqlscript.sql $time_env
In the sql script,
set timing=&1
This way if you ever need to turn it off you just have to reset the environment variable before the sql script is executed. Much greater flexibility if ever needed. Not sure of the OS your running on but you can translate to a different OS if needed very easily. Hope this helps.
Brad Smith
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
