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
MICROUPTIME(9)						   BSD Kernel Developer's Manual					    MICROUPTIME(9)

NAME
binuptime, getbinuptime, microuptime, getmicrouptime, nanouptime, getnanouptime, sbinuptime, getsbinuptime -- get the time elapsed since boot SYNOPSIS
#include <sys/time.h> void binuptime(struct bintime *bt); void getbinuptime(struct bintime *bt); void microuptime(struct timeval *tv); void getmicrouptime(struct timeval *tv); void nanouptime(struct timespec *ts); void getnanouptime(struct timespec *tsp); sbintime_t sbinuptime(void); sbintime_t getsbinuptime(void); DESCRIPTION
The binuptime() and getbinuptime() functions store the time elapsed since boot as a struct bintime at the address specified by bt. The microuptime() and getmicrouptime() functions perform the same utility, but record the elapsed time as a struct timeval instead. Similarly the nanouptime() and getnanouptime() functions store the elapsed time as a struct timespec. The sbinuptime() and getsbinuptime() functions return the time elapsed since boot as a sbintime_t. The binuptime(), microuptime(), nanouptime(), and sbinuptime() functions always query the timecounter to return the current time as precisely as possible. Whereas getbinuptime(), getmicrouptime(), getnanouptime(), and getsbinuptime() functions are abstractions which return a less precise, but faster to obtain, time. The intent of the getbinuptime(), getmicrouptime(), getnanouptime(), and getsbinuptime() functions is to enforce the user's preference for timer accuracy versus execution time. SEE ALSO
bintime(9), getbintime(9), getmicrotime(9), getnanotime(9), microtime(9), nanotime(9), tvtohz(9) AUTHORS
This manual page was written by Kelly Yancey <kbyanc@posi.net>. BSD
July 25, 2013 BSD
All times are GMT -4. The time now is 10:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy