Sponsored Content
Operating Systems Solaris Need to know IO usage in Solaris Post 302841015 by reignangel2003 on Tuesday 6th of August 2013 10:55:39 PM
Old 08-06-2013
I am running the same stored procedure multiple times, but i am getting different output when it comes to time completion. Below are the different elapse time:

Code:
FIRST RUN
TRD extract finished, time elapsed: 239 minutes

Code:
SECOND RUN
TRD extract finished, time elapsed: 4 minutes

Code:
SUCCEEDING RUN
2013-08-04 20:58:39.053	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 4 minutes
2013-08-02 03:27:00.233	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 65 minutes
2013-08-02 02:06:52.77	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 44 minutes
2013-08-01 23:36:43.293	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 62 minutes
2013-08-01 05:00:22.307	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 62 minutes
2013-08-01 02:44:22.15	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 48 minutes
2013-08-01 01:50:31.75	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 35 minutes

is there a way for me to trace the io usage for this particular process that i am using?
 

10 More Discussions You Might Find Interesting

1. Solaris

Process CPU usage in Solaris 10

Hi All, Please let me know the command (expect top) to view the cpu usage of every process in Solaris 10. Thanks in Advance, Arun (1 Reply)
Discussion started by: arun.viswanath
1 Replies

2. Solaris

Solaris Disk Usage

Disk Usage : I need a script which can help me in Following ways: 1) Input the Path where you want to find Usage Stats Suppose I enter /var/tmp 2) It Should list the partition in which its mounted, Percentage Used and Available and Users who are using the Maximum Space(in MB) with the... (1 Reply)
Discussion started by: sriram003
1 Replies

3. Solaris

pstack usage on Solaris 9

Hello everyone, I have a 12-thread application running on Solaris 9. When I use the pstack command after a typical core dump, it prints the stack output of all 12 threads/lwps. This is the standard procedure as it is described in the Solaris MAN pages. Is there a way to filter out the... (1 Reply)
Discussion started by: gregb32
1 Replies

4. HP-UX

how can I find cpu usage memory usage swap usage and logical volume usage

how can I find cpu usage memory usage swap usage and I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times my final destination is monitor process logical volume usage above X % and number of Logical voluage above can I not to... (3 Replies)
Discussion started by: alert0919
3 Replies

5. AIX

How to monitor the IBM AIX server for I/O usage,memory usage,CPU usage,network..?

How to monitor the IBM AIX server for I/O usage, memory usage, CPU usage, network usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies

6. Solaris

Oracle memory usage on Solaris box

I am working on Oracle 2 node RAC 10.2.0.4 on Solaris 10 T2000 kit. The box has around 32G of memory of which 24G is used by oracle user. There is 3G of free memory on the box. Sga max is set to 5G and while checking v$pgastat i see that maximum pga memory memory allocated was 6.5G. So oracle... (29 Replies)
Discussion started by: prabumohan
29 Replies

7. Solaris

Memory usage in a Solaris Container

Hi All, We have a server with Solaris 10 installed. The total memory of the server is 64GB. In order to check the memory info of the server I use "top" utility that gives me total and free memory in real-time. I have also installed a Sun container (non-global zone) on top of parent operating... (4 Replies)
Discussion started by: Slayer
4 Replies

8. Solaris

Solaris Memory usage by oracle, java

Hello Gurus, In Office, I have unix Solaris Server. Oracle and Java is installed on Solaris Server. Oracle when starts then oracle loads SGA, PGA memory and graps solaris server memory. In the same manner java and other applications grabs memory for them. I want memory distribution of... (4 Replies)
Discussion started by: get_chandrakant
4 Replies

9. Solaris

Solaris memory usage

One of my Solaris Unix server has total RAM 128G . top & vmstat command shows free memory is 86G and usage is 42G. ps -eo pid,rss,commshows memory usage by process. when i sum all the memory usage by the process, it shows 1.9TB as shown below. $ ps -eo pid,pmem,vsz,rss,comm | sort -rnk2 |... (5 Replies)
Discussion started by: baladelaware73
5 Replies

10. Solaris

How to find out the memory usage in Solaris?

Hi All, In one of the solaris box aslert got triggered as ... (Used_Real_Mem_Pct=93.0 Used_Swap_Space_Pct=75.0 )] when i see the usage by vmstat and sar i am not able to relate the alert with the free memory and swap memory please help to understand the vmstat output as below.. kthr ... (4 Replies)
Discussion started by: Riverstone
4 Replies
time(1) 						      General Commands Manual							   time(1)

Name
       time - time a command

Syntax
       time command
       /bin/time command

Description
       The  command  lets  the specified command execute and then outputs the amount of elapsed real time, the time spent in the operating system,
       and the time spent in execution of the command.	Times are reported in seconds and are written to standard error.

       If you are using any shell except the C shell, you can give the command as shown on the first line of the Syntax section.  If you are using
       the  C shell, you must use the command's full pathname as shown on the second line of the Syntax section.  If you do not use the full path-
       name, will execute its own built-in command that supplies additional information and uses a different output format.

       The command can be used to cause a command to be timed no matter how much CPU time it takes.  For example:
       % /bin/time cp /etc/rc /usr/bill/rc
	       0.1 real 	0.0 user	 0.0 sys
       % /bin/time nroff sample1 > sample1.nroff
	       3.6 real 	2.4 user	 1.2 sys
       This example indicates that the command used negligible amounts of user and system time and had an elapsed time of 1/10 second (0.1).   The
       command used 2.4 seconds of user time and 1.2 seconds of system time, and required 3.6 seconds of elapsed time.

Restrictions
       Times are measured to an accuracy of 1/10 second.  Thus, the sum of the user and system times can be larger than the elapsed time.

See Also
       csh(1)

																	   time(1)
All times are GMT -4. The time now is 07:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy