12-27-2007
Oracle processes usually allocate a chunk of memory when they startup. So it might be possible that 100% of your memory is being used by oracle processes. It might not be noticable (or it just might be), but I suggest not setting up any more oracle instances. If you are going to, then you need to add memory to your system.
9 More Discussions You Might Find Interesting
1. Programming
i am currently using c functions such as getprocs and statsfs to obtain process information and filesystem information on machines running aix 4.3.3.0. (soon to be running aix5.1) is there a function available to access information similar to the information provided by a vmstat command? i also... (1 Reply)
Discussion started by: briansmith40
1 Replies
2. Programming
I'm trying to write a C program to view server statistics such as:
- server general information
- CPU usage
- memory usage
- running processes
Cany anybody gives me hints on those system calls ??
ps: I'm using Tru64 unix (6 Replies)
Discussion started by: Agent007
6 Replies
3. Shell Programming and Scripting
Suppose that I am performing some operation on an sql database. Lets say process of Searching and then if a value is found, updating it... Now, when I have some millions of records on which the operation has to be performed... Does it help to spawn multiple processes each executing the same... (9 Replies)
Discussion started by: Legend986
9 Replies
4. UNIX for Advanced & Expert Users
Is there any way to get the file descriptor statistics of a socket file descriptor? I know that the fstat, stat system calls are for this purpose, but I want to know it there any way to get socket connection statistics for a file descriptor(like socket flags, connection type etc).
Does /proc... (3 Replies)
Discussion started by: comp_wizard07
3 Replies
5. UNIX for Advanced & Expert Users
Is there a way to monitor certain processes and if they hang too long to kill them, but certain scripts which are expected to take a long time to let them go?
Thank you
Richard (4 Replies)
Discussion started by: ukndoit
4 Replies
6. Solaris
Hi
Is there an easy way to identify and group currently running processes into OS processes and APP processes. Not all applications are installed as packages.
Any free tools or scripts to do this?
Many thanks. (2 Replies)
Discussion started by: wilsonee
2 Replies
7. Shell Programming and Scripting
Hi,
I have 3 columns in a file listed below.
X Y X/(X+Y)
1 1 0.5
1 1 0.5
4 1 0.8
1 1 0.5
6 1 0.857142857
1 1 0.5
23 1 0.958333333
Now I want to find confidence interval using the formula for each row.
(p-2 sqrt p(1-p)/(x+y), p+2... (7 Replies)
Discussion started by: Diya123
7 Replies
8. UNIX for Dummies Questions & Answers
Hi,
Can someone advise what "generic" command can I use to show statistics of a process or a running script/process?
For example, I want to know how many hours/minutes it's taken to run or has been running, how much CPU it used and how much memory it used or uses.
I want to be able to... (2 Replies)
Discussion started by: newbie_01
2 Replies
9. Shell Programming and Scripting
Hello every body
if I want to get the following statistics from a text file
1- sorted the n frequent words
2- sorted the n frequent characters
3- sorted the n frequent diagrams (tow letter together like th OR he)
4- sorted frequent n trigrams like (the OR all etc. )
5- any character... (10 Replies)
Discussion started by: khaled79
10 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::oracle
SQL::ReservedWords::Oracle(3pm) User Contributed Perl Documentation SQL::ReservedWords::Oracle(3pm)
NAME
SQL::ReservedWords::Oracle - Reserved SQL words by Oracle
SYNOPSIS
if ( SQL::ReservedWords::Oracle->is_reserved( $word ) ) {
print "$word is a reserved Oracle word!";
}
DESCRIPTION
Determine if words are reserved by Oracle Database.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either Oracle7, Oracle8i, Oracle9i or Oracle10g.
is_reserved_by_oracle7( $word )
Returns a boolean indicating if $word is reserved by Oracle7.
is_reserved_by_oracle8( $word )
Returns a boolean indicating if $word is reserved by Oracle8i.
is_reserved_by_oracle9( $word )
Returns a boolean indicating if $word is reserved by Oracle9i.
is_reserved_by_oracle10( $word )
Returns a boolean indicating if $word is reserved by Oracle10g.
reserved_by( $word )
Returns a list with Oracle versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_oracle7
is_reserved_by_oracle8
is_reserved_by_oracle9
is_reserved_by_oracle10
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://www.oracle.com/technology/documentation/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::Oracle(3pm)