Sponsored Content
Operating Systems AIX migrating solaris DB servers to AIX - resources ? Post 302367858 by Padow on Tuesday 3rd of November 2009 04:26:40 PM
Old 11-03-2009
I'm in the midst of a similar project. I used the following script to determine shared memory usage on Solaris hosts for Sybase and Oracle. I ran this several times a day on each host, though the numbers really didn't change much. I found this to be much better than utilizing what the DB was configured to use, as this will show what the DB actually utilizes.

Code:
if ipcs -ma | grep sybase > /dev/null ; then
  echo Sybase
  ipcs -ma  | grep sybase | awk '{ T+=($10/1024/1024) } END { print T }'
elif ipcs -ma | grep oracle > /dev/null ; then
  echo Oracle
  ipcs -ma  | grep oracle | awk '{ T+=($10/1024/1024) } END { print T }'
fi

Padow
 

4 More Discussions You Might Find Interesting

1. AIX

Problem with migrating from AIX 5.1 to 5.3

I'am migrating from AIX 5.1 to 5.3 during migration installation a receive message enough space for dir /usr. My question is : how i can resolve this problem ? i can't reboot my server i hope that there is a command to obtain a spece without go out from installation procedure pannel... I'am... (0 Replies)
Discussion started by: tt155
0 Replies

2. Red Hat

RHCE Servers Online Learning Resources..

Anybody knows about any reliable source where i can study Linux servers while sitting at my home. A single bit of information in this regards will be highly appreciated. thanks :-) (3 Replies)
Discussion started by: salman103
3 Replies

3. AIX

AIX Servers Ugrading or Migrating

:( Hi Grue, I am very new in AIX/UNIX environment. Please give me answer that during the upgrading or Migrating to 6.1 the AIX Server the applications of this server is accessible to Apps users or not? Thanks (2 Replies)
Discussion started by: Tahniet
2 Replies

4. AIX

Upgrading to AIX 7 vs migrating

Hi all, I have this weird notion that upgrading the TL does not cause the machine to wipe, but upgrading a major version (from aix 6 to 7) means it's actually a fresh install and will wipe the date and i have to install the software again (TSM server, for instance). Trying to google it, i came... (3 Replies)
Discussion started by: tde3000
3 Replies
IPCS(1) 						    BSD General Commands Manual 						   IPCS(1)

NAME
ipcs -- report System V interprocess communication facilities status SYNOPSIS
ipcs [-abcMmopQqSsTt] DESCRIPTION
The ipcs utility provides information on System V interprocess communication (IPC) facilities on the system. The options are as follows: -a Show the maximum amount of information possible when displaying active semaphores, message queues, and shared memory segments. (This is shorthand for specifying the -b, -c, -o, -p, and -t options.) -b Show the maximum allowed sizes for active semaphores, message queues, and shared memory segments. The ``maximum allowed size'' is the maximum number of bytes in a message on a message queue, the size of a shared memory segment, or the number of semaphores in a set of semaphores. -c Show the creator's name and group for active semaphores, message queues, and shared memory segments. -M Display system information about shared memory. -m Display information about active shared memory segments. -o Show outstanding usage for active message queues, and shared memory segments. The ``outstanding usage'' is the number of messages in a message queue, or the number of processes attached to a shared memory segment. -p Show the process ID information for active semaphores, message queues, and shared memory segments. The ``process ID information'' is the last process to send a message to or receive a message from a message queue, the process that created a semaphore, or the last process to attach or detach a shared memory segment. -Q Display system information about messages queues. -q Display information about active message queues. -S Display system information about semaphores. -s Display information about active semaphores. -T Display system information about shared memory, message queues and semaphores. -t Show access times for active semaphores, message queues, and shared memory segments. The access times is the time of the last con- trol operation on an IPC object, the last send or receive of a message, the last attach or detach of a shared memory segment, or the last operation on a semaphore. If none of the -M, -m, -Q, -q, -S, or -s options are specified, information about all active IPC facilities is listed. RESTRICTIONS
System data structures may change while ipcs is running; the output of ipcs is not guaranteed to be consistent. BUGS
This manual page is woefully incomplete, because it does not at all attempt to explain the information printed by ipcs. SEE ALSO
ipcrm(1) AUTHORS
Thorsten Lockert <tholo@sigmasoft.com> BSD
June 18, 1994 BSD
All times are GMT -4. The time now is 04:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy