10-12-2009
Your DBA is referring to *.sga_max_size=8176279568 ~ 8 GB memory used, but *.pga_aggregate_target=2007986918 ~ 1,8 GB is also memory on your server consumed by your database.
Did you investigate if there is something very busy during such slownesses? Did topas or sar show CPUs near 100% or very busy disks?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
what is the reason oracle is giving ora-600 space leak error?
how to rectify this error? (6 Replies)
Discussion started by: varadakumar
6 Replies
2. UNIX for Advanced & Expert Users
Hi @all
Who's able to help me?
I've a running Oracle DB on AIX 4.3.3.
You've also an Oracle Client running for this.
So however, how it's possible, that I can see the CURRENT VERSION of my Oracle CLIENT. I've tried several things,
but it doesn't work. Thanks a lot!
Regards
Oliver :( :( (4 Replies)
Discussion started by: olli2002
4 Replies
3. AIX
Hello, mornig can you help me whit this error: "Oracle Universal Installer cannot be run"
and i can't start the installation of ORACLE 9i...
see you later (1 Reply)
Discussion started by: joseantoniohv
1 Replies
4. AIX
Hi All,
I need to update some AIX servers from 5.2 to 5.3 OR 6.1 .
The management is pressing for 6.1, but on our systems runs Oracle 9.2.0 .
I couldn't find any clear warning about the possibility of compatibility issues between AIX 6.1 and Oracle 9.2.0 but, on the other hand, I couldn't find... (0 Replies)
Discussion started by: padawan75
0 Replies
5. AIX
Please read my issue!
My old server using:
- AIX system operating (5300-05-CSP-0000)
- WebSphere 6.1.0.21 (Fix Pack 21)
After I've upgraded version AIX
- AIX system operating (5300-09-02-0849)
- WebSphere 6.1.0.21 (Fix Pack 21)
I have 1 issue when I access home page:
"Error... (0 Replies)
Discussion started by: gamonhon
0 Replies
6. AIX
I have two IBM_9110-51A boxes
OS - fresh installs
5764-G03 TL 5300-10-00 disks dated 5/2009
HACMP - fresh installs
HACMP for AIX 5L Base V5.4 5765-F62 dated 7/2006
Bottom line for smit output attempting 2 node cluster config
... (2 Replies)
Discussion started by: DrKillPatient
2 Replies
7. AIX
Hi All,
I have this fix for AIX (5300-06-06-0811) and i need to install it.
How can i do this?
What are the prerequisites for this fix?
Thanks (1 Reply)
Discussion started by: lucaxvu
1 Replies
8. AIX
Hi,
we need to upgrade from aix 5.3 oracle 9 to aix 6.1 oracle 11.
Our base interest is on vmo and disk setup
On aix 5.3 we change lru_file_repage to 0.
We split disk layout ( emc cx4 ) to tree volume groups:
- one for data base files ( one filesystem over two lun/hdiskpower, block size... (5 Replies)
Discussion started by: prebila
5 Replies
9. AIX
I'm having this trouble when smit update_all.
==========================================================
MISSING REQUISITES: The following filesets are required by one or more
of the selected filesets listed above. They are not currently installed
and could not be found on the... (5 Replies)
Discussion started by: liberatti
5 Replies
10. AIX
Hello All,
I was approached by DBAs, and they want me to create a large_page on AIX and also change oracle file systems to CIO.
They are complaining the system is taking longer time for processing and we are unnecessary wasting memory and CPU for file system cache.
To do that I have to change... (12 Replies)
Discussion started by: m6248m
12 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)