08-11-2017
Notice that Oracle relies heavily on shared memory: in addition to listing all the processes for the database you need to issue a ipcs -m th display the shared memory segments and analyse what you get there.
I am no Oracle expert but i recall vaguely that any Oracle instance will allocate only a certain amount of memory for all its processes and this value is configurable. I am not sure, anyhow, if this value is the SGA, the PGA or whatever - check this with the DBAs, they should know. It might be easier to do this than to list and add and analyse some OS-output.
I hope this helps.
bakunin
This User Gave Thanks to bakunin For This Post:
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
we are running red hat ES4 and i would like to know if there is anyway of restrcting the maximum amount of memory that a process can get? I have a single preocess that is taking >13GB.
Thanks,
Frank (4 Replies)
Discussion started by: frankkahle
4 Replies
2. Solaris
Hi All,
I am trying to find the physical memory usage by each process/users.
Can you please let me know how to get the memory usage?.
Thanks,
bsraj. (12 Replies)
Discussion started by: bsrajirs
12 Replies
3. Shell Programming and Scripting
hi all,
i want to write a script that checks the memory usage of processes and send a mail with the name of the process witch is using more then 300mb RAM.
dose anybody have a sample script or an idea how i can make it ?
PROCCESSES="snmpd sendmail"
for myVar in $PROCCESSES
do
... (7 Replies)
Discussion started by: tafil
7 Replies
4. HP-UX
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. HP-UX
I use pstat API to get Process Infomation
I would like to get a process
1.process owner
2.how many physical memory and virtual memory and total memory used(KB) and usage(%)
3.a process excution file create time
4.a process excution file access time
I do't know which attribute it i need
... (3 Replies)
Discussion started by: alert0919
3 Replies
6. UNIX for Advanced & Expert Users
Hi,
By using time command we can determine the execution time of a process or command.
bash-2.04$ time ls -l
total 0
-rw-r--r-- 1 admin tac 0 Oct 6 04:46 file1
-rw-r--r-- 1 admin tac 0 Oct 6 04:46 file2
real 0m0.002s
user 0m0.000s
sys 0m0.001s... (5 Replies)
Discussion started by: learn more
5 Replies
7. UNIX for Advanced & Expert Users
Hi Guys,
I work on a AIX environment and I'm trying to write a script where I can collect all the memory used by a process. Basically I'm executing the command 'ps -fu userid' to get all the process ids and then executing the 'ps v PID' to get all the memory allocated by PPID. My question is... (2 Replies)
Discussion started by: arizah
2 Replies
8. HP-UX
Hi all,
Is there any command which shows the virtual memory usage of a particular process in HP-UX machine.
I have tried with ps, top but could not get what I want.
Kindly provide me a solution.
Thanks in Advance
ARD (4 Replies)
Discussion started by: ard
4 Replies
9. Solaris
hi all gurus:
I want to find out Solaris process memory usage, but got a bit confused, see if any one can provide me some guidance.
i tend to use prstat -a to get total memory consumption by user (I know prstat likely have a bug that simply sum up the memory, regardless if the memory being... (5 Replies)
Discussion started by: oakville
5 Replies
10. UNIX for Beginners Questions & Answers
I can't check actual memory usage in the Redhat 5.5...
The used memory is 14214 Mb of Total 15919 by Free -m command.
I sum the RSS value on PS aux command result and the value is 5428.66Mb.
Yes It's quite different actual usage memory and RSS value.
So I added Shared memory value... (5 Replies)
Discussion started by: tom8254
5 Replies
LEARN ABOUT DEBIAN
bp_genbank2gff
BP_GENBANK2GFF(1p) User Contributed Perl Documentation BP_GENBANK2GFF(1p)
NAME
bp_genbank2gff.pl - Load a Bio::DB::GFF database from GENBANK files.
SYNOPSIS
% bp_genbank2gff.pl -d genbank -f localfile.gb
% bp_genbank2gff.pl -d genbank --accession AP003256
% bp_genbank2gff.pl --accession AP003256 --stdout
DESCRIPTION
This script loads a Bio::DB::GFF database with the features contained in a either a local genbank file or an accession that is fetched from
genbank. Various command-line options allow you to control which database to load and whether to allow an existing database to be
overwritten.
The database must already have been created and the current user must have appropriate INSERT and UPDATE privileges. The --create option
will initialize a new database with the appropriate schema, deleting any tables that were already there.
COMMAND-LINE OPTIONS
Command-line options can be abbreviated to single-letter options. e.g. -d instead of --database.
--create Force creation and initialization of database
--dsn <dsn> Data source (default dbi:mysql:test)
--user <user> Username for mysql authentication
--pass <password> Password for mysql authentication
--proxy <proxy> Proxy server to use for remote access
--stdout direct output to STDOUT
--adaptor <adaptor> adaptor to use (eg dbi::mysql, dbi::pg, dbi::oracle) --viral the genome you are loading is viral (changes tag
choices)
--source <source> source field for features ['genbank']
EITHER --file Arguments that follow are Genbank/EMBL file names
OR --gb_folder What follows is a folder full of gb files to process OR --accession Arguments that follow are genbank accession numbers
(not gi!)
OR --acc_file Accession numbers (not gi!) in a file (one per line, no punc.)
OR --acc_pipe Accession numbers (not gi!) from a STDIN pipe (one
per line)
SEE ALSO
Bio::DB::GFF, bulk_load_gff.pl, load_gff.pl
AUTHOR
Scott Cain, cain@cshl.org
Copyright (c) 2003 Cold Spring Harbor Laboratory
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See DISCLAIMER.txt for
disclaimers of warranty.
perl v5.14.2 2012-03-02 BP_GENBANK2GFF(1p)