Sponsored Content
Operating Systems AIX Oracle 9.2.0.1.0 on AIX 5300-07 Post 302361091 by cero on Monday 12th of October 2009 07:54:03 AM
Old 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

aix-oracle

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

Oracle and AIX

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

oracle 9i on AIX 5.2

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

AIX 6.1 and Oracle 9.2.0

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

Issue "Error 404" when upgrade AIX 5300-05-CSP-0000 to AIX (5300-09-02-0849)

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

HACMP 5.4 with AIX 5300-10 not working

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

How to install AIX Fix Pack 5300-06-06-0811

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

aix 61 and oracle 11

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

AIX 5300-05-06-0000 to 5300-09-00-0846 FAILED

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

AIX and Oracle

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
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)
All times are GMT -4. The time now is 04:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy