Sponsored Content
Full Discussion: Disable async IO at OS level
Operating Systems AIX Disable async IO at OS level Post 302965365 by Maddy123 on Wednesday 27th of January 2016 10:10:45 PM
Old 01-27-2016
Disable async IO at OS level

Hi ,

User claims that report refresh is taking longer time than usual time and asking us to disable async IO at OS level.

1 DB is running in this server
This is prod server
OS -- AIX

My question is would there be an impact to database and server if we disable async IO in OS?
is this the right way to fix the issue?

I found following note from Oracle document relevant to my change. Could you please check and comment on this?
Quote:
DISK_ASYNCH_IO controls whether I/O to datafiles, control files, and logfiles is asynchronous (that is, whether parallel server processes can overlap I/O requests with CPU processing during table scans). If your platform supports asynchronous I/O to disk, Oracle recommends that you leave this parameter set to its default value. However, if the asynchronous I/O implementation is not stable, you can set this parameter to false to disable asynchronous I/O. If your platform does not support asynchronous I/O to disk, this parameter has no effect.

If you set DISK_ASYNCH_IO to false, then you can increase DB_WRITER_PROCESSES or use DBWR_IO_SLAVES to simulate asynchronous I/O.
Regards,
Maddy

Last edited by Maddy123; 01-27-2016 at 11:17 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

async vs sync shells

I am calling a shell script using PL/SQL stored procedures. This works great but I need the calls to be run synchronously and not asynchronously. I need the shell script to finish before returning control back to the procedure. Any ideas? (3 Replies)
Discussion started by: ted5547
3 Replies

2. UNIX for Dummies Questions & Answers

Async or Sync I/O on NFS ?

Solaris 2.8 I know regular filesystems use Async I/O on Solaris 2.8. Does anybody know if NFS uses Sync I/O or Async I/O ? (1 Reply)
Discussion started by: marist89
1 Replies

3. Solaris

Async DNS request

Yes, really can't find anything about this. Can anyone suggest a way, how to do it? This is really what I need for. I need for may be list of system calls to read about or probably some C\C++ sources... Please, help... (1 Reply)
Discussion started by: LocalStorm
1 Replies

4. UNIX for Advanced & Expert Users

How to disable application level logs in Unix?

Hi, I'm working in an application and the related Java code and the envrionment is in Unix server. We are generating the log messages using loggers of Java.util.log . But, the logs are not getting generated in the log files. We feel that the people who developed the system might have done some... (6 Replies)
Discussion started by: kelangovan
6 Replies

5. Red Hat

Difference between sync & async in nfs

Hi All.... This is related to exporting a file system through nfs. Just wanted to understand the significance of sync/async in nfs. We give this entry in /etc/export file. What is the difference between these two. Any hep is appreciated. Regards, Amol. (2 Replies)
Discussion started by: Amol21
2 Replies

6. Solaris

Difference between run level & init level

what are the major Difference Between run level & init level (2 Replies)
Discussion started by: rajaramrnb
2 Replies

7. Solaris

see if async i/o is enabled in Solaris 9

Hi guys. This may be a stupid question but I am trying to see if my Solaris 9 server has async i/o enabled... Is there a quick way to determine this? Thanks in advance. (1 Reply)
Discussion started by: jamie_collins
1 Replies

8. Red Hat

SSL/TLS renegotiation DoS -how to disable? Is it advisable to disable?

Hi all Expertise, I have following issue to solve, SSL / TLS Renegotiation DoS (low) 222.225.12.13 Ease of Exploitation Moderate Port 443/tcp Family Miscellaneous Following is the problem description:------------------ Description The remote service encrypts traffic using TLS / SSL and... (2 Replies)
Discussion started by: manalisharmabe
2 Replies

9. Red Hat

SSL certificate generation on OS level or application level

We have a RHEL 5.8 server at the production level and we have a Java application on this server. I know of the SSL certificate generation at the OS (RHEL) level but it is implemented on the Java application by our development team using the Java keytool. My doubt is that is the SSL generation can... (3 Replies)
Discussion started by: RHCE
3 Replies

10. Programming

Async webpage read

hi i need to asynchronous connect to webpage which has only text file. need to read its content, line by line using linux socket. any samples? (1 Reply)
Discussion started by: leo2008
1 Replies
aio_cancel(2)							System Calls Manual						     aio_cancel(2)

NAME
aio_cancel() - cancel an asynchronous I/O operation SYNOPSIS
DESCRIPTION
The function attempts to cancel the asynchronous I/O request currently outstanding for the referenced by aiocbp or, if aiocbp is any asyn- chronous I/O operations currently outstanding for the file descriptor fildes. If an asynchronous I/O operation is successfully canceled as a result of its status is set to and any signal delivery specified for that operation is performed. Any outstanding requests that cannot be canceled as a result of the remain enqueued and are unaffected by the can- cellation request. Asynchronous I/O operations that are requested as a single logical operation are either completed or canceled atomically. Once any portion of the operation has started, it cannot be canceled. Whether or not and when an asynchronous I/O operation can be canceled depends on the nature of the request. If aiocbp is not fildes is ignored. To use this function, link in the realtime library by specifying on the compiler or linker command line. RETURN VALUE
The function returns one of the following values: The asynchronous I/O operation enqueued for the referenced by aiocbp or all asynchronous I/O operations enqueued for the file referenced by fildes have been successfully canceled. The asynchronous I/O operation enqueued for the referenced by aiocbp or at least one of the asynchronous I/O operations enqueued for the file referenced by fildes have not been canceled. (The function must be used to determine the status of individual operations.) The asynchronous I/O operation enqueued for the referenced by aiocbp or all of the asynchronous I/O operations enqueued for the file referenced by fildes completed before cancellation could be attempted. Failure. The requested cancellation could not be initiated. is set to indicate the error. ERRORS
If detects one of the following error conditions, is set to the indicated value: [EBADF] The aiocbp argument is and the fildes argument is not a valid file descriptor. [EINVAL] There was no asynchronous I/O operation enqueued for the referenced by aiocbp. SEE ALSO
aio_error(2), aio_fsync(2), aio_read(2), aio_return(2), aio_suspend(2), aio_write(2), lio_listio(2), aio(5). STANDARDS CONFORMANCE
aio_cancel(2)
All times are GMT -4. The time now is 05:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy