Sponsored Content
Operating Systems Solaris how to find exact memory used by oracle Post 302409822 by jim mcnamara on Friday 2nd of April 2010 05:16:31 PM
Old 04-02-2010
Reboot - that won't work

prstat -a -s size -U oracle on a box with 64GB of memory:
Code:
           time  Sort by process execution time.
indca56d ng02cprd: [/local/banner/prod_envs/banner_prod/links]
appworx> prstat -a -s size -U oracle
   PID USERNAME  SIZE   RSS STATE  PRI NICE      TIME  CPU PROCESS/NLWP
 29612 oracle     11G   10G sleep   59    0   0:00:43 0.0% oracle/11
 11081 oracle     11G   10G sleep   59    0   0:00:55 0.0% oracle/11
  2379 oracle     11G   10G sleep   59    0   0:00:11 0.0% oracle/11
  5925 oracle     11G   10G sleep   59    0   0:01:59 0.0% oracle/11
  5274 oracle     11G   10G sleep   59    0   3:00:10 0.0% oracle/258
 21599 oracle     11G   10G sleep   59    0   0:00:39 0.0% oracle/11
  5294 oracle     11G   10G sleep   59    0  24:38:00 0.0% oracle/23
 26662 oracle     10G   10G sleep   58    0   0:00:34 0.2% oracle/1
 26735 oracle     10G   10G sleep   59    0   0:00:42 0.0% oracle/1
 18869 oracle     10G   10G sleep   59    0   0:00:54 0.0% oracle/1
  5974 oracle     10G   10G sleep   59    0   0:00:31 0.0% oracle/1
 26002 oracle     10G   10G sleep   59    0   0:00:16 0.0% oracle/1
 26637 oracle     10G   10G sleep   59    0   0:00:32 0.0% oracle/1
 22860 oracle     10G   10G sleep   59    0   0:02:17 0.2% oracle/1
  4678 oracle     10G   10G sleep   59    0   0:00:14 0.0% oracle/1
 19121 oracle     10G   10G sleep   59    0   0:01:02 0.0% oracle/1
 18188 oracle     10G   10G sleep   59    0   0:00:11 0.0% oracle/1
  9292 oracle     10G   10G sleep   59    0   0:00:23 0.0% oracle/1
 19079 oracle     10G   10G sleep   59    0   0:00:32 0.0% oracle/1
 29669 oracle     10G   10G sleep   59    0   0:00:26 0.0% oracle/1
  6546 oracle     10G   10G sleep   59    0   0:00:47 0.0% oracle/1
 28970 oracle     10G   10G sleep   59    0   0:01:44 0.0% oracle/1
 18681 oracle     10G   10G sleep   59    0   0:01:18 0.0% oracle/1
  5366 oracle     10G   10G sleep   59    0   0:02:02 0.2% oracle/1
 29632 oracle     10G   10G sleep   59    0   0:00:33 0.0% oracle/1
  4662 oracle     10G   10G sleep   59    0   0:00:25 0.0% oracle/1
 25211 oracle     10G   10G sleep   59    0   0:01:44 0.2% oracle/1
  7754 oracle     10G   10G sleep   59    0   0:00:44 0.0% oracle/1
 28116 oracle     10G   10G sleep   59    0   0:01:48 0.0% oracle/1
 13614 oracle     10G   10G sleep   59    0   0:01:06 0.0% oracle/1
 NPROC USERNAME  SIZE   RSS MEMORY      TIME  CPU
   349 oracle   3359G 3345G   100%  59:46:48 3.8%

The memory reported is HUGE. This is because oracle uses large hunks of shared memory - e.g., SGA. So the same memory get reported over & over & over. A 64GB machine does not usually have 3.5TB of virtual memory, much less RAM. At least this one does not. It's a v440.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to find the exact pattern from a file?

Hi Let say there is a file a.txt which contain number rows. My intention is to find the number of occurences of a pattern. Let say the pattern is mdbase. then it should not count the occurences of mdbase1 or mdbase2 like this. When I tried to find it like grep "/backup/surjya/mdbase"... (7 Replies)
Discussion started by: surjyap
7 Replies

2. Solaris

Find an exact string

Hii,., Can some one guide me ...how to find a exact word or string using "grep" not a part of some other string. say if i need 321 it should not give me 3210 nor 1321 it should only give me line containing string 321 Thanks and Regards, Joy (2 Replies)
Discussion started by: gr8pals
2 Replies

3. UNIX for Dummies Questions & Answers

Find exact string

Hi Guys, File is containing data Col1 Col2 ListPrice List Price Price Average Selling Price - Actual ProjPrice Average Selling Price ProjPrice Launch Price ProjCost Cost Now i need to print col2 on the basis of col1 i.e if i Pass Price it should display only "Average... (7 Replies)
Discussion started by: Swapna173
7 Replies

4. Shell Programming and Scripting

Find Exact word in file

Hi ALL, I want to search one string “20 “ i.e 20 with space. But my file where I am searching this “20 “ contain some data like 120 before image file truncated 220 Reports section succeeded 20 Transaction database .prd stopped 220 Reports section completed. When I search for the... (5 Replies)
Discussion started by: Jeevan Salunke
5 Replies

5. Solaris

How to find Total and Free Physical Memory and Logical Memory in SOLARIS 9

Hi, Im working on Solaris 9 on SPARC-32 bit running on an Ultra-80, and I have to find out the following:- 1. Total Physical Memory in the system(total RAM). 2. Available Physical Memory(i.e. RAM Usage) 3. Total (Logical) Memory in the system 4. Available (Logical) Memory. I know... (4 Replies)
Discussion started by: 0ktalmagik
4 Replies

6. Shell Programming and Scripting

what is the find command to find exact dir from the root

I want to find a dir called STOP from the root.so what is the find command. Thanks & Regards Rajkumar (1 Reply)
Discussion started by: rajkumar_g
1 Replies

7. Shell Programming and Scripting

QUESTION1: grep only exact string. QUESTION2: find and replace only exact value with sed

QUESTION1: How do you grep only an exact string. I am using Solaris10 and do not have any GNU products installed. Contents of car.txt CAR1_KEY0 CAR1_KEY1 CAR2_KEY0 CAR2_KEY1 CAR1_KEY10 CURRENT COMMAND LINE: WHERE VARIABLE CAR_NUMBER=1 AND KEY_NUMBER=1 grep... (1 Reply)
Discussion started by: thibodc
1 Replies

8. AIX

How can I calculate exact memory used on AIX system?

I already checked memory on AIX with "svmon -G" and vmstat (as the figure). I see the value "inuse" nearly=97% use memory, free=3%. However, the value "pin=cache" nearly=26%. Can I calculate total free memory= free+ pin = 29% ? please help me! Thanks so much! (5 Replies)
Discussion started by: xuanthanhnk
5 Replies

9. Shell Programming and Scripting

To find the exact pattern

My Input : Hi editor this is the exact pattern which we looking for the previous patternmatch My code: awk '/pattern/ { print a } { a = $0 }' Current output : exact previous (3 Replies)
Discussion started by: Roozo
3 Replies

10. Shell Programming and Scripting

Grep to find an exact string

Hi all, I tried searching the forum for this, and I read numerous suggestions here and even on other forums, and I cannot get this to want the way that I need it to. I tried grep -W / -f to no luck. Here is what I have. I have a list of file names- FILE1-FILE1TEST,FILE1RELATION... (7 Replies)
Discussion started by: jeffs42885
7 Replies
MXGE(4) 						   BSD Kernel Interfaces Manual 						   MXGE(4)

NAME
mxge -- Myricom Myri10GE 10 Gigabit Ethernet adapter driver SYNOPSIS
To compile this driver into the kernel, place the following lines in your kernel configuration file: device firmware device mxge Alternatively, to load the driver as a module at boot time, place the following lines in loader.conf(5): if_mxge_load="YES" mxge_ethp_z8e_load="YES" mxge_eth_z8e_load="YES" mxge_rss_ethp_z8e_load="YES" mxge_rss_eth_z8e_load="YES" DESCRIPTION
The mxge driver provides support for PCI Express 10 Gigabit Ethernet adapters based on the Myricom LANai Z8E chip. The driver supports Transmit/Receive checksum offload, Jumbo Frames, TCP segmentation offload (TSO) as well as Large Receive Offload (LRO). For further hardware information, see http://www.myri.com/. For questions related to hardware requirements, refer to the documentation supplied with your Myri10GE adapter. All hardware requirements listed apply to use with FreeBSD. Support for Jumbo Frames is provided via the interface MTU setting. Selecting an MTU larger than 1500 bytes with the ifconfig(8) utility configures the adapter to receive and transmit Jumbo Frames. The maximum MTU size for Jumbo Frames is 9000. For more information on configuring this device, see ifconfig(8). HARDWARE
The mxge driver supports 10 Gigabit Ethernet adapters based on the Myricom LANai Z8E chips: o Myricom 10GBase-CX4 (10G-PCIE-8A-C, 10G-PCIE-8AL-C) o Myricom 10GBase-R (10G-PCIE-8A-R, 10G-PCIE-8AL-R) o Myricom 10G XAUI over ribbon fiber (10G-PCIE-8A-Q, 10G-PCIE-8AL-Q) LOADER TUNABLES
Tunables can be set at the loader(8) prompt before booting the kernel or stored in loader.conf(5). hw.mxge.flow_control_enabled Whether or not hardware flow control is enabled on the adapter. The default value is 1. hw.mxge.intr_coal_delay This value delays the generation of all interrupts in units of 1 microsecond. The default value is 30. hw.mxge.skip_pio_read This value determines whether or not the driver may omit doing a PIO read in the interrupt handler which ensures that the interrupt line has been deasserted when using xPIC interrupts. A non-zero value may result in lower CPU overhead, however it may also result in spurious interrupts. The default value is 0. This tunable has no effect when the device is using MSI or MSI-X interrupts. hw.mxge.max_slices This value determines the maximum number of slices the driver will attempt to use. The default value is 1. A slice is comprised of a set of receive queues and an associated interrupt thread. When using multiple slices, the NIC hashes traffic to different slices based on the value of hw.mxge.rss_hashtype. Using multiple slices requires that your motherboard and Myri10GE NIC both be capable of MSI-X. Older Myri10GE NICs can be field upgraded to add MSI-X using the "10G NIC Tool Kit" for FreeBSD which is available from http://www.myri.com/scs/download-10g-tools.html. hw.mxge.rss_hashtype This value determines how incoming traffic is steered to different slices. This tunable is ignored when using just a single slice. The legal values for this tunable are: 1 Hash on the source and destination IPv4 addresses. 2 Hash on source and destination IPv4 addresses and if the packet is TCP, then also hash on the TCP source and destination ports. 4 Hash on the TCP or UDP source ports. This is the default value. DIAGNOSTICS
mxge%d: Unable to allocate bus resource: memory A fatal initialization error has occurred. mxge%d: Unable to allocate bus resource: interrupt A fatal initialization error has occurred. mxge%d: Could not find firmware image %s The appropriate firmware kld module was not installed. This is a non-fatal initialization error, but will result in running in a reduced performance mode. SUPPORT
For general information and support, go to the Myricom support website at: http://www.myri.com/scs/. If an issue is identified with the released source code on the supported kernel with a supported adapter, email the specific information related to the issue to <help@myri.com>. SEE ALSO
altq(4), arp(4), netintro(4), ng_ether(4), ifconfig(8) HISTORY
The mxge device driver first appeared in FreeBSD 6.3. AUTHORS
The mxge driver was written by Andrew Gallatin <gallatin@FreeBSD.org>. BSD
February 13, 2008 BSD
All times are GMT -4. The time now is 05:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy