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
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
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
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
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
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
what are the major Difference Between run level & init level (2 Replies)
Discussion started by: rajaramrnb
2 Replies
7. Solaris
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
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
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
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
LEARN ABOUT HPUX
aio_cancel
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)