Sponsored Content
Operating Systems AIX estimating memory usage by database processes Post 302237114 by hariza on Wednesday 17th of September 2008 02:28:11 AM
Old 09-17-2008
estimating memory usage by database processes

Hi Guys,

I wonder what would be the best way to determine how much memory is in use on any given time by the database processes. I thought about using ipcs -m command but I wonder if there any better way to determine this. Thanks.

Harby.
 

10 More Discussions You Might Find Interesting

1. Programming

Monitor CPU usage and Memory Usage

how can i monitor usages of CPU, Memory, Hard disk etc. under SUN Solaries through a c program or java program i want to store that data into database so i can show it graphically thanks in advance (2 Replies)
Discussion started by: Gajanad Bihani
2 Replies

2. HP-UX

How can I get memory usage or anything that show memory used from sar file?

Refer from title: How can i get memory used or anything that can show memory from sar file example on solaris:- we can use sar with option to show memory used at time that sar crontab run. on HP-UX, it not has option to see memory used. But i think it may be have some parameter or some... (1 Reply)
Discussion started by: panithat
1 Replies

3. 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

4. Solaris

current CPU usage, memory usage, disk I/O oid(snmp)

Hi, I want to monitor the current cpu usage, monitor usage , disk I/o and network utlization for solaris using SNMP. I want the oids for above tasks. can you please tell me that Thank you (2 Replies)
Discussion started by: S_venkatesh
2 Replies

5. Solaris

Memory usage in Solaris - memory not freed?

Hi, I'm running a multi-process software system on a Solaris 8 machine. When I monitor the memory usage, I see that the free memory is dropping rapidly, but I can't detect a process that uses this memory. I'm using "top" to get the free memory and the memory usage of processes. Thanks. (3 Replies)
Discussion started by: gewurtz
3 Replies

6. 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

7. UNIX for Dummies Questions & Answers

Command to display the space usage (memory usage) of a specific directory.

Hi all, Can you please tell me the command, with which one can know the amount of space a specific directory has used. df -k . ---> Displays, the amount of space allocated, and used for a directory. du -k <dir name> - gives me the memory used of all the files inside <dir> But i... (2 Replies)
Discussion started by: abhisheksunkari
2 Replies

8. AIX

Identify All Processes memory and cpu usage.

Hi All, Anyone has script to monitor AIX total processes memory and cpu usage that contribute to the total memory and CPU utilize so far ? The purpose of this is to analyze process memory trend. Thanks. Best Regards, ckwan (2 Replies)
Discussion started by: ckwan
2 Replies

9. UNIX for Dummies Questions & Answers

Memory usage per user,percent usage,sytem time in ksh

Let's say i have 20 users logged on Server. How can I know how much memory percent used each of them is using with system time in each user? (2 Replies)
Discussion started by: roy1912
2 Replies

10. AIX

AIX memory usage by processes

Hi, i have 2 identical web servers using AIX. I use nmon analyser to check their performance. The server A exceeds 20% memory usage for system, 5% for cache and the rest 75% for processes. While, it uses 4% of Paging Space. The server B exceeds 20% for system, 45% for cache and 35% for processes.... (24 Replies)
Discussion started by: dim
24 Replies
ipcs(1) 						      General Commands Manual							   ipcs(1)

Name
       ipcs - report interprocess communication facilities status

Syntax
       ipcs [options]

Description
       The  command  provides  information about active, interprocess communication facilities, message queues, shared memory, and semaphores that
       are currently active in the system.

Options
       The information is displayed in columns and is controlled by the following options:

       -m     Displays information about active shared memory segments

       -q     Displays information about active message queues

       -s     Displays information about active semaphores

       If any of the options -q, -m, or -s are specified, information about only those indicated are printed.  If none of these  three	is  speci-
       fied, information about all three are printed.

       -a     Uses all print options (shorthand notation for -b, -c, -o, -p and -t)

       -b     Displays	the  biggest allowable size information (maximum number of bytes in messages on queue for message queues, size of segments
	      for shared memory, and number of semaphores in each set for semaphores)

       -C     Uses the specified core file (next argument) in place of

       -c     Displays creator's login name and group name

       -N     Uses the specified namelist (next argument) in place of

       -o     Displays the outstanding usage information  (number of messages in queue, size of each and number of processes  attached	to  shared
	      memory segments)

       -p     Displays	the  process ID information (process ID of last process to send a message and process ID of last process to receive a mes-
	      sage on message queues and process ID of creating process and process ID of last process to attach or detach on shared  memory  seg-
	      ments)

       -t     Displays	all  time  statistics  (time of the last control operation that changed the access permissions for all facilities, time of
	      last and last on message queues, last and last on shared memory, last on semaphores)

       The column headings and the meaning of the columns in an listing are given below.  The letters in parentheses  indicate	the  options  that
       cause the corresponding heading to appear; all means that the heading always appears.  Note that these options only determine what informa-
       tion is provided for each facility; they do not determine which facilities are listed.

       T (all)		   Type of facility:

			   q	  Message queue

			   m	  Shared memory segment

			   s	  Semaphore

       ID (all) 	   The identifier for the facility entry.

       KEY (all)	   The key used as an argument to or to create the facility entry.  Note:  The key of a shared memory segment  is  changed
			   to IPC_PRIVATE when the segment has been removed until all processes attached to the segment detach it.

       MODE (all)	   The facility access modes and flags.
			   The mode consists of 11 characters.	The first two characters are interpreted as follows:

			   R	  If the process is waiting on a

			   S	  If a process is waiting on a

			   D	  If  the  associated shared memory segment has been removed.  It disappears when the last process attached to the
				  segment detaches it.

			   C	  If the associated shared memory segment is to be clear when the first attach is executed.

			   -	  If the corresponding special flag is not set.

			   The next 9 characters are interpreted as three sets of three bits each.  The first set refers to  the  owner's  permis-
			   sions;  the next, to permissions of others in the user-group of the facility entry; and the last to all others.  Within
			   each set, the first character indicates permission to write or alter the facility entry, and the last character is cur-
			   rently unused.
			   The permissions are indicated as follows:

			   r	  If read permission is granted

			   w	  If write permission is granted

			   a	  If alter permission is granted

			   -	  If the indicated permission is not granted

       OWNER (all)	   The login name of the owner of the facility entry.

       GROUP (all)	   The group name of the group of the owner of the facility entry.

       CREATOR (a,c)	   The login name of the creator of the facility entry.

       CGROUP (a,c)	   The group name of the group of the creator of the facility entry.

       CBYTES (a,o)	   The number of bytes in messages currently outstanding on the associated message queue.

       QNUM (a,o)	   The number of messages currently outstanding on the associated message queue.

       QBYTES (a,b)	   The maximum number of bytes allowed in messages outstanding on the associated message queue.

       LSPID (a,p)	   The process ID of the last process to send a message to the associated queue.

       LRPID (a,p)	   The process ID of the last process to receive a message from the associated queue.

       STIME (a,t)	   The time the last message was sent to the associated queue.

       RTIME (a,t)	   The time the last message was received from the associated queue.

       CTIME (a,t)	   The time the associated entry was created or changed.

       NATTCH (a,o)	   The number of processes attached to the associated shared memory segment.

       SEGSZ (a,b)	   The size of the associated shared memory segment.

       CPID (a,p)	   The process ID of the creator of the shared memory entry.

       LPID (a,p)	   The process ID of the last process to attach or detach the shared memory segment.

       ATIME (a,t)	   The time the last attach was completed to the associated shared memory segment.

       DTIME (a,t)	   The time the last detach was completed on the associated shared memory segment.

       NSEMS (a,b)	   The number of semaphores in the set associated with the semaphore entry.

       OTIME (a,t)	   The time the last semaphore operation was completed on the set associated with the semaphore entry.

Restrictions
       Things can change while is running.  The picture it gives is only a close approximation to reality.

Files
       /vmunix	 system namelist
       /dev/kmem memory
       /etc/passwd    user names
       /etc/group     group names

See Also
       ipcrm(2), msgop(2), semop(2), shmop(2)

																	   ipcs(1)
All times are GMT -4. The time now is 02:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy