08-07-2010
ORACLE Database running slow on AIX ( nmon / topas )
Hello,
How can I know if ORACLE Database is running slow due to Memory or due to processing power ?
I have only Oracle Database running on a P4 with 4GB RAM.
Could anyone suggest any tools which can help me determine exactly if it is memory issue or processor issue.
8 More Discussions You Might Find Interesting
1. AIX
hi,
how can i diplay:
- the ammount RAM used /free
- ammount of ram used from a pid or prozess
we have the problem, that malloc is returing a NULL pointer errno = 12 ( not enough space).
but i think there is still ram free.
nmon : shows all memory used ?
Memory Use Physical Virtual... (7 Replies)
Discussion started by: Lazzar
7 Replies
2. Filesystems, Disks and Memory
Hi,
I am running an oracle db 9.2.0.5.0 on ibm p5 550 aix 5.3 with 10g ram, 10G swap space 3 database instances each SGA about 500Meg.
I am getting the following error in my alert log file from time to time:
skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
... (0 Replies)
Discussion started by: hawkerpacific
0 Replies
3. AIX
good morning
what is the better solution to examen a P570 ?
because i use topas and nmon, and the results are totally different !!!
with nmon, i have 80% free cpu, and with nmon, i have 90% of used cpu !!!!!!
i take a shot with an intervall of 10s during 10 mn.
thank you (0 Replies)
Discussion started by: pascalbout
0 Replies
4. AIX
Is there a 'top' command equivalent in AIX 4.2 ?
I already checked and I do not see the following ones anywhere:
top
nmon
topas (1 Reply)
Discussion started by: Browser_ice
1 Replies
5. Solaris
what is the command to see which database ie..oracle in running on solaris 10 (2 Replies)
Discussion started by: tv.praveenkumar
2 Replies
6. Shell Programming and Scripting
Hi Guys,
Need you help in one point!
I am working on one shell script which takes following steps :
1. Taking one query result from oracle database
2. Exporting that result to Xls file
3. Mailing that file to my own mail ID
Now, I want to give a threshold limit to one of the column... (0 Replies)
Discussion started by: Agupte
0 Replies
7. AIX
Hello,
Please help me with a script with which I can check long running processes on the database server and the os is AIX.
Best regards,
Vishal (5 Replies)
Discussion started by: Vishal_dba
5 Replies
8. AIX
Hello,
All the commands on AIX are running very slow.
Below is few stats but I didn't find any issue in cpu or memory reosurces
vmstat
System configuration: lcpu=4 mem=6144MB ent=1.00
kthr memory page faults cpu
----- -----------... (2 Replies)
Discussion started by: Vishal_dba
2 Replies
LEARN ABOUT PHP
oci_server_version
OCI_SERVER_VERSION(3) OCI_SERVER_VERSION(3)
oci_server_version - Returns the Oracle Database version
SYNOPSIS
string oci_server_version (resource $connection)
DESCRIPTION
Returns a string with the Oracle Database version and available options
PARAMETERS
o $connection
-
RETURN VALUES
Returns the version information as a string or FALSE on error.
EXAMPLES
Example #1
oci_server_version(3) example
<?php
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
echo "Server Version: " . oci_server_version($conn);
// Displays:
// Server Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
// With the Partitioning, OLAP, Data Mining and Real Application Testing option
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ociserverversion(3) instead. This old name still can be used. However it is deprecated
and not recommended.
SEE ALSO
oci_client_version(3).
PHP Documentation Group OCI_SERVER_VERSION(3)