Hi, On Mon, Feb 21, 2011 at 11:17 AM, narendra babu <[email protected]>wrote:
> is there anyway other time command to get the time taken by each process > to complete . > Each of your insert statements "sqlplus -s user1/pwdsafe" runs as separate processes by themselves. So when you use the 'time' command, it calculates the time taken for that process to complete. Isn't it so? i would like to know how can i get the total cpu time taken to execute all > the statements . > Use the time command for your entire shell script then! (Assuming your shell script executes only these SQL commands). If not, then a naive workaround would be to put these insert commands inside a separate script and run the time command for that script from your original script. I don't know if time command provides a mechanism to find the time of a set of commands, check it out :-) -- Thanks and Regards, Hrishikesh Murali _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
