Sponsored Content
Operating Systems Solaris Negative impact on Oracle DB after Solaris recommended patching Post 302810529 by abhi_8029 on Wednesday 22nd of May 2013 02:27:41 AM
Old 05-22-2013
Hi os2mac,

nothing has changed in kernel parameters in /etc/system

Hi jim,
our DBA has logged call with Oracle and also shared the patches we applied last month to get a response from them. Lets wait and see what oracle has to say on this.

After checking logs, DBA could only confirm that there is very high Logical I/O activity. There is no wait I/O on the system and DBA also confirmed physical I/O is negligible from his logs.

Could it be that the high logical I/O is caused by some application defect ? Also we have lot of memory available on the system which is not used by oracle. Shall i ask DBA to increase SGA to include the free memory ? Will it help reduce the logical I/O. Any comments will be appreciated.
 

8 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

upgrade to solaris 9 - mysql impact

I have 4 solaris 8 servers running mysql 5.0.22. I am considering upgrading to solaris 9 and wanted to know if mysql needs to be recompiled for mysql to run under solaris 9. Thank you (4 Replies)
Discussion started by: csgonan
4 Replies

2. Solaris

impact of upgrading the SOLARIS OS from 5.6to 5.8

Please give me some idea about the impact of upgrading the SOLARIS OS from 5.6 to 5.8. We are using object store database of version 5.1. will there be any impact on this. Please help me in this regard. Thanks in advance. (1 Reply)
Discussion started by: vamshikrishnab
1 Replies

3. Solaris

Solaris 10 Recommended Patches

Does anyone get the following error message below when trying to download solaris 10 recommended patch? End-of-central-directory signature not found. Either this file is not a zipfile, or it constitutes one disk of a multi-part archive. In the latter case the central directory and... (8 Replies)
Discussion started by: Sarccastik Dude
8 Replies

4. Solaris

Solaris Trunking and its impact on VCS cluster and others

Hello guys, I have a question regarding link aggregation / trunking in Solaris 9 Sun Trunking does not come by default in Solaris 9 unlike Solaris 10 where we can use the "dladm" command to trunk 4 physical NIC interfaces together. My question is in Solaris 9. Will the configurations of... (1 Reply)
Discussion started by: br1an
1 Replies

5. Solaris

Recommended patchset for Solaris and the patch bundle

Hello I recently downloaded and installed the latest patchset for Solaris 10 (update 5) running on SPARC. Actually I am new to Solaris (I come from Red Hat) and the security department asked me to update the system for security fixes. I logged in to Oracle support and used the recommended patch... (3 Replies)
Discussion started by: abohmeed
3 Replies

6. Solaris

Oracle stopped updating Solaris 10 recommended patch cluster ?

Dear All, Has Oracle stopped updating Solaris 10 recommended patch cluster ? From suport.oracle.com i could see the last patch bundle was released on 11th july and there has been no updates after that. Does anyone know about any official announcement from oracle on this ? Thanks ... (1 Reply)
Discussion started by: abhi_8029
1 Replies

7. Solaris

Patching Procedure in Solaris 10 with sun cluster having Solaris zone

Hi Gurus I am not able to find the patching procedure for solaris 10 ( sol10 u11) to latest patchset with sun cluster having failover zones so that same I should follow. Take an instance, there are sol1 and sol2 nodes and having two failover zones like sozone1-rg and sozone2-rg and currently... (1 Reply)
Discussion started by: nick101
1 Replies

8. Solaris

No New Solaris 10 Recommended cluster in a few months

Hi Guys, I'm looking to download the latest patche cluster, we install them on a monthly basis. I have not seen anything released in the last couple months since January. Did I miss an announcement? Are they going to start releasing quarterly? Or is it just so happening there are no... (2 Replies)
Discussion started by: BG_JrAdmin
2 Replies
DBA_OPEN(3)								 1							       DBA_OPEN(3)

dba_open - Open database

SYNOPSIS
resource dba_open (string $path, string $mode, [string $handler], [mixed $...]) DESCRIPTION
dba_open(3) establishes a database instance for $path with $mode using $handler. PARAMETERS
o $path - Commonly a regular path in your filesystem. o $mode - It is r for read access, w for read/write access to an already existing database, c for read/write access and database creation if it doesn't currently exist, and n for create, truncate and read/write access. The database is created in BTree mode, other modes (like Hash or Queue) are not supported. Additionally you can set the database lock method with the next char. Use l to lock the database with a .lck file or d to lock the databasefile itself. It is important that all of your applications do this consis- tently. If you want to test the access and do not want to wait for the lock you can add t as third character. When you are abso- lutely sure that you do not require database locking you can do so by using - instead of l or d. When none of d, l or - is used, dba will lock on the database file as it would with d. Note There can only be one writer for one database file. When you use dba on a web server and more than one request requires write operations they can only be done one after another. Also read during write is not allowed. The dba extension uses locks to prevent this. See the following table: DBA locking +-------------+---------------+---+---+---+---+---+---+---+ |already open | | | | | | | | | | | | | | | | | | | | | $mode = "rl" | | | | | | | | | | | | | | | | | | | | $mode = "rlt" | | | | | | | | | | | | | | | | | | | | $mode = "wl" | | | | | | | | | | | | | | | | | | | | $mode = "wlt" | | | | | | | | | | | | | | | | | | | | $mode = "rd" | | | | | | | | | | | | | | | | | | | | $mode = "rdt" | | | | | | | | | | | | | | | | | | | | $mode = "wd" | | | | | | | | | | | | | | | | | | | | $mode = "wdt" | | | | | | | | | | | | | | | | | | +-------------+---------------+---+---+---+---+---+---+---+ | not open | | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | |$mode = "rl" | | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | wait | | | | | | | | | | | | | | | | | | | | false | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | |$mode = "wl" | | | | | | | | | | | | | | | | | | | | | wait | | | | | | | | | | | | | | | | | | | | false | | | | | | | | | | | | | | | | | | | | wait | | | | | | | | | | | | | | | | | | | | false | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | |$mode = "rd" | | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | ok | | | | | | | | | | | | | | | | | | | | wait | | | | | | | | | | | | | | | | | | | | false | | | | | | | | | | | | | | | | | | |$mode = "wd" | | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | illegal | | | | | | | | | | | | | | | | | | | | wait | | | | | | | | | | | | | | | | | | | | false | | | | | | | | | | | | | | | | | | | | wait | | | | | | | | | | | | | | | | | | | | false | | | | | | | | | | | | | | | | | | +-------------+---------------+---+---+---+---+---+---+---+ ook: the second call will be successfull. owait: the second call waits until dba_close(3) is called for the first. ofalse: the second call returns false. oillegal: you must not mix "l" and "d" modifiers for $mode parameter. o $handler - The name of the handler which shall be used for accessing $path. It is passed all optional parameters given to dba_open(3) and can act on behalf of them. RETURN VALUES
Returns a positive handle on success or FALSE on failure. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 4.3.0 | | | | | | | It's possible to open database files over net- | | | work connection. However in cases a socket con- | | | nection will be used (as with http or ftp) the | | | connection will be locked instead of the resource | | | itself. This is important to know since in such | | | cases locking is simply ignored on the resource | | | and other solutions have to be found. | | | | +--------+---------------------------------------------------+ SEE ALSO
dba_popen(3), dba_close(3). PHP Documentation Group DBA_OPEN(3)
All times are GMT -4. The time now is 01:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy